Home
Search results “Reverse in string oracle”
ORACLE PL/SQL INTERVIEW : REVERSE NUMBER STRING PROGRAM
 
21:23
This video tutorial demonstrates on the oracle pl/sql interview question of reversing a number string without using the reverse function, the video explains a very simple and generic approach that can be used to solve this question.
Views: 2956 Kishan Mashru
PL/SQL: Program to Reverse a string
 
09:42
Category: Beginner In this tutorial, you'll learn how to write a program in order to reverse a string.
Views: 7109 radhikaravikumar
SQL Tutorial - 44: REVERSE() & STRCMP() Functions
 
03:23
In this tutorial we'll learn to reverse the order of characters in a string and also to compare two strings using the REVERSE and STRCMP functions respectively.
Views: 17788 The Bad Tutorials
TSQL: How To Reverse A String
 
04:43
Coding live, but surprisingly made it under 6 minutes! After double checking with Microsoft, both LEN and SUBSTRING are available in 2005, though the efficiency will matter more.
Views: 175 SQLInSix Minutes
Oracle || String functions Part-1 by dinesh
 
36:42
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
ORACLE PL/SQL INTERVIEW :PALINDROME NUMBER PROGRAM
 
11:45
This video tutorial demonstrates on the Oracle PL/SQL interview question of writing a program for finding whether a number or string is palindrome number or string or not, the video explains a very simple and generic approach that can be used to solve this question. You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/16
Views: 1940 Kishan Mashru
SQL Tutorial : Difference Between Translate &  Replace in SQL Oracle
 
06:36
SQL Tutorial : Difference Between Translate & Replace in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 406 TechLake
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 11424 Kishan Mashru
Oracle PL/SQL Tutorial - Strings
 
05:24
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html Instructor Lewis Cunningham explains strings in this InfiniteSkills tutorial on Oracle PLSQL. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
PLSQL Class13 StringFunctions INITCAP LENGTH CONCAT REVERSE
 
09:50
Course : PL SQL Topic : StringFunctions INITCAP LENGTH CONCAT REVERSE (10 m) Here i discussed String Functions Watch till end and add comment about the video like it ! share it !
String Reverse
 
07:56
Reverse the String without using the String function in C#
Views: 218 Job info solutions
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 16162 Kishan Mashru
Oracle Character Manipulation | REVERSE | LENGTH Functions | Oracle Tutorial for Beginners
 
04:21
Oracle Character Manipulation | REVERSE | LENGTH Functions | Oracle Tutorial for Beginners Oracle Tutorial for Beginners Oracle Tutorial for Beginners Oracle LENGTH Function Oracle REVERSE Functions Oracle SQL Tutorials for Beginners Oracle tutorials Oracle Character Manipulation Oracle Character Manipulation Character Manipulation Oracle 12c Oracle 18c Oracle In built Functions Oracle LENGTH() Oracle REVERSE() reversing string in oracle without using reverse function query to reverse a string in oracle how to reverse a string in oracle sql without using reverse function substr oracle reverse string using substr in oracle instr in oracle reverse function in oracle how to reverse a string in sql without using reverse function
Oracle regular expression part 2 extracting substring regexp substr
 
08:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 3695 Sridhar Raghavan
Strings in PL SQL Tutorial
 
07:35
Subscribe for more PL SQL tutorials https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg String Function & Purpose 1 ASCII(x); Returns the ASCII value of the character x. 2 CHR(x); Returns the character with the ASCII value of x. 3 CONCAT(x, y); Concatenates the strings x and y and return the appended string. 4 INITCAP(x); Converts the initial letter of each word in x to uppercase and returns that string. 5 INSTR(x, find_string [, start] [, occurrence]); Searches for find_string in x and returns the position at which it occurs. 6 INSTRB(x); Returns the location of a string within another string, but returns the value in bytes. 7 LENGTH(x); Returns the number of characters in x. TUTORIALSPOINT Simply Easy Learning Page 59 8 LENGTHB(x); Returns the length of a character string in bytes for single byte character set. 9 LOWER(x); Converts the letters in x to lowercase and returns that string. 10 LPAD(x, width [, pad_string]) ; Pads x with spaces to left, to bring the total length of the string up to width characters. 11 LTRIM(x [, trim_string]); Trims characters from the left of x. 12 NANVL(x, value); Returns value if x matches the NaN special value (not a number), otherwise x is returned. 13 NLS_INITCAP(x); Same as the INITCAP function except that it can use a different sort method as specified by NLSSORT. 14 NLS_LOWER(x) ; Same as the LOWER function except that it can use a different sort method as specified by NLSSORT. 15 NLS_UPPER(x); Same as the UPPER function except that it can use a different sort method as specified by NLSSORT. 16 NLSSORT(x); Changes the method of sorting the characters. Must be specified before any NLS function; otherwise, the default sort will be used. 17 NVL(x, value); Returns value if x is null; otherwise, x is returned. 18 NVL2(x, value1, value2); Returns value1 if x is not null; if x is null, value2 is returned. 19 REPLACE(x, search_string, replace_string); Searches x for search_string and replaces it with replace_string. 20 RPAD(x, width [, pad_string]); Pads x to the right. 21 RTRIM(x [, trim_string]); Trims x from the right. 22 SOUNDEX(x) ; Returns a string containing the phonetic representation of x. 23 SUBSTR(x, start [, length]); Returns a substring of x that begins at the position specified by start. An optional length for the substring may be supplied. 24 SUBSTRB(x); Same as SUBSTR except the parameters are expressed in bytes instead of characters for the single-byte character systems. 25 TRIM([trim_char FROM) x); Trims characters from the left and right of x. 26 UPPER(x); Converts the letters in x to uppercase and returns that string.
Views: 293 Puzzle Guru
SQL REVERSE() Function
 
01:33
The SQL REVERSE() is a function, and returns a string in which the character order of a specified string is reversed.
Views: 155 suresh babu
OracleSQL#37 How to Remove Character/Spaces/String from Column Using with  LTRIM function in Oracle
 
06:57
SQL LTRIM function removes all space characters from the left-hand side of a string or How to use Ltrim Function in Oracle SQL or how to remove spaces using LTRIM Function or How to use LTRIM, RTRIM & TRIM functions step by step. Assignment link: https://drive.google.com/open?id=1u4GKcVcBDBdHOmAzHKsfuAuEnPkK5WWe In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 40 EqualConnect Coach
Reverse PIVOT table in SQL Server
 
08:16
convert rows to columns sql pivot and unpivot table sql server pivot and unpivot examples in sql server undo pivot table sql server In this video we will discuss if it's always possible to reverse what PIVOT operator has done using UNPIVOT operator. Is it always possible to reverse what PIVOT operator has done using UNPIVOT operator. No, not always. If the PIVOT operator has not aggregated the data, you can get your original data back using the UNPIVOT operator but not if the data is aggregated. Let us understand this with an example. We will use the following table tblProductSales for the examples in this video. SQL Script to create tblProductSales table Create Table tblProductSales ( SalesAgent nvarchar(10), Country nvarchar(10), SalesAmount int ) Go Insert into tblProductSales values('David','India',960) Insert into tblProductSales values('David','US',520) Insert into tblProductSales values('John','India',970) Insert into tblProductSales values('John','US',540) Go Let's now use the PIVOT operator to turn ROWS into COLUMNS SELECT SalesAgent, India, US FROM tblProductSales PIVOT ( SUM(SalesAmount) FOR Country IN (India, US) ) AS PivotTable Now let's use the UNPIVOT operator to reverse what PIVOT operator has done. SELECT SalesAgent, Country, SalesAmount FROM (SELECT SalesAgent, India, US FROM tblProductSales PIVOT ( SUM(SalesAmount) FOR Country IN (India, US) ) AS PivotTable) P UNPIVOT ( SalesAmount FOR Country IN (India, US) ) AS UnpivotTable The above query reverses what PIVOT operator has done, and we get the original data back as shown below. We are able to get the original data back, because the SUM aggregate function that we used with the PIVOT operator did not perform any aggregation. Now execute the following INSERT statement to insert a new row into tblProductSales table. Insert into tblProductSales values('David','India',100) With this new row in the table, if you execute the following PIVOT query data will be aggregated SELECT SalesAgent, India, US FROM tblProductSales PIVOT ( SUM(SalesAmount) FOR Country IN (India, US) ) AS PivotTable Now if we use UNPIVOT opertaor with the above query, we wouldn't get our orginial data back as the PIVOT operator has already aggrgated the data, and there is no way for SQL Server to know how to undo the aggregations. SELECT SalesAgent, Country, SalesAmount FROM (SELECT SalesAgent, India, US FROM tblProductSales PIVOT ( SUM(SalesAmount) FOR Country IN (India, US) ) AS PivotTable) P UNPIVOT ( SalesAmount FOR Country IN (India, US) ) AS UnpivotTable Notice that for SalesAgent - David and Country - India we get only one row. In the original table we had 2 rows for the same combination. Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/reverse-pivot-table-in-sql-server.html
Views: 25589 kudvenkat
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE
 
21:53
The audio and video now synced. Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.
Views: 4319 Kishan Mashru
Strings in C | C Language Tutorial
 
33:34
Strings in C | C Language Tutorial C Language Tutorial Videos | Mr. Srinivas ** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/c-language-training/ ? For Online Training: https://nareshit.com/course/c-language-online-training/ -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 88638 Naresh i Technologies
Reverse Number Program in C | C Language Tutorial | Mr. Srinivas
 
05:35
Armstrong Number Program in C C Language Tutorial Videos | Mr. Srinivas ** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/c-language-training/ ? For Online Training: https://nareshit.com/course/c-language-online-training/ -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 67671 Naresh i Technologies
How to Parse XML in Oracle
 
13:54
This Video Shows 1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable. 3. Brief Introduction to XMLPATH
Views: 8132 yrrhelp
Strings -  Part 1 | C Language Tutorial
 
21:20
Strings - Part 1 | C Language Tutorial C Language Tutorial Videos | Mr. Srinivas ** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/c-language-training/ ? For Online Training: https://nareshit.com/course/c-language-online-training/ -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 136658 Naresh i Technologies
Corejava-String manipulation-part-1
 
33:18
This Video explains Corejava - String manipulation. Training Tutorial delivered by our Trainer Ratan. For more details visit : http://bit.ly/2d8XIN9 DURGASOFT is INDIA's No.1 Software Training Center Trainer Name : Mr.Ratan Course : Core Java Topic : String manipulation Methods of Training : Inclass, Online, Video based training Location : 2nd Floor, Canara Bank Building, S.R Nagar, Hyderabad-500032 Contact Phone : +91-8885252627,+91-7207212428,+91-7207212427, (US)+1-(443) 332-6786 Email : [email protected], [email protected] Other Courses We Offered : JAVA, OCJP/SCJP, .NET , ANDROID, HADOOP, TESTING TOOLS , ADF, INFORMATICA, TABLEAU, IPHONE, OBIEE, ANJULAR JS, SAP,etc. Enjoy and stay connected with us!! ►Subscribe us on Youtube: https://goo.gl/drpxPQ ►Like us: http://www.facebook.com/DurgaSoftOnline ►Follow us: http://www.twitter.com/durgasoftonline ►Circle us: https://plus.google.com/+DurgaSoftwareSolutions © 2016 Durga Software Solutions Pvt Ltd.
90. REVERSE Function in SQL (Hindi)
 
00:55
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 3858 Geeky Shows
ORACLE SQL INTERVIEW QUESTION : DIFFERENCE BETWEEN DELETE AND TRUNCATE
 
10:56
This video tutorial is on frequently asked interview question like the difference between delete and truncate statement in oracle sql, after watching this video you will understand more on the difference between both the statements and will be able to answer this interview question with a lot of confidence. Link to know more on HVM in oracle please refer to the link : https://youtu.be/uZ9BwzZx6lI
Views: 4056 Kishan Mashru
SQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions
 
04:34
In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.
Views: 28168 The Bad Tutorials
SQL Tutorial - 43: REPEAT() & REPLACE() Functions
 
02:25
In this tutorial we'll learn to repeat a string a few times and also replace a part or all of a string with another string using the REPEAT and REPLACE Functions respectively.
Views: 20041 The Bad Tutorials
Oracle - PL/SQL - Loops
 
07:27
Oracle - PL/SQL - Loops https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : DELETE DUPLICATE RECORDS FROM  A TABLE(3 ways)
 
13:15
This video tutorial demonstrates about how we can delete duplicate records from a table, the video shows 3 different ways to delete duplicate record from a table, one using Group by, second one by using correlated joins and third on by using rownum analytical function You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/21
Views: 3391 Kishan Mashru
Using Oracle Metadata to your Advantage Explained with real scenarios.
 
17:15
In this video I have explained who you can use the Oracle metadata tables to your advantage with real project scenarios and situations. The video is a little descriptive it gives you much more than just the syntax and the tables. All database offer a bunch of tables using which you can make smart inferences about your data,process and health of the database. I have explained the below tables in this video and how to use them smartly 1.All_Source 2.all_objects 3.All_tables 4.all_tab_cons 5.all_constraints I will be sharing more such places where we can use these metadata queries so don't forget to subscribe to my channel. If you can questions/clarifications just drop a comment and I will be more than happy to solve your queries.
Views: 2293 Tech Coach
Reverse Word Order in a String Challenge Part 2/3
 
11:41
Follow more CS videos @ http://hackercs.com... Please like, comment and subscribe so we can make more free CS videos :) *Executed Code: http://codepad.org/SFyws6ha *Full PDF: http://bit.ly/qO10eN
Views: 4518 Agilowen
String Functions in SQL Server part-IV || REPLACE, REPLICATE, REVERSE, RIGHT, RTRIM functions in SQL
 
03:57
This video will provide you the details of each string functions in SQL Server 2014. I'll be walking through each and every kinds of build in function which are available in SQL Server in my next videos. Previous video for more String Functions String Function Part I https://www.youtube.com/watch?v=6cgn44DZ7w8 String Function Part II https://www.youtube.com/watch?v=RmyT87mstzc String Function Part III https://www.youtube.com/watch?v=lQVnQKeGlf0 ***************************************************************************************** REPLACE (Transact-SQL) Replaces all occurrences of a specified string value with another string value.  Syntax REPLACE ( string_expression , string_pattern , string_replacement )  Arguments string_expression Is the string expression to be searched. string_expression can be of a character or binary data type. string_pattern Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string (''), and must not exceed the maximum number of bytes that fits on a page. string_replacement Is the replacement string. string_replacement can be of a character or binary data type.  Return Types Returns nvarchar if one of the input arguments is of the nvarchar data type; otherwise, REPLACE returns varchar. Returns NULL if any one of the arguments is NULL. If string_expression is not of type varchar(max) or nvarchar(max),REPLACE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to a large-value data type. ***************************************************************************************** REPLICATE (Transact-SQL) Repeats a string value a specified number of times.  Syntax REPLICATE ( string_expression ,integer_expression )  Arguments string_expression Is an expression of a character string or binary data type. string_expression can be either character or binary data. Note : If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to the appropriate large-value data type. integer_expression Is an expression of any integer type, including bigint. If integer_expression is negative, NULL is returned.  Return Types Returns the same type as string_expression. ***************************************************************************************** REVERSE (Transact-SQL) Returns the reverse order of a string value.  Syntax REVERSE ( string_expression )  Arguments string_expression string_expression is an expression of a string or binary data type. string_expression can be a constant, variable, or column of either character or binary data.  Return Types varchar or nvarchar ***************************************************************************************** RIGHT (Transact-SQL) Returns the right part of a character string with the specified number of characters.  Syntax RIGHT ( character_expression , integer_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convertcharacter_expression. integer_expression Is a positive integer that specifies how many characters of character_expression will be returned. If integer_expression is negative, an error is returned. Ifinteger_expression is type bigint and contains a large value, character_expression must be of a large data type such as varchar(max).  Return Types Returns varchar when character_expression is a non-Unicode character data type. Returns nvarchar when character_expression is a Unicode character data type. ***************************************************************************************** RTRIM (Transact-SQL) Returns a character string after truncating all trailing blanks.  Syntax RTRIM ( character_expression )  Arguments character_expression Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.  Return Types varchar or nvarchar
Views: 78 Softtech forum
PL/SQL: Factorial
 
08:14
In this tutorial, you'll learn how to write factorial program in plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4084 radhikaravikumar
Reverse Oracle w/Emily Davidson
 
04:54
Support these videos at patreon.com/divergentpathspod Introducing my speed round video segment, Reverse Oracle (name courtesy of Jen Hinkle) with a fun and quick five minute clip with cellist Emily Davidson. We cover ALL the really burning questions like: Sushi or Thai? Guilty pleasure music? And more! Stay tuned every week for more video content! And Listen to my full interview with Emily: http://apple.co/29y4i0u Support these videos at patreon.com/divergentpathspod Links: iTunes: http://apple.co/2abzLQn Facebook: facebook.com/divergentpathspod/ Twitter: @nycbassbone Instagram: @nycbassbone Stitcher: http://bit.ly/25LjA7y
Strings - Part 2 | C Language Tutorial
 
14:45
Strings - Part 2 | C Language Tutorial C Language Tutorial Videos | Mr. Srinivas ** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/c-language-training/ ? For Online Training: https://nareshit.com/course/c-language-online-training/ -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 75398 Naresh i Technologies
16. C Programs : REVERSE OF given number
 
11:55
Hi All, In this video you will learn c program to print reverse of a given number. Regards, Meganadha Reddy K.
Views: 9272 Meganadha Reddy
Oracle Tutorials : 6 - Writing Code in Oracle
 
10:01
Oracle Tutorials : 6 - Writing Code in Oracle
Views: 549 Meganadha Reddy
PL/SQL tutorial 31: Cursor For Loop With Parameterized Cursor In Oracle Database
 
04:24
PL/SQL tutorial 31 Database Cursor for loop part 2. Learn how to work with parameterized cursor using Cursor For Loop in Oracle Database By Manish Sharma at RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-with-parameter-cursor Previous Tutorial ► Cursor For Loop with Simple Cursor https://youtu.be/abgVNjPaMVA ►PL/SQL For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24439 Manish Sharma
String Handling | C Technical Interview Questions and Answers | Mr. Srinivas
 
03:37
String Handling | C Technical Interview Questions and Answers | Mr. Srinivas ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 2689 Naresh i Technologies
REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE
 
25:07
This video explains about ref cursor in oracle pl/sql, what are ref cursors, how are ref cursor different from simple cursors, what are the advantages of using a ref cursor etc. The video demonstrates proper and easy to understand examples on ref cursor.
Views: 8315 Kishan Mashru
SQL Tutorial - 42: The LENGTH() & INSERT() Functions
 
04:40
In this tutorial we'll learn to determine the length of strings and also to insert strings within other strings through the LENGTH() and INSERT() functions respectively.
Views: 19781 The Bad Tutorials
What is Hard-Coding in PL/SQL?
 
08:14
Practically Perfect PL/SQL with Steven Feuerstein See the first in a multi-video series that describes the nuances of hard-coding in PL/SQL. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
PL/SQL tutorial 43: Calling Notation for PL/SQL Subroutines in Oracle Database By Manish Sharma
 
09:15
RebellionRider.com back with another PL/SQL Tutorial explaining the concepts of Calling Notation for Subroutines such as Functions and Stored Procedures by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/calling-notation Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 18633 Manish Sharma
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
 
19:50
This video is to understand how to create an oracle pl/sql function, the video demonstrates the use of in, out and in out parameter types. The video also explains on how to call a function from a pl/sql block and from a select statement.
Views: 3320 Kishan Mashru
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
 
04:46
This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!
Views: 10570 Kishan Mashru
Sql Server Interview Questions and Answers Part 5(Custom Reverse Function )
 
05:47
Reverse any string without using Reverse Function
Views: 782 SS UNITECH
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 265076 Manish Sharma
Wrapping Oracle PL/SQL code
 
08:24
This video tutorial demonstrates the wrap utility of oracle.This utility can be used to wrap (encode) our plain text pl/sql code so that other developers cannot make changes to it, and we can keep our business logic and patent code safe through encoding. This video tutorial explains the same with a very easy example. and also talks about the advantages and disadvantages associated with the wrap utility.
Views: 1777 Kishan Mashru