Home
Search results “Oracle substring of string”
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: 79762 Manish Sharma
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: 117 EqualConnect Coach
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 Tutorial for Substr and Instr functions
 
09:19
This video explains how Oracle SubStr and Instr function works
Views: 4350 Ganesh Anbarasu
Oracle regular expression part 2 extracting substring regexp substr
 
08:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 4491 Sridhar Raghavan
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: 163 Oracle PL/SQL World
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: 2281 Ganesh Anbarasu
replace & substring | sql functions | oracle database 11g version 2 |
 
05:30
executed in oracle database 11g version 2
Views: 114 Education 4u
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/
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: 30300 The Bad Tutorials
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: 831 TechLake
Tutorial#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: 101 EqualConnect Coach
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: 131563 Manish Sharma
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: 33796 Manish Sharma
SQL : Substr function
 
03:36
In this tutorial, you'll learn how to make use of substring function...
Views: 10237 radhikaravikumar
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: 3392 Kishan Mashru
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: 4725 Database Star
Advanced unix String handling substr extraction find length of string array
 
07:46
Oracle SQL PLSQL and Unix Shell Scripting
Views: 456 Sridhar Raghavan
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: 92 EqualConnect Coach
UTL_MATCH : String Matching in Oracle
 
02:18
Use the UTL_MATCH package to determine the similarity between two strings. For more information see: https://oracle-base.com/articles/11g/utl_match-string-matching-in-oracle Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Danny Bryant Blog: http://dbaontap.com/ Twitter: https://twitter.com/dbcapoeira Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 3088 ORACLE-BASE.com
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: 2341 OCP Technology
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: 7863 radhikaravikumar
substr in oracle
 
02:57
Oracle function to extract portion of a string
Views: 627 Kunal Thaker
SQL 090 String Scalar, SUBSTRING or How can I get part of a string?
 
01:18
Explains the String Scalar Function SUBSTRING to retrieve part of a string. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 838 cbtinc
LTRIM Function In Oracle | Character Manipulation | Oracle SQL Tutorial for Beginners
 
04:53
LTRIM Function In Oracle | Character Manipulation | Oracle Tutorial for Beginners oracle sql tutorial for beginners LTRIM() Function in Oracle SQL LTRIM() Function in Oracle LTRIM() Function in SQL Oracle LTRIM Function ltrim and rtrim in oracle ltrim sql oracle trim function oracle string functions sql ltrim characters from string SQL TRIM Functions LTRIM Function in SQL LTRIM Function in Oracle RTRIM Function in SQL RTRIM FUnction in Oracle oracle trim multiple characters ltrim function in oracle oracle substring function How to remove space in Oracle String LTRIM and RTRIM in SQL LTRIM and RTRIM in Oracle
Função Oracle Substr
 
06:48
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função Oracle substr traz o pedaço da string de uma determinada variável. Ela pode receber até 3 parâmetros, onde o primeiro é a string a ser analisada, o segundo é a posição inicial que pode ser negativo se você for contar da direta para a esquerda(ou seja de traz para frente) e também como parâmetro opcional um terceiro inteiro que vai trazer o tamanho do caracter. SELECT substr('O Aprendaplsql é o melhor site', 3) FROM dual; SELECT substr('O Aprendaplsql é o melhor site', 3, 12) FROM dual; SELECT substr('O Aprendaplsql é o melhor site', -11, 6) FROM dual; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 897 Aprenda PL/SQL
Oracle CONCAT Function
 
02:40
https://www.databasestar.com/oracle-concat/ The Oracle CONCAT function allows you to concatenate, or combine, string values together into a single string value. It’s a standard string manipulation technique in many languages, and SQL is no different. The syntax of this function is: CONCAT( string1, string2 ) The function returns both string values joined together, without a space or any other characters in between. The return value is the same as the first string parameter, which can be any of the string data types. One of the main drawbacks of this function is that it only allows for two strings to be combined, unlike other CONCAT functions in other languages. If you want to combine more than two strings together, you’ll need to have nested CONCAT functions, or use the double pipe character || which also concatenates strings. However, the advantage of CONCAT is that it allows for concatenation when using different character sets that don’t support the double pipe method. CONCAT and the double pipe method have similar performance, so that’s not an issue. For more information about the Oracle CONCAT function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-concat/
Views: 709 Database Star
Query without using Like operator find strings?
 
05:28
Hello guys in this video i explain how to find all employee who have a last character is 'N' without using like operator. Oracle database Unbeatable,Unbreakable Platform..
Views: 2042 Oracle World
Oracle regular expression part 3 replace a substring regexp replace
 
06:00
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2630 Sridhar Raghavan
TRIM Function In Oracle | Character Manipulation | Oracle Tutorial for Beginners
 
12:03
TRIM Function In Oracle | Character Manipulation |Single Row Functions | Oracle Tutorial for Beginners TRIM in oracle with example TRIM examples Oracle Database Tutorial for Beginners Oracle Tutorial Oracle SQL TRIM() Functions Oracle TRIM SQL TRIM Functions LTRIM Function in SQL LTRIM Function in Oracle RTRIM Function in SQL RTRIM FUnction in Oracle oracle trim multiple characters ltrim function in oracle oracle substring function How to remove space in Oracle String LTRIM and RTRIM in SQL LTRIM and RTRIM in Oracle oracle remove spaces how to remove space in oracle column oracle rtrim trim function in oracle stack overflow ltrim and rtrim in oracle ltrim and rtrim in oracle oracle trim function oracle substring function ltrim sql oracle string functions lpad oracle sql ltrim characters from string
Views: 223 Oracle PL/SQL World
PL/SQL Tutorial 4 (Oracle): Substring Command
 
04:42
PL/SQL Tutorial 4 (Oracle): Substring Command In this tutorial I show you how to use the Substring command in PL/SQL Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 179 CodingWithMitch
SQL 089 String Scalar, OVERLAY or How can I replace a substring?
 
01:13
Explains the String Scalar Function OVERLAY to replace a substring. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 385 cbtinc
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: 621 Oracle PL/SQL World
11-Oracle Database  CONCAT,SUBSTR, LENGTH, INSTR, LPAD,RPAD, TRIM, Round,Trunc,Mod.avi
 
33:16
11-Oracle Database - Intro to Types of Single Row Functions - CONCAT,SUBSTR, LENGTH, INSTR, LPAD,RPAD, TRIM, Round,Trunc,Mod.avi
Views: 4481 Adel Sabour
Oracle Database11g tutorials 5   How to use Concatenation operator, character String
 
04:45
How to use Concatenation operator, character String!!!!!!
Views: 98 Quick Solution
SUBSTR and INSTR Functions in Oracle Database
 
08:57
SUBSTR Function in Oracle, INSTR Functions in Oracle
Views: 33 Adam Tech
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: 173 Oracle PL/SQL World
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: 1073 Database Star
Find the Number of Occurrences of a Character In the given String SQL | ORACLE | PL SQL
 
03:34
Find the Number of Occurrences of a Character In the given String SQL | ORACLE | PL SQL
Views: 933 Online Pl Sql
Oracle SQL Developer Series: Lesson 5 How to perform calculations, display string in result sets
 
17:31
In this tutorial you will learn how to perform calculations using SQL Developer. Also you will learn to create strings for results set.
Views: 594 DBA Pro
SQL : INSTR function
 
05:06
In this tutorial, you'll learn how to make use of Instr function...
Views: 18886 radhikaravikumar
Oracle LENGTH Function
 
01:23
https://www.databasestar.com/oracle-length/ The Oracle LENGTH function allows you to find the length of a string, also known as the number of characters in a string. It’s a common feature in different languages, and SQL is no different. The LENGTH function only has one parameter: LENGTH ( string_value ) The parameter is the string_value which is the value to check the length of. The function returns a number that represents the number of characters in the function. Some points to remember about the Oracle LENGTH function: If string_value is NULL, then LENGTH will return NULL. If string_value is an empty string, the LENGTH will return NULL. The string_value can be any of the character data types - CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, NCLOB. If the string_value is a CHAR data type, then the LENGTH will include any trailing spaces in the value. For more information about the Oracle LENGTH function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-length/
Views: 312 Database Star
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: 340 Puzzle Guru
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: 107 EqualConnect Coach
substring and substr String methods
 
05:30
Two other String methods that are commonly used are substr and substring. These methods allow you to extract a portion of the original string upon which the method was called. The return value of the method is the extracted portion of the string. Code GIST: https://gist.github.com/prof3ssorSt3v3/0380ada3cd0b7a2608978b2d50d60ce3
Views: 284 Steve Griffith
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.
Oracle Tutorial || online training|| Adv Sql | Regular Expressions by basha
 
40:52
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......
Character functions in Oracle pl sql
 
29:44
In this oracle tutorial I have tried to explain some character functions commonly used in Oracle. This functions are mainly related to string manipulation, pattern searching or matching. I have included one additional conversion function (to_date) which is to some extent linked to character functions.
Views: 1129 Subhroneel Ganguly
Difference between Replace and Translate function in oracle
 
03:46
This video demonstrates the difference between a replace function and a translate function in oracle using an suitable example. Both the function does a similar task, but has a lot of difference in implementation and output when used. Be learning the difference users can easy justify the correct scenarios on where to use translate and when to use replace. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 2002 Kishan Mashru