Home
Search results “Oracle pl sql if substr”
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: 79790 Manish Sharma
SQL : Substr function
 
03:36
In this tutorial, you'll learn how to make use of substring function...
Views: 10244 radhikaravikumar
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
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: 4730 Database Star
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: 903 Aprenda PL/SQL
66 - Oracle PL/SQL IF - Then - Else تعليم أوراكل
 
23:32
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL IF - Then - Else in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
 
04:28
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
Views: 357 David Hays
Interacting with SQL functions- UPPER(),LOWER(),LTRIM(),RTRIM(),TRIM(),SUBSTR()
 
05:00
A few functions which can be used in SQL, if you have any questions feel free to ask in comments.
Views: 563 Akash Zeus
Oracle SQL Video Tutorial 26 - CASE Statements
 
05:59
Oracle SQL Video Tutorials 26 - CASE Statements explained.In This Oracle SQL Tutorial for Beginners, I have explained basics of SQL.These examples work on Oracle 10g and Oracle 11g database. These helps youto understand Oracle Joins and helps beginners. Iam going to add more tutorials on Oracle DBA, Oracle RAC and Oracle PL/SQL.All Oracle sql tutorial with examples are executed on Oracle 11g using Oracle SQL Developer.
Views: 5231 Just Channel
Oracle PLSQL Procedure Tampil Data Kelas dan Jumlah Mahasiswa per Prodi
 
18:28
Video tutorial beriku tmemberikan ilustrasi cara pembuatan procedure pada Oracle PL/SQL untuk menampilkan data kelas beserta jumlah mahasiswa per prodi. Digunakan explicit cursor, fungsi SUBSTR dan struktur pemilihan IF.
Views: 850 Boby Siswanto
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
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
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: 11275 yrrhelp
SQL tutorial 72: NVL SQL NULL function By Manish Sharma RebellionRider
 
03:50
Part 1: SQL Null Function NVL learn the concepts of NVL null function in this tutorial with examples and all the Interview concepts covered ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/nvl-sql-null-function Previous Tutorial ► LPAD & RPAD Functions https://youtu.be/nPtbuHPCN6E ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 1st 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 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: 24816 Manish Sharma
Sql query to select all names that start with a given letter without like operator
 
03:02
Text Article http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that.html Slides http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that_31.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss writing a SQL query to retrieve all student names that start with letter 'M' without using the LIKE operator. If the interviewer has not mentioned not to use LIKE operator, we would have written the query using the LIKE operator as shown below. SELECT * FROM Students WHERE Name LIKE 'M%' We can use any one of the following 3 SQL Server functions, to achieve exactly the same thing. CHARINDEX LEFT SUBSTRING The following 3 queries retrieve all student rows whose Name starts with letter 'M'. Notice none of the queries are using the LIKE operator. SELECT * FROM Students WHERE CHARINDEX('M',Name) = 1 SELECT * FROM Students WHERE LEFT(Name, 1) = 'M' SELECT * FROM Students WHERE SUBSTRING(Name, 1, 1) = 'M'
Views: 56865 kudvenkat
Oracle MOD Function
 
03:17
https://www.databasestar.com/oracle-remainder-mod/ The Oracle MOD function performs a “modulo division” on the numbers you specify. A modulo division is where a division is performed using two numbers, and the remainder is returned by the function. For example, the division of 8/5 is 1.6. Using modulo division, 8/5 will work out there is one 5 contained in the 8, with 3 left over. The MOD function would return 3 in this example. The syntax of the MOD function is: MOD(numerator, denominator) The numerator is the number mentioned first in the division, or the one that is on top of the division sign. In a division such as 15/4, this would be the 15. The denominator is the number mentioned second in the devision, or hte one that is on the bottom of the division sign. In a division such as 15/4, this would be the 4. The parameters can be any numeric data type, and the return type depends on these parameters. This means MOD can return a whole number or a decimal number. The calculation for the Oracle MOD function is: numerator - denominator * FLOOR(numerator / denominator). If the denominator is 0, the function returns the value of the numerator. This is done to prevent “divide by 0” errors. For more information about the MOD function, including how to return every second row, how it’s different to REMAINDER, and to see the SQL code used in these examples, read the related article here: https://www.databasestar.com/oracle-remainder-mod/
Views: 912 Database Star
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: 386 cbtinc
Decode function in oracle plsql.
 
