Home
Search results “Sql oracle case is null”
Different ways to replace NULL in sql server - Part 15
 
11:42
In this video we will learn about the different ways to replace NULL values in sql server. 1. ISNULL() function 2. CASE statement 3. COALESCE() function Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/different-ways-to-replace-null-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-15-different-ways-to-replace-null.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html 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
Views: 267319 kudvenkat
SQL CASE
 
05:44
Jamie King of Neumont University demonstrating CASE.
Views: 29851 Jamie King
CASE Function( IF..THEN..ELSE) in SQL ORACLE Query With Example
 
04:03
ORACLE/PLSQL: CASE STATEMENT The Oracle/PLSQL CASE statement has the functionality of an IF-THEN-ELSE statement. Starting in Oracle 9i, you can use the CASE statement within a SQL statement. The syntax for the Oracle/PLSQL CASE statement is: CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ELSE result END --------- ARGUMENTS: expression is optional. It is the value that you are comparing to the list of conditions. (ie: condition_1, condition_2, ... condition_n) condition_1 to condition_n must all be the same datatype. Conditions are evaluated in the order listed. Once a condition is found to be true, the CASE statement will return the result and not evaluate the conditions any further. result_1 to result_n must all be the same datatype. This is the value returned once a condition is found to be true. NOTE: If no condition is found to be true, then the CASE statement will return the value in the ELSE clause. If the ELSE clause is omitted and no condition is found to be true, then the CASE statement will return NULL. You can have up to 255 comparisons in a CASE statement. Each WHEN ... THEN clause is considered 2 comparisons. 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 CASE. CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'NO DEPT' END; Query used in Video: select empno,ename,deptno,CASE deptno WHEN 10 THEN 'DEPT1' WHEN 20 THEN 'DEPT2' WHEN 30 THEN 'DEPT3' ELSE 'No Dept' END from emp;
Views: 16278 WingsOfTechnology
TSQL: How To Use CASE WHEN Statements
 
14:15
How to use CASE WHEN statements in SQL Server.
Views: 28223 SQLInSix Minutes
NULL Value in Oracle Database | Oracle Tutorials for Beginners
 
03:18
NULL Value in Oracle Database | Oracle Tutorials for Beginners NULL Value in Oracle Database NULL Value in Oracle SQL NULL Value in SQL NULL Value in Oracle Database Oracle Tutorials for Beginners Oracle Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners Oracle PL/SQL Tutorials for Beginners how to select null values in oracle oracle compare null values in where clause null=null in oracle how to handle null in case statement in oracle how to check null value in oracle stored procedure oracle nvl null value in oracle query how to check empty column value in oracle how to select null values in oracle oracle is null vs = null oracle nvl oracle is not null oracle decode oracle isnull oracle case when null select null from table in oracle oracle compare null values in where clause oracle select null how to check empty column value in oracle oracle sql not null or empty oracle is not null how to handle null in case statement in oracle oracle isnull oracle nvl
Views: 526 Oracle PL/SQL World
SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)
 
06:34
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ● What Is Case Expression ● Syntax of Simple Case Expression ● Query 1. Column name of a table as Search expression in CASE ● Query 2. String as Search expression in CASE Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/simple-case-expression ------------------------------------------------------------------------- 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: 37157 Manish Sharma
SQL tutorial 73: NVL2 SQL null function By Manish Sharma RebellionRider
 
03:01
Part 2: SQL Null Function NVL2 learn the concepts of NVL null function in this tutorial with examples and all the Interview concepts covered ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/nvl2-null-function Previous Tutorial ► NVL function https://youtu.be/aRoTR5Jn6K0 ------------------------------------------------------------------------- ►►►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: 21342 Manish Sharma
05-Oracle SQL Arabic Course - Null Value & Column Aliases -اوراكل ديفلوبر
 
07:10
الدرس الخامس من سلسلة دروس تعلم أوراكل محتويات الدرس: 1- NULL Values. 2- Null values in Arithmetic Expressions. 3- Column Alias. .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com/
Views: 4069 Ask Gad
SQL Handling NULL
 
04:49
Jamie King of Neumont University speaking on why NULL in SQL is different and how we compensate for it.
Views: 5821 Jamie King
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: 24797 Manish Sharma
SQL Tutorial in Oracle - 4 NULL, LIKE, DISTINCT, ORDER BY
 
18:37
SQL SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. In SQL, wildcard characters are used with the SQL LIKE operator. SQL wildcards are used to search for data within a table. With SQL, the wildcards are: Wildcard Description % A substitute for zero or more characters _ A substitute for a single character [charlist] Sets and ranges of characters to match [^charlist] or [!charlist] Matches only a character NOT specified within the brackets Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 17621 Telusko
SQL Q & A Part 3 - NULL Functions NVL, NVL2, NULLIF, DECODE, & COALESCE
 
03:59
NULL is a keyword used to represent ‘unknown’ or ‘missing’ data. NULL is not ‘zero’ or ‘blank’. SQL NULL functions are used to validate it. Explained NVL(), NVL2(), NULLIF(), DECODE() & COALESCE() in detail with examples SQL Interview Q & A Playlist: https://www.youtube.com/watch?v=t2qoqI5TjSk&list=PLSo-SnVTqbBLavDdG89zpQZDWkoEc9LP_ LINUX Interview Q & A Playlist: https://www.youtube.com/watch?v=1WEZqImoxzs&list=PLSo-SnVTqbBIBjEhxwRV3hbYmfXOWiYmR Technology You Must Know Playlist: https://www.youtube.com/watch?v=9FPrr1f2yjo&list=PLSo-SnVTqbBK4qk42HRrawr17mBITQmJd
Views: 1007 Shivanand V
TSQL: LEFT JOIN NOT NULL (Use Cases)
 
03:27
An example of a use case with LEFT JOINs.
Views: 466 SQLInSix Minutes
SQL Null or Empty   How to Check for Null or Empty Column in SQL Server   SQL Training Online
 
03:41
http://www.sqltrainingonline.com SQL Null or Empty - How to Check for Null or Empty Column in SQL Server - SQL Training Online You can download the sample table script at http://www.sqltrainingonline.com/how-to-filter-for-sql-null-or-empty-string/. In this video, I show you how to filter for a SQL null or empty string. It can be difficult to filter a null because you can't simply compare with an equal sign. You have to use a special IS NULL clause to make the filter work. I also show you how to combine both the SQL Null and Empty String together in a special trick with the isnull SQL Server function. I use SQL Server 2012 to demonstrate the technique. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 16995 Joey Blue
SQL tutorial 50: CASE - Searched Case Expression In Oracle (2/2)
 
05:52
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ●Intro Of searched Case expression ● Syntax of SearchedCase Expression ● Query 1. Searched Case expression With logical operator using 2 columns ● Query 2. Searched Case Expression with Comparison operators and BETWEEN and IN operators. 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: 26633 Manish Sharma
IIF function in SQL Server
 
04:00
iif function in sql server 2012 iif function in sql server example sql server iif function example In this video we will discuss IIF function in SQL Server. IIF function Introduced in SQL Server 2012 Returns one of two the values, depending on whether the Boolean expression evaluates to true or false IIF is a shorthand way for writing a CASE expression Syntax : IIF ( boolean_expression, true_value, false_value ) Example : Returns Male as the boolean expression evaluates to TRUE DECLARE @Gender INT SET @Gender = 1 SELECT IIF( @Gender = 1, 'Male', 'Femlae') AS Gender Example : Using IIF() function with table data. We will use the following Employees table for this example. SQL Script to create Employees table Create table Employees ( Id int primary key identity, Name nvarchar(10), GenderId int ) Go Insert into Employees values ('Mark', 1) Insert into Employees values ('John', 1) Insert into Employees values ('Amy', 2) Insert into Employees values ('Ben', 1) Insert into Employees values ('Sara', 2) Insert into Employees values ('David', 1) Go Write a query to display Gender along with employee Name and GenderId. We can achieve this either by using CASE or IIF. Using CASE statement SELECT Name, GenderId, CASE WHEN GenderId = 1 THEN 'Male' ELSE 'Female' END AS Gender FROM Employees Using IIF function SELECT Name, GenderId, IIF(GenderId = 1, 'Male', 'Female') AS Gender FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server_14.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html 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
Views: 32407 kudvenkat
Oracle interview question difference between null functions
 
07:23
Difference between NVL,NVL2, NULLIF and COALESCE NVL function will check whether the first input parameter is null, if first input parameter is null then the function returns the second parameter value as output. NVL2 function will check the first parameter, and return second parameter if the first parameter is not null, otherwise returns third parameter. NULLIF will compare the input parameters ( first and second parameter ), and returns NULL of both are same, otherwise returns the first parameter value. COALESCE, returns the first not null expression in the given input parameters. -------------------------------------------------------------------------------------------------------- List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 246 Siva Academy
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 SQL Programming - Constraints
 
31:37
This video demonstrates the use and syntax for 5 constraint types in Oracle: Primary Key, Foreign Key, Unique, Check, and Not Null.
Views: 207 Brian Green
Oracle SQL Lecture 28: IS NULL and IS NOT NULL
 
03:19
Oracle SQL: IS NULL and IS NOT NULL https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 729 Oracle SQL
CASE Statement in Sql Server to Handle NULL Explained in Hindi
 
05:25
CASE Statement in Sql Server to Handle NULL Explained in Hindi SQL Server: CASE WHEN OR THEN ELSE END
Views: 29 Hindi Life
67 - Oracle PL/SQL Case Statement تعليم أوراكل
 
23:40
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Case Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
SQL Tutorial - CASE Statements
 
10:04
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis. If you are not familiar with my previous video on creating a sample set of data please check out the video here: In this video I talk about how to use CASE statements in SQL Server. CASE Statements were introduced to SQL Server in 2008. They are used to evaluate conditions and return a result based on those conditions. CASE Statements can be used in SELECT, UPDATE, DELETE, WHERE, HAVING. In this CASE Tutorial we look at a common use of CASE statements within SELECT and also the benefit and common downfalls when writing CASE queries. CASE Statement Syntax: CASE WHEN [condition] THEN [result] END SQL Queries in this video: SELECT CustomerId , FirstName , MiddleName , LastName , CASE WHEN CustomerId = 5995 THEN 'Unknown' WHEN Gender = 'M' THEN 'Male' WHEN Gender = 'F' THEN 'Female' ELSE 'Unknown' END AS Gender , DOB FROM dbo.CustomersSample Please feel free to post comments.
Views: 354 BeardedDev
Null value in oracle
 
09:08
this video describes null concept in oracle. join the group and share your knowledge and ask your doubts. https://www.facebook.com/groups/940425699338535/
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH NULL / NOT IN / NOT EXISTS OR OUTER JOIN
 
08:36
This video demonstrates the oracle sql interview question where one need to use either not in, not exists or an outer join to get the desired result. For example if one is asked to fetch records from department table where department_id is not present in employee table
Views: 1954 Kishan Mashru
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 31042 kudvenkat
NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE
 
03:24
This video is the 3rd video in the series of 'working with null in oracle sql', the video demonstrates the use of NULLIF function in oracle sql, and how we can use it in day to day coding time. The video explains the function with perfect easy to understand example.
Views: 1345 Kishan Mashru
Replace Null Value and Coalesce function in SQL Hindi Lesson 33
 
09:05
In this video we will learn how to replace null value using Isnull function, Coalesce function and case statement.
Views: 815 Vijay Mulsaniya
Difference between Case and Decode
 
10:14
This video tutorial explains on how case statement and decode function are different from each other. Though both of them are used in giving the if-then-else conditional functionality to sql statement, they differ much from each other, this video will walk through each of the difference with appropriate examples. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE 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: 11869 Kishan Mashru
SQL Totals and Sub totals using ROLLUP (with sample scenario)
 
03:59
Totals and Subtotals using ROLLUP in : -- ORACLE SQL select case when c.customer_name is null then 'TOTAL' else c.customer_name end CUST_NAME ,case when lt.name is null then 'SUB-TOTAL' else lt.name end Loan_Type ,sum(lr.loan_amount) from loan_request lr join customers c on c.customer_id=lr.customer_id join loan_types lt on lt.loan_type_id = lr.loan_type_id group by rollup(c.customer_name,lt.name) --MYSQL select case when c.customer_name is null then 'TOTAL' else c.customer_name end CUST_NAME ,case when lt.name is null then 'SUB-TOTAL' else lt.name end Loan_Type ,sum(lr.loan_amount) from loan_request lr join customers c on c.customer_id=lr.customer_id join loan_types lt on lt.loan_type_id = lr.loan_type_id group by c.customer_name,lt.name with rollup
Views: 604 Data Disc
Oracle SQL TUTORIAL – IF condition using CASE and DECODE  - An Example
 
09:31
In this video, we shall see how case and decode is used in real time scenario. SQL used in the video is given below. SELECT * FROM emp_test ORDER BY gender; count_of_employees Count_of_Male_Employees Count OF Female Employees -- 15 5 8 select count(*) " Total Employees" from emp_test; select gender,count(*) " Total Employees" from emp_test group by gender; select sum(decode(gender,'M',1,0)) Count_OF_Male_Employees from emp_test; select sum(case gender when 'F' then 1 else 0 end) as Count_OF_FeMale_Employees from emp_test; SELECT count(*) " Total Employees" , sum(decode(gender,'M',1,0)) Count_OF_Male_Employees, sum(case gender when 'F' then 1 else 0 end) Count_OF_Female_Employees from emp_test;
Views: 53 Ganesh Anbarasu
T SQL Level Up Chapter 3 CASE Expressions
 
16:18
There are times in your T-SQL code when you need to return not a column, but rather a value that’s derived from a column or columns in your query. When that happens it’s time to use a CASE expression.
Let's Learn SQL! Lesson 99: Nested Case Statements and Order By Case Statements
 
03:27
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn how to use a Nested Case Statement as well as use a Case Statement within the Order By!
Oracle Database Tutorial - SELECT Operators - DECODE, CASE, NVL, NVL2, SUM, COUNT etc
 
21:30
This video tutorial on Oracle database provides detailed information on various operators used in SELECT statements. You can visit Oracle Database related videos here : https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1 Website: http://guru4technoworld.wix.com/technoguru Facebook : https://www.facebook.com/a2zoftech/ Blog: http://dronatechnoworld.blogspot.com
Views: 82 Sandip M
77. UPDATE with CASE in SQL (Hindi)
 
09:02
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 8165 Geeky Shows
T-SQL: CASE Statement
 
11:46
Here’s an intro to case statements, in the form of a conversation with Sean. I cover simple case and searched case, and the special use of null. BTW, I really like this video, and I don’t say that very often.
Views: 72 MidnightDBA
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
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: 1502 Kishan Mashru
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: 33791 Manish Sharma
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: 1584 Kishan Mashru
Oracle Operators in Oracle Database | Oracle Tutorial for Beginners
 
16:42
Oracle Operators in Oracle Database | Oracle Tutorial for Beginners Oracle Operators BETWEEN AND . NOT BETWEEN AND IS NULL and IS NOT NULL LIKE Operator in Oracle NOT LIKE Operators in Oracle IN and NOT IN Oracle SQL Oracle tutorials for Beginners oracle query between two timestamps oracle between inclusive oracle sql between two dates with time oracle between exclusive sql between dates sql between datetime sql between inclusive or exclusive between clause in oracle for date oracle not in vs not exists oracle not exists in condition in oracle oracle sql not in subquery oracle not in null if not exists in oracle not equal to in oracle not like in oracle how to select null values in oracle oracle case is null oracle compare null values in where clause oracle sql not null or empty oracle is not null oracle case when not null then how to handle null in case statement in oracle is null in oracle not like in oracle with multiple values oracle not like wildcard oracle sql like multiple values if not in oracle pl sql sql query not like multiple values how to pass parameter in like operator in oracle regexp_like in oracle oracle not equal
Views: 366 Oracle PL/SQL World
The CASE Statement (Introduction to Oracle SQL)
 
07:15
Learn what the CASE statement is and how to use it. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 194 Database Star
SQL Basics Part-5, How to write Case Statements in SQL Server
 
10:32
An easy way to learn SQL in SQL Server Management Studio Environment
Views: 3105 SQL Learn & Share
COALESCE Function in SQL ORACLE Query With Example
 
03:53
ORACLE/PLSQL: COALESCE FUNCTION The Oracle/PLSQL COALESCE function returns the first non-null expression in the list. If all expressions evaluate to null, then the COALESCE function will return null. The syntax for the Oracle/PLSQL COALESCE function is: coalesce( expr1, expr2, ... expr_n ) PARAMETERS: expr1 to expr_n are the expressions to test for non-null values. EXAMPLE: The COALESCE function can be used in Oracle/PLSQL. You could use the coalesce function in a SQL statement as follows: SELECT COALESCE( address1, address2, address3 ) result FROM suppliers; The above COALESCE function is equivalent to the following IF-THEN-ELSE statement: IF address1 is not null THEN result := address1; ELSIF address2 is not null THEN result := address2; ELSIF address3 is not null THEN result := address3; ELSE result := null; END IF; The COALESCE function will compare each value, one by one. Lets apply the same to emp table. We have some NULL values in comm and mgr columns. but not in any other columns. So lets take a example for this 2 columns. COALESCE(comm,mgr,sal) Here if comm is null, function returns mgr value. If mgr is null it returns sal value! Query used in video: SELECT ename,comm,mgr,sal,COALESCE(comm,mgr,sal) result FROM emp;
Views: 6304 WingsOfTechnology
Difference Between Case and Decode
 
06:03
What is the difference between case and decode ? Important links for Oracle Developers For for SQL - PL/SQL Interview Questions Answers Facebook group https://www.facebook.com/groups/146487615764170/ Download Free PLSQL Interview Books , Documents Videos from here https://www.facebook.com/groups/146487615764170/files/ Free SQL / PLSQL Video on YouTube Channel SUBSCRIBE https://www.youtube.com/c/ramguptaoracle?sub_confirmation=1 Visit oracle forms / report / SQL PLSQL blog http://oracletemple.blogspot.in/ Oracle Community Google+ https://plus.google.com/u/0/collection/4mW-jB Join our facebook group https://www.facebook.com/groups/146487615764170/ Follow us on Twitter https://twitter.com/Rameshwar275 Simply Like and Share :) Oracle SQL PLSQL FaceBook group https://www.facebook.com/groups/146487615764170/ ORACLE SQL PLSQL VIDEO LINKS What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg What are types of View available in Oracle https://www.youtube.com/edit?o=U&video_id=PN-NsSA2R-E
Views: 3842 Ram Gupta
Oracle SQL Video Tutorial 3 : NULL
 
07:32
Oracle SQL Video Tutorials 3 : Null Values
Views: 1750 Just Channel
Case When & Constraints in SQL Server
 
48:47
Website:https://www.eclasess.com CASE WHEN STATMENT SELECT * INTO TABLE INSERT INTO TABLE FROM TABLE2 CONSTRAINTS(PRIMARY KEY,UNIQUE,FOREIGN KEY DEFAULT,NOT NULL,CHECK) IN SQL SERVER
Null handling in SQL server
 
10:18
Video is about handling null value in SQL server query. We need to handle null value in select clause and where clause.
Dynamic SQL in SQL Server
 
12:12
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 1. What is Dynamic SQL 2. Simple example of using Dynamic SQL What is Dynamic SQL Dynamic SQL is a SQL built from strings at runtime. Simple example of using Dynamic SQL Here is the SQL Script to create Employees table and populate it with data Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) Go Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) Go One way to achieve this is by implementing a stored procedure as shown below that this page would call. Create Procedure spSearchEmployees @FirstName nvarchar(100), @LastName nvarchar(100), @Gender nvarchar(50), @Salary int As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go The stored procedure in this case is not very complicated as we have only 4 search filters. What if there are 20 or more such filters. This stored procedure can get complex. To make things worse what if we want to specify conditions like AND, OR etc between these search filters. The stored procedure can get extremely large, complicated and difficult to maintain. One way to reduce the complexity is by using dynamic SQL as show below. Depending on for which search filters the user has provided the values on the "Search Page", we build the WHERE clause dynamically at runtime, which can reduce complexity. However, you might hear arguments that dynamic sql is bad both in-terms of security and performance. This is true if the dynamic sql is not properly implemented. From a security standpoint, it may open doors for SQL injection attack and from a performance standpoint, the cached query plans may not be reused. If properly implemented, we will not have these problems with dynamic sql. In our upcoming videos, we will discuss good and bad dynamic sql implementations. For now let's implement a simple example that makes use of dynamic sql. In the example below we are assuming the user has supplied values only for FirstName and LastName search fields. To execute the dynamicl sql we are using system stored procedure sp_executesql. sp_executesql takes two pre-defined parameters and any number of user-defined parameters. @statement - The is the first parameter which is mandatory, and contains the SQL statements to execute @params - This is the second parameter and is optional. This is used to declare parameters specified in @statement The rest of the parameters are the parameters that you declared in @params, and you pass them as you pass parameters to a stored procedure Declare @sql nvarchar(1000) Declare @params nvarchar(1000) Set @sql = 'Select * from Employees where [email protected] and [email protected]' Set @params = '@FirstName nvarchar(100), @LastName nvarchar(100)' Execute sp_executesql @sql, @params, @FirstName='Ben',@LastName='Hoskins' This is just the introduction to dynamic SQL. If a few things are unclear at the moment, don't worry. In our upcoming videos we will discuss the following 1. Implementing a real world "Search Web Page" with and without dynamic SQL 2. Performance and Security implications of dynamic sql. Along the way we will also discuss good and bad dynamic sql implementations. 3. Different options available for executing dynamic sql and their implications 4. Using dynamic sql in stored procedures and it's implications Once we discuss all the above, you will understand 1. The flexibility dynamic sql provides 2. Advantages and disadvantages of dynamic sql 3. When and when not to use dynamic sql
Views: 39377 kudvenkat