Home
Search results “Oracle left string sql”
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. Tool used in this tutorial is 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 E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ---------------------------------------------------------------------------- As the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 81778 Manish Sharma
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......
Tutorial#43  SUBSTR function in Oracle SQL Database| How to get substring from String/column
 
10:23
SQL Substr function will return a substring of a specified length from the source string beginning at a given position. or SQL find a character in a string or how to make use of a substr function or what is a substring function in Oracle Assignment link: https://drive.google.com/open?id=1q7WCcP-nb-kdVyRzqWXJE9hnLW2M-EMH 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 #SubstrFunction #SubstringFunctionSQL #OracleSubtr
Views: 217 EqualConnect Coach
Oracle Tutorial for Substr and Instr functions
 
09:19
This video explains how Oracle SubStr and Instr function works
Views: 5179 Ganesh Anbarasu
SQL TUTORIAL - CHARACTER FUNCTIONS || TRIM || REPLACE || CONCAT || SUBSTR || INSTR || REPLACE
 
08:04
In this video i'm going to demonstrate you about oracle sql single row functions step by step. concat funcation, substr function, instr function, lpad function, rpad function, trim function, replace function.
Views: 2758 OCP Technology
Tutorial#42  INSTR function in Oracle SQL Database| How to find position of substring
 
12:33
The Oracle INSTR function allows you to search a string for the occurrence of another string, and return the position of the occurrence within a string or find all occurrences of a substring in a string SQL or SQL find a character in a string or how to make use of Instr function or what is INSTR function in Oracle Assignment link: https://drive.google.com/open?id=1tKa7YJtreZn5mga7xGJrTlp5Vsv2pixm 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 #OracleSQLInstrFunction #SQLFunction #FreeMaterialForSQL
Views: 190 EqualConnect Coach
Oracle LPAD Function
 
04:27
https://www.databasestar.com/oracle-lpad/ The Oracle LPAD function is used to add extra characters to the left of a text value. This is called “padding”, and the function is called LPAD because the L stands for “left” and it “left pads” a text value. It’s the opposite of RPAD, which pads characters to the right of the value. The LPAD function can be useful for ensuring all values are the same length, or if there is another requirement you have for adding characters to the end. The syntax is: LPAD(expr, length [,pad_expression]) The expr parameter is the text value you want to pad or add characters to. The length is the total length the expression or value will be after the padding has been done. It’s not the number of characters to add. The pad_expression is an optional field and is the character or characters to add to the left end of the string. The default value is a space. If the length specified in the function is shorter than the length of the string, then the string is truncated to meet the length. For more information about the Oracle LPAD (and LPAD) function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-lpad/
Views: 696 Database Star
ascii,instr | sql functions | oracle database 11g version 2 |
 
07:21
executed in oracle database 11g version 2
Views: 262 Education 4u
Oracle Database11g tutorials 6 | | How to use Concatenation operator, character String
 
06:35
How to use concatenation operator for combining the output of two or more columns and how to use literal character string This SQL tutorial and Oracle database 11g tutorial for beginners will show How to use concatenation operator for combining the output of two or more columns and how to use literal character string Tool used in this tutorial is SQL developer. 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 You can download the Script which is used in this SQL tutorial from this link https://copy.com/XoSlBjq7yRzn 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 This is Manish from The Code makers
Views: 134511 Manish Sharma
Oracle SUBSTR and INSTR example
 
06:00
In this video, we will see how to use Oracle SUBSTR and INSTR functions in a nested manner.
Views: 2609 Ganesh Anbarasu
Oracle REPLACE Function
 
03:55
https://www.databasestar.com/oracle-replace/ The Oracle REPLACE function is a string manipulation function that allows you to replace one text string with another. It can be a whole word or sentence, or even a single value. The syntax of the REPLACE function is: REPLACE ( whole_string, string_to_replace, [replacement_string]) To use this function, the parameters are: - whole_string (mandatory): This is the string that will be checked for the characters to be replaced. - string_to_replace (mandatory): This is the string that will be searched for within whole_string. - replacement_string (optional): This is the string that will be used to replace occurrences of string_to_replace. Because the last parameter is optional, if it is not specified, then the Oracle REPLACE function removes all occurrences of string_to_replace. You can replace carriage returns with REPLACE, but you’ll need to use the CHR function. You can replace NULL values in Oracle, but this is best done with another function such as NVL, rather than REPLACE. If you want to replace multiple characters, you can do this using nested REPLACE functions or a REGEXP_REPLACE function. For more information about the Oracle REPLACE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-replace/
Views: 1182 Database Star
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: 3725 Kishan Mashru
Oracle LISTAGG Function
 
04:57
https://www.databasestar.com/oracle-listagg/ The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row. For example, it turns this data: FIRST_NAME Adam Brad Carrie Into this data: FIRST_NAME Adam, Brad, Carrie The same data is shown, but it’s in one row and not multiple. It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed. So what does it look like? The function is: LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause] These parameters are: measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory. delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma. order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory. query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows. One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB. Watch the video to find out more and see some examples. For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-listagg/
Views: 2968 Database Star
Oracle CAST Function
 
03:23
https://www.databasestar.com/oracle-cast/ The Oracle CAST function allows you to convert one data type to another. It’s similar to the TO_NUMBER, TO_DATE, and TO_CHAR functions, but allows for more functionality, including converting to many other data types. The syntax of the CAST function is: CAST( {expr | MULTISET (subquery) } AS type_name ) The structure of this function is different to other functions, because it uses the word AS to separate parameters rather than a comma. You can run this function like many other functions, on a single row, which would look like this: CAST( expr AS type_name ) Or, you can run it as though it’s a subquery, using the MULTISET feature: CAST( MULTISET (subquery) AS type_name ) The parameters of the CAST function are: - expr (mandatory choice): This is the value or expression that is to be converted to another data type. - MULTISET (optional): This keyword indicates that the subquery results will return multiple rows, and are then CAST into a collection value. If this is omitted, and the subquery returns multiple rows, it will only return a single row. - subquery (mandatory choice): This is the subquery that can be run to be converted into a collection data type. - type_name (mandatory): This is the Oracle data type that the expr or subquery will be converted to. There are several data types that are compatible with the CAST function, both for converting from and to. You can find the full list in the article mentioned below. For more information about the Oracle CAST function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-cast/
Views: 2236 Database Star
Oracle TO_DATE Function Explained with Examples
 
06:14
https://www.databasestar.com/oracle-to_date/ The Oracle TO_DATE function is one of the most useful conversion functions in Oracle. It can be a little confusing though. The TO_DATE function is used to convert a character value to a date value. You can use it to convert a string that is in the format of a date, into a date data type. Why would you use this? Converting a character to a date is helpful if you want to insert a date into a column in a table. Being specific about the format (explicit) is better than assuming the conversion will be done for you (implicit). This TO_DATE function only converts to a DATE data type. If you want to convert to the other datetime data types, you’ll have to use other functions such as TO_TIMESTAMP or TO_TIMESTAMP_TZ. The syntax for this function is: TO_DATE(charvalue [, format_mask [, nls_date_language]]) The parameters for this function are: Charvalue: This is the character value that you want to convert to a date. It’s the main input of the function. Format_mask: This is the format that the input value, the charvalue, is in. This is used to help convert your character value into a date, as your character may be in a different format to the default. Nls_date_language: this is used to determine how the output is displayed. For more information about the Oracle TO_DATE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_date/
Views: 1729 Database Star
String Functions used in Oracle SQL
 
13:09
#bagadhisateesh String Functions used in Oracle SQL
Views: 71 bagadhi sateesh
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
Views: 267 Oracle PL/SQL World
Oracle INSTR Function
 
03:28
https://www.databasestar.com/oracle-instr/ The Oracle INSTR function allows you to search a string for the occurrence of another string, and return the position of the occurrence within a string. It’s helpful for finding if a string exists within another string. It can also be used for performing further string manipulation on, like substrings. The syntax of the INSTR function is: INSTR(string, substring [, start_position [, occurrence]]) These parameters are: string: The text string that is searched in. It’s usually the larger of the two strings. Mandatory. substring: The text to search for. It’s usually the smaller of the two strings. Mandatory. start_position: This is an integer value which indicates where in the string value to start the search. Optional, and the default is 1. occurrence: The occurrence of the substring to search for. Optional, and the default is 1, which means the first occurrence. Also, the searches performed by the INSTR function are case-sensitive. The value returned by INSTR is a number value, which is the number in the location of the string where the substring is found. The first character is 1. For more information about the Oracle INSTR function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-instr/
Views: 5100 Database Star
Difference between substring and instring
 
06:04
Difference between substring and instring 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: 1186 TechLake
replace & substring | sql functions | oracle database 11g version 2 |
 
05:30
executed in oracle database 11g version 2
Views: 172 Education 4u
Oracle regular expression part 2 extracting substring regexp substr
 
08:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 5105 Sridhar Raghavan
Oracle - SQL - General Functions
 
07:06
Oracle - SQL - General Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
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: 31803 The Bad Tutorials
SQL : Substr function
 
03:36
In this tutorial, you'll learn how to make use of substring function...
Views: 10658 radhikaravikumar
CONCAT & PIPE "||" Operators in Oracle | Oracle Tutorials for Beginners
 
07:13
CONCAT & PIPE "||" Operators in Oracle | Oracle Tutorials for Beginners Oracle Tutorials for Beginners CONCAT Operators in Oracle SQL CONCAT Operators in Oracle Database CONCAT Operators in Oracle SQL Database || Operator in Oracle concatenate in oracle sql developer oracle concatenate columns with space oracle concatenate rows into string oracle concatenate string and number oracle concatenate all columns into string oracle concatenate columns with comma using concat function in oracle concatenate function in oracle 11g concatenate in oracle sql developer oracle sql concatenate column values concatenation operator in oracle concatenation operator in sql server oracle concatenate columns with space oracle concatenate string and number oracle concatenate rows into string concatenate in oracle sql query concatenate sql query concat sql server 2008 sql concatenate columns concatenate sql oracle sql concatenate rows mysql concatenate string sql concatenate string and int sql concatenate column values
Views: 877 Oracle PL/SQL World
SQL tutorial 51: DECODE function in Oracle Database By Manish Sharma (RebellionRider)
 
05:04
SQL Tutorial 51 Decode function in Oracle Database. ● What Is DECODE() ● DECODE ( ) vs CASE ● Syntax of DECODE() ● Query 1. String Matching using DECODE() ● Query 2. DECODE() comparing values form the COLUMN of the table Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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/ You can also Email me at [email protected] 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: 35236 Manish Sharma
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: 390 Puzzle Guru
Oracle - SQL - Character Functions
 
08:46
Oracle - SQL - Character Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SUBSTR in Oracle | SUBSTRING in Oracle | Character Manipulation | Oracle Tutorial for Beginners
 
12:06
SUBSTR in Oracle | SUBSTRING in Oracle | Character Manipulation | Oracle Tutorial for Beginners substr in oracle with example SUBSTR examples SUBSTR in Oracle SUBSTRING in Oracle Character Manipulation Oracle Tutorial for Beginners SUBSTR in Oracle SUBSTR in Oracle substr in oracle with example SUBSTRING in Oracle Oracle Tutorial for Beginners substr in oracle with example Oracle Database tutorials for Beginners SUBSTR SUBSTR substr in oracle with example regexp_substr in oracle oracle substring before character instr in oracle oracle substring right oracle length oracle sql substring after character oracle string functions Character Manipulation substr and instr together in oracle instr in oracle examples combination of substr and instr in sql instr example oracle instr last occurrence how to use instr and substr together in oracle instr in sql w3schools oracle sql substring after character
Views: 296 Oracle PL/SQL World
Tutorial#32 How to use INITCAP function in Oracle SQL | Make First Letter of String as Capital
 
04:26
Convert the first letter in the capital using INITCAP function in Oracle SQL or how to use the inticap function in SQL or SQL server capitalize the first letter of every word 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. Link for Assignment: https://drive.google.com/open?id=1N2CqFdll6kCl3u1F1VFW5P5byM3MOiLM 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: 169 EqualConnect Coach
Tutorial#36  LPAD function in Oracle SQL Database |  How to add string  at front of string
 
10:30
The Oracle LPAD function is used to add extra characters to the Left of a text value. This is called “padding” and the function is called LPAD because the L stands for “Left” and it “Left pads” a text value or How to use LPAD in Oracle SQL or Learn how to add strings with Lpad in SQL or How to use LPAD Function in Oracle SQL Database Assignment link: https://drive.google.com/open?id=1NH4ckL4A9exy4l1ast7TkvrrSPNnEc9h 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. Link for assignment: UPPERfunction in SQL https://drive.google.com/open?id=1ibjDTDX-CiPUShpf8j9kLkLjkYRdN9_e 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: 66 EqualConnect Coach
Oracle - SQL - Date Functions
 
07:56
Oracle - SQL - Date Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL : INSTR function
 
05:06
In this tutorial, you'll learn how to make use of Instr function...
Views: 19614 radhikaravikumar
How to use LTRIM,RTRIM & TRIM functions
 
06:40
How to use LTRIM, RTRIM & TRIM functions step by step.
Views: 6468 OCP Technology
Oracle SQL Tutorial 11 - CREATE TABLE
 
05:04
The way you create a table is to use the CREATE TABLE command. CREATE TABLE users() So in this situation, the name comes right after the TABLE keyword. The next thing we do is put all of the columns on a line that we want to put in our table. CREATE TABLE users( user_id, username, first_name, last_name ) Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore. if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50), first_name VARCHAR2(50), last_name VARCHAR2(50) ) Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes. CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR), first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns? So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2? Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 36488 Caleb Curry
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/
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI Tool used in this tutorial is 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 E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 87786 Manish Sharma
Oracle || Date functions Part-1 by dinesh
 
17:06
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 - DECODE
 
06:57
Oracle - DECODE
Views: 10779 Chris Ostrowski
Oracle - SQL - Conversion Functions
 
09:03
Oracle - SQL - Conversion Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
substr in oracle
 
02:57
Oracle function to extract portion of a string
Views: 648 Kunal Thaker
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: 282448 Manish Sharma
Oracle Database11g tutorials 12 || SQL Concat Function - SQL character manipulation function
 
04:47
Link for SQL concat function: http://www.rebellionrider.com/SQL-concat-function.htm SQL Concat function/SQL concat() function First function of SQL character manipulation function. Two have in depth knowledge of SQL concatenation operator Please watch my video on SQL concatenation Operator http://youtu.be/PYMeFe72Bas Tool used in this tutorial is 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 Link for SQL function introduction Video 10 http://youtu.be/5rx8Q4x4-qI Link SQL concat Article http://www.rebellionrider.com/SQL-concat-function.htm Contacts E-Mail [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 This is Manish from RebellionRider.com -------------------------------------------------------------------------------------------- SQL Concat () function is a Character manipulation function which is a category of SQL character function. We have already discussed the intro of SQL character function in Video 10. You can find link of this video in description below. Ok let's go ahead. SQL Concat () function concatenates two separate character string into one character string. Let's see the syntax Concat (string_1 , String_2) Note here that SQL Concat function takes only two arguments at a time. This SQL Concat function will return string_1 concatenated with string_2. This also means that it will return a single string which is a combined string of parameter String_1 and String_2. Both the parameters of SQL Concat function String_1 and string_2 can be of any data-type. You can even specify the columns of the table here. SQL Concat function is equivalent to the concatenation operator (||). SQL concatenation operator is represented by double solid vertical bars or we can say double pipe signs. Question: How to concatenate more than two strings as SQL Concat that can have only 2 parameters and what is the difference between SQL Concat Function and SQL concatenation operator? The one answer for the second Question What is the Difference between SQL Concat Function and SQL concatenation operator? Is While SQL Concat function takes only two parameters, The Concat operator can be repeated as often as is necessary. Meaning, by the help of SQL Concat operator you can combine as many strings as you want. And Concatenation operator is also not supported by several databases such as SQL server so this might cause problem. To answer the first question How to concatenate more than two strings as SQL Concat that can have only 2 parameters? We will have to jump over SQL developer. Let's see some examples. Say we want to retrieve the full name of an employee from Employees table. Let's try it using SQL Concat function. SELECT Concat (first_name, last_name) AS "Full Name" FROM employees; Here in this query we use two column names - first_name and last_name as arguments of our Concat function Execute. As you can see here, we get full name of our employee but there is no space in between first name and last name. We will see how to format this string using SQL Concat function in a few seconds But before that, let's see how to do the same task using SQL concatenation operator. SELECT first_name ||last_name AS "Full name" FROM employees; As you can see this query also produces the same result. Now we will see how to format full name of employees First we will do this using SQL concatenation Operator. SELECT first_name||' '||last_name AS "Full name" FROM employees; Now you can see we get space between first name and last name of the employee. Again, let's do it using SQL Concat function. Here we will see the nested function concept where we will be using nested Concat function to achieve this formatted string. SELECT Concat (Concat (first_name, ' '), last_name) FROM employees; Inner Concat function has two parameters. These are our first column name first_name and an empty string which will be a space between first name and second name. This Concat will now return a string which is the first name with space. This returning string will be the first input of our Outer Concat and column last_name will be the second input. All together this will give us the desired output. As you can see this method is complex than the first one where we use SQL concatenation operator.
Views: 79740 Manish Sharma
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: 2467 Kishan Mashru
length, concat & chr | sql functions | oracle database 11g version 2 |
 
05:24
executed in oracle database 11g version 2
Views: 149 Education 4u
SQL: TRIM function
 
06:35
In this tutorial, you'll learn how to use trim function 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: 2999 radhikaravikumar
SQL 12c Tutorial 10  : SQL Single Row Character Functions
 
10:30
SQL 12c Tutorial 10 : SQL Single Row Character Functions SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial Case Conversion Functions UPPER LOWER INITCAP Character Manipulation functions CONCAT LENGTH SUBSTR INSTR REPLACE TRANSLATE TRIM LTRIM RTRIM LPAD RPAD
Views: 285 TechLake
Learn Oracle | Data Types in PL SQL
 
13:14
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2566 Pebbles Tutorials
Oracle SQL Tutorial 10 - Whitespace, Case Sensitivity, and Comments
 
07:48
SELECT "Hello World" FROM DUAL The first thing you should know about writing queries is that this SQL is not whitespace sensitive. That means we can space this out however we wish. The only requirement is that you do not separate keywords out with spaces. They must be as one entity. Another gotcha is that when you are inside of quotes, whitespace becomes very important. That means if inside of a string you put a character and then 10 spaces, every single one of those spaces is going to part of that string: SELECT "Hello World" FROM DUAL The next thing you should notice is the capitalization. When we type SQL, by convention we capitalize all keywords. I personally really like this because you can easily see the difference between keywords and words that we created or use. But obviously we could capitalize the letters in the quotes. Keep in mind that this is a convention, meaning you do not have to follow this. Oracle is also case insensitive in that SELECT and select both do the same thing. Strings, once again, care about casing. Take this, for example: SELECT 'true' FROM DUALWHERE 'Hello' = 'Hello' And compare the results to this: SELECT 'true' FROM DUALWHERE 'Hello' = 'hello' Only the first one outputs the value true. Once we get into creating database objects such as tables with columns, those are not case sensitive either. That means instead of selecting from DUAL, you can select from DuAl Finally, I shall introduce you to comments. Comments allow you to tell the database engine that you want it to ignore a certain part of your code and not execute it. This is helpful if you want to document your code. It is also useful if you want to have multiple SQL statements open in one tab, but don't want to hover over the one you want to execute. You can comment out the ones you are not using and uncomment them when you are done. Using – will comment out the rest of the line, Using /* */ will comment everything between. This can even be used over multiple lines. But now, let's move onto the important stuff… CREATING TABLES!!!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 17837 Caleb Curry