16:28
This oracle tutorial explain how to use decode function in oracle pl sql. Decode function is a powerful function which let you create a set of branched if else like statement within a single sql statement. I have also provided an example which swap values of 2 columns with a single sql statement using decode.
Views: 1738 Subhroneel Ganguly
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: 33818 Manish Sharma
Oracle COALESCE Function
 
04:00
https://www.databasestar.com/oracle-coalesce/ The COALESCE function in Oracle allows you to input one or many values and return a value that is not NULL. You provide it with a series of values, and it returns the first of thsoe values which are not NULL. The syntax of the Oracle COALESCE function is: COALESCE(expr1, expr2 [, expr_n]) These parameters are: Expr1: the first expression to check for a NULL value. If it’s NULL, the function checks the next parameter. If not, then this value is returned. Expr2: the second expression to check for a NULL value, if the first expression is NULL. If this is NULL, then the next expression is checked, otherwise this value is returned. Expr_n: More expressions can be added and checked in case both expr1 and expr2 are null. Only the first two expressions are needed. The first non-NULL expression is returned. But, if all expressions are NULL, then NULL is returned. One way I’ve recently used this was to find out what phone number to display. A query looked at the mobile number and returned that, but if it was NULL it looked at the home phone and returned that, but if that was NULL it looked to the business phone number. That query looked like this: COALESCE(mobile_phone, home_phone, business_phone) For more information about the Oracle COALESCE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-coalesce/
Views: 499 Database Star
Oracle DECODE Function
 
04:31
https://www.databasestar.com/oracle-decode-function/ The Oracle DECODE function lets you perform IF-THEN-ELSE functionality in your queries. It’s similar to a CASE statement. The syntax of the DECODE function is: DECODE ( expression, search, result [, search, result]... [,default] ) The parameters of the Oracle DECODE function are: - expression (mandatory): This is the value to compare. - search (mandatory): This is the value to compare against the expression. - result (mandatory): This is the return value if the search value matches the expression value. There can be multiple combinations of search and result values, and the result value is attached to the previous search value. - default (optional): If none of the search values match, then this value is returned. If this is not provided, the DECODE function will return NULL if no matches are found. If you compare this to an IF-THEN-ELSE statement, it would look like this: IF (expression = search) THEN result [ELSE IF (expression = search) THEN result] ELSE default END IF The parameters can be one of many different data types, and the return type is calculated from them. Earlier I mentioned it’s similar to CASE. So why would you use one and not the other? - DECODE is an older function, and CASE was introduced as a replacement for DECODE. - CASE offers more flexibility then DECODE - CASE is also easier to read and debug (in my opinion) The performance of these functions is the same, so if you’re considering using DECODE, I would suggest using CASE instead. For more information about the Oracle DECODE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-decode-function/
Views: 499 Database Star
Every VARCHAR2(N) Declaration a Bug in PL/SQL!?
 
07:51
Every VARCHAR2(N) Declaration a Bug!? That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem. 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.
SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma
 
04:44
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►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/ 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: 26643 Manish Sharma
Oracle - SQL - Number Functions
 
03:59
Oracle - SQL - Number Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL tutorial 71: LPAD and RPAD SQL Function By Manish Sharma RebellionRider
 
03:35
Learn the step by step concepts of Lpad and Rpad SQL functions In oracle Database with example By Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/lpad-and-rpad-sql-functions Previous Tutorial ►Tut 10 SQL Single Row Function https://youtu.be/5rx8Q4x4-qI ►Tut 11 case and character manipulation functions https://youtu.be/243Pqbta7oI ►Tut 12 SQL Concat Function https://youtu.be/De8UvHro5UY ►Tut 13 SQL substr function https://youtu.be/f52uKYyYFoU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 1st 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 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: 20785 Manish Sharma
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: 624 Database Star
Oracle NVL Function Explained with Examples
 
09:25
https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/ The Oracle NVL function allows you to check a value and return a different value if that value is NULL. It’s great for using another value if the first one is NULL or an optional value, for example people’s phone numbers. It’s also good alongside aggregate functions and grouping so you can see what the difference is between a subtotal row and an actual NULL value. The syntax of the Oracle NVL function is: NVL( check_value, replace_value ) The parameters are: - check_value (mandatory): This is the value that is displayed to the user. It is also the value that is checked for NULL. - replace_value (mandatory): This is the value that appears if the check_value is NULL. The function can use many different data types as parameters: string, date, or numeric. However, both parameters need to be the same type. For more information about the Oracle NVL function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/
Views: 267 Database Star
NVL FUNCTION IN ORACLE SQL WITH EXAMPLE
 
06:25
This video is the 1st video in the series of 'working with null in oracle sql', the video demonstrates the purpose and use of NVL function in oracle with perfect and easy to understand example. The NVL function is used to replace NULL values by another value.
Views: 1508 Kishan Mashru
SQL Pattern Matching | LIKE Condition | DBMS Gate Lectures in hindi #80
 
06:25
Welcome to series of gate lectures by well academy SQL Pattern Matching | LIKE Condition | DBMS Gate Lectures in hindi #80 GATE Practice Book Purchase Link ( ACE Academy ) https://goo.gl/jESdtD GATE Practice Book Purchase Link ( Made Easy ) https://goo.gl/zUU5Vn Here are some more GATE lectures by well academy relational algebra in dbms | relational algebra operations in dbms | DBMS lectures in hindi #58 : https://youtu.be/zbnyudmh4ys Select Operation in Relation Algebra | Selection in Relational Algebra | DBMS lectures in hindi #59 : https://youtu.be/NsIL7z4Ck4A Projection in Relational Algebra | relational algebra in dbms | DBMS Lectures in hindi #60 : https://youtu.be/5QVMyeDfih4 Gate 2012 Relaional Algebra | relational algebra in dbms gate | DBMS lectures in hindi #61 : https://youtu.be/SeGqtlzy5_k Rename operation in Relational Algebra | relational algebra in dbms | DBMS Lectures in hindi #62 : https://youtu.be/0bklGoIBcQ8 set operations in dbms | Set Operations in Relational Algebra in dbms | DBMS lectures in hindi #63 : https://youtu.be/cE8mZnWxyN4 Join Operation in DBMS | join operation in relational algebra | join operation in database DBMS #64 : https://youtu.be/Au-ab_Yq1rw Natural join operation in dbms | Natural join in relational algebra | Natural join in hindi | #65 : https://youtu.be/rBaSaPoUeqQ Division Operation | Division Operation in DBMS | Division Operation in dbms with example | DBMS #66 : https://youtu.be/705ljW1X5gM join in dbms | Types of Join in dbms | join operation in relational algebra | DBMS lectures #67 : https://www.youtube.com/watch?v=4DppvRx5a2Y GATE 2015 Relational Algebra | relational algebra in dbms with examples | DBMS Lectures in hindi #68 : https://youtu.be/gj0xiXmjVaw Relational Calculus | relational calculus database | relational calculus in hindi | DBMS #69 : https://youtu.be/1hG_qqckYj0 Tuple Relational Calculus | tuple relational calculus in dbms | tuple relational calculus in hindi : https://youtu.be/RzGg0fykY3I Tuple Relational Calculus | Bounded Variables and Free Variables | DBMS Lectures in Hindi #71 : https://youtu.be/Yjz10ysczUc SQL create table in hindi | SQL tutorial in hindi | DBMS Lectures in hindi #72 : https://youtu.be/Pm8XAQYDBGw constraints in dbms | constraints in sql in hindi | DBMS Lectures in Hindi #73 : https://youtu.be/kevkLGrJvUg sql insert command | sql insert into table | sql insert query | DBMS Lectures in hindi #74 : https://youtu.be/lsxyUFjh148 SQL Delete row | SQL Update Query | sql queries tutorial in hindi | DBMS Lectures in hindi #75 : https://youtu.be/KuUPDpYKtT0 referential integrity constraint in dbms | referential integrity in sql | DBMS Lectures in Hindi #76 : https://youtu.be/UT_8T7EL2Og SQL Alter command | sql alter table add column | dbms queries tutorial | DBMS Lectures in Hindi #77 : https://youtu.be/uCjKTMdy094 sql select query | sql select statement | sql select from multiple tables | dbms Lectures #78 : https://youtu.be/-Lo6KHlkiQk create view in sql | view in sql in hindi | View Operation in SQL | DBMS Lectures in Hindi #79 : https://youtu.be/YURtgFm0cIk Click here to subscribe well Academy https://www.youtube.com/wellacademy1 GATE Lectures by Well Academy Facebook Group https://www.facebook.com/groups/1392049960910003/ Facebook Me : https://goo.gl/2zQDpD Thank you for watching share with your friends Follow on : Facebook page : https://www.facebook.com/wellacademy/ Instagram page : https://instagram.com/well_academy Twitter : https://twitter.com/well_academy sql select, sql select case when then, sql select column from 2 tables, sql select column without name, sql select columns from different tables, sql select columns from multiple tables, sql select command syntax, sql select count, sql select data from different tables, sql select data from multiple tables, sql select distinct, sql select distinct values and count of each, sql select from multiple tables, sql select from where, sql select into statement, sql select query, sql select query tutorial, sql select statement, sql select statement tutorial, dbms basic queries, dbms queries, dbms queries examples, dbms queries tutorial, dbms queries tutorial in hindi, dbms queries with examples, dbms sql queries, dbms sql queries in hindi, queries in dbms in hindi, create view in sql, use of view in sql, view in sql, view in sql database, view in sql example, view in sql hindi, view in sql in hindi, view in sql tutorial, view in sql with examples, view in sql youtube, what is view in sql in hindi, SQL Pattern Matching
Views: 3769 Well Academy
LNNVL FUNCTION IN ORACLE SQL
 
09:11
This video is the 5th video in the series of 'working with null', this video explains the working of the lnnvl function in oracle sql with simple and easy to understand example. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used only in the WHERE clause of a query. It takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls. Oracle Database sometimes uses the LNNVL function internally in this way to rewrite NOT IN conditions as NOT EXISTS conditions. In such cases, output from EXPLAIN PLAN shows this operation in the plan table output. The condition can evaluate any scalar values but cannot be a compound condition containing AND, OR, or BETWEEN.
Views: 597 Kishan Mashru
NVL2 FUNCTION IN ORACLE SQL WITH EXAMPLE
 
05:40
This video is the 2nd video in the series of 'working with null in oracle sql' , the video explains and demonstrates the use of nvl2 function in oracle sql with simple and easy to understand example.
Views: 1589 Kishan Mashru
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: 2002 Database Star
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 44113 etldeveloper
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
PL/SQL Tutorial 2 (Oracle): Concatenate Command
 
01:48
PL/SQL Tutorial 2 (Oracle): Concatenate Command In this tutorial I show you how to use the concatenate 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: 344 CodingWithMitch
MS SQL SERVER Substring
 
05:45
MS SQL SERVER Substring Convert String To Date With SQL Operation Studio (SQLOPS) on Mac
Views: 55 Saidah Faulia
Oracle SQL Tutorial 9 - Intro to Queries
 
04:55
This video is for beginners who have never worked with SQL Developer, and we are going to teach how to begin writing queries. So the queries we are going to start with are queries when we give the database an expression and it will return back some kind of value. The most common keyword you are going to need to know for Oracle is SELECT. SELECT is the command we use to get data from the database. Even though we have not really put any data in our database, we can still use the SELECT statement to get data. That's because the database is capable of doing more than just creating tables and retrieving data from tables. So our first goal is to essentially write a Hello World, which just displays the text hello world to us. A good place to start is with: SELECT 'Hello World' This would actually work for many database management systems, but when you run it you will get an error. This actually doesn't work with Oracle, it will tell us we always need the FROM keyword. To get around this, there is a magical table called DUAL. We can put anything we want to SELECT and then say FROM DUAL and it will work. SELECT 'Hello World' FROM DUAL We can also do math: SELECT 1+1 FROM DUAL And we can run even run functions: SELECT SYSTIMESTAMP FROM DUAL To put all of this together, you can grab all of this data at the same time using commas to separate different columns from our generated table: SELECT 'Hello World', 1+1, SYSTIMESTAMP FROM DUAL Support me on Patreon: 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: 26469 Caleb Curry
Oracle Database11g tutorials 8 || SQL DISTINCT with multiple columns |SQL Distinct with Two columns
 
04:33
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to use SQL DISTINCT keyword with SQL Select clause. This Video is in the continuation of previous video on SQL distinct with one column. In this video we will see How to use SQL distinct with multiple columns and SQL distinct with two columns 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 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: 98673 Manish Sharma
Oracle TO_NUMBER Function
 
02:42
https://www.databasestar.com/oracle-to_number/ The Oracle TO_NUMBER function is used to convert a text value into a number value. It’s similar to TO_CHAR and TO_DATE, but converts a value to a number. The number will also be rounded to a specified number of digits, and returned as a NUMBER value. The syntax is: TO_NUMBER( input_value, [format_mask], [nls_parameter] ) The input_value is the value to be converted to a number. Commonly this is provided as a string (e.g. CHAR or VARCAHR2) but can be several other data types as well. The format_mask is the format that the output value should be displayed as. It must be a valid number format. This is an optional value. The final parameter, nls_date_language, is used to work out how the output is displayed, such as how to display currency symbols. It’s also an optional value. For more information about the Oracle TO_NUMBER function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_number/
Views: 2211 Database Star
String Functions in SQL Server part-V || SPACE, STR, STUFF, SUBSTRING functions in SQL
 
04:42
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=6cgn4... String Function Part II https://www.youtube.com/watch?v=RmyT8... String Function Part III https://www.youtube.com/watch?v=lQVnQ... String Function Part IV https://www.youtube.com/watch?v=cxASmU2hxjc ***************************************************************************************** SPACE (Transact-SQL) Returns a string of repeated spaces.  Syntax SPACE ( integer_expression )  Arguments integer_expression Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned.  Return Types varchar STR (Transact-SQL) Returns character data converted from numeric data.  Syntax STR ( float_expression [ , length [ , decimal ] ] )  Arguments float_expression Is an expression of approximate numeric (float) data type with a decimal point. length Is the total length. This includes decimal point, sign, digits, and spaces. The default is 10. decimal Is the number of places to the right of the decimal point. decimal must be less than or equal to 16. If decimal is more than 16 then the result is truncated to sixteen places to the right of the decimal point.  Return Types varchar STUFF (Transact-SQL) The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.  Syntax STUFF ( character_expression , start , length , replaceWith_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. start Is an integer value that specifies the location to start deletion and insertion. If start or length is negative, a null string is returned. If start is longer than the first character_expression, a null string is returned. start can be of type bigint. length Is an integer that specifies the number of characters to delete. If length is longer than the first character_expression, deletion occurs up to the last character in the last character_expression. length can be of type bigint. replaceWith_expression Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. This expression will replace length characters of character_expression beginning at start.  Return Types Returns character data if character_expression is one of the supported character data types. Returns binary data if character_expression is one of the supported binary data types. SUBSTRING (Transact-SQL) Returns part of a character, binary, text, or image expression in SQL Server.  Syntax SUBSTRING ( expression ,start , length )  Arguments expression Is a character, binary, text, ntext, or imageexpression. start Is an integer or bigint expression that specifies where the returned characters start. If start is less than 1, the returned expression will begin at the first character that is specified in expression. In this case, the number of characters that are returned is the largest value of either the sum of start + length- 1 or 0. If start is greater than the number of characters in the value expression, a zero-length expression is returned. length Is a positive integer or bigint expression that specifies how many characters of the expression will be returned. If length is negative, an error is generated and the statement is terminated. If the sum of start and length is greater than the number of characters in expression, the whole value expression beginning at start is returned.  Return Types Returns character data if expression is one of the supported character data types. Returns binary data if expression is one of the supported binary data types. The returned string is the same type as the specified expression with the exceptions shown in the table. Specified expression Return type char/varchar/text varchar nchar/nvarchar/ntext nvarchar binary/varbinary/image varbinary
Views: 98 Softtech forum
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: 3393 Kishan Mashru
Oracle - DECODE
 
06:57
Oracle - DECODE
Views: 10451 Chris Ostrowski
DECODE Function ( IF..THEN..ELSE) in SQL ORACLE Query With Example
 
05:35
ORACLE/PLSQL: DECODE FUNCTION The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. The syntax for the Oracle/PLSQL DECODE function is: DECODE( expression , search , result [, search , result]... [, default] ) ARGUMENTS: expression is the value to compare. search is the value that is compared against expression. result is the value returned, if expression is equal to search. default is optional. If no matches are found, the DECODE function will return default. If default is omitted, then the DECODE function will return null (if no matches are found). Lets apply this function on emp table. Emp table has 3 dept numbers like 10,20 and 30. So if I want to display the different dept names based on ID, I have to use IF THEN ELSE condition. IF deptno=10 THEN "DEPT1" ELSE deptno=20 THEN "DEPT2" ELSE deptno=30 THEN "DEPT3" This entire IF block can be achived using single DECODE(). DECODE(deptno,10,'DEPT1',20,'DEPT2',30,'DEPT3') Query used in Video: select empno,ename,deptno,DECODE(deptno,10,'DEPT1',20,'DEPT2',30,'DEPT3') from emp;
Views: 5459 WingsOfTechnology

Fungsi voltaren 25mg
Lodine 400mg etodolac
Potassium 200mg viagra
Thuoc solian 200mg
Candelong 16 mg zofran