Home
Search results “If else oracle example”
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►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: 68962 Manish Sharma
CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE
 
06:28
The case statement gives the if-then-else kind of conditional ability to the otherwise static sql select statement, This video demonstrates how to write an case statement in oracle sql, and explains different aspects of the case statement. The video explains the execution flow of the case statement and advises on the best way to write one.
Views: 2736 Kishan Mashru
IF Statements in Oracle PL SQL with example
 
07:40
Complete Oracle PL/SQL Tutorial for Beginners Playlist here https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi ************************************************** This Video shows how to use IF THEN , ELSIF THEN and ELSE Statements in Oracle with examples for Beginners.
Views: 2613 yrrhelp
Oracle SOA Suit 12c IF ELSE Activity in BPEL (Creating Demo Calulator)
 
14:06
This video is all about How to use IF Else activity in BPEL, SOA 12c
Views: 3140 Amit Gaur
IF  ELSE con Oracle
 
03:33
EJEMPLO y MAS INFORMACIÓN VISITA:
Views: 793 NubsDataBase
Oracle PL/SQL Tutorial -  If Statements
 
05:08
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html This PLSQL tutorial explains If-statements and their central role in development. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
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
70. IF ELSE construct in PL/SQL Oracle
 
05:19
In this video you will learn about IF ELSE construct in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 5838 ITORIAN
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: 16925 WingsOfTechnology
Stored Procedure - IF ELSE IF ELSE
 
03:13
Stored Procedure - IF ELSE IF ELSE by Professor Saad Yousuf DB2 UDB, Oracle, SQL Server, MySQL
Views: 7824 Professor Saad
PL-SQL tutorial 25 - How to use Multiple IF-ELSIF-ELSE
 
05:46
Hi guys today i am going to explain about Selection Control Structure IF-ELSIF-ELSE in PL/SQL how to write a code in condition. Oracle database Unbeatable,Unbreakable Platform..
Views: 303 Oracle World
Oracle PL/SQL - IF THEN ELSE Statement
 
04:57
http://plsqlzerotopro.com This tutorial explains IF THEN ELSE Statement.
Views: 10996 HandsonERP
PL-SQL Condition Statement - IF Then, If Then else, CASE Statement
 
08:25
PL-SQL Condition Statement - IF Then, If Then else, CASE Statement PL-SQL tutorial for Beginners in Hindi and English
TSQL: How To Use IF Statements
 
03:36
How to use IF statements in TSQL.
Views: 4283 SQLInSix Minutes
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: 5710 WingsOfTechnology
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
 
04:28
Introduction to Oracle: PL-SQL - IF ... ELSIF ... ELSE Statement
Views: 382 David Hays
Oracle SQL Tutorial - If condition using Decode and Case Statements
 
08:56
In this tutorial, we will see how to use CASE and DECODE to construct an IF ELSE conditions in SQL. SQL used in this video are given below. Also, note as mentioned in video, the values we substitute for different data should be of same data type. select * from emp_test; Male Female better than just F IF gender = 'M' then print 'MALE', gender = 'F' then print 'Female', ELSE, print 'Unknown' select first_name,gender from emp_test; select first_name,DECODE(GENDER,'M','Male','F','Female','Unknown') Gender from emp_test; SELECT first_name,DECODE(GENDER,'M','Male','F','Female') Gender FROM emp_test; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' END AS GENDER FROM EMP_TEST; SELECT first_name, CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' ELSE 'UNKNOWN' END AS GENDER FROM EMP_TEST; SB - Savings Bank CA - CURRENT ACCOUNT FD - Fixed Deposit LA - Loan ACCOUNT
Views: 88 Ganesh Anbarasu
04 - Curso de PL/SQL : Sentencia IF - ELSIF - ELSE
 
12:13
Hola de nueva cuenta mi nombre es Mario Ruiz, y hoy comenzamos con un nuevo curso de Programación en PL/SQL. Twitter: @MarioRuizComMx Facebook: https://www.facebook.com/marioruiz.com.mx/ Blog: https://www.marioruiz.com.mx Podcast: http://mx.ivoox.com/es/capitulo-1-el-cafe-oracle-introduccion-audios-mp3_rf_16850226_1.html LinkedIn: https://www.linkedin.com/in/marioruizlinkedin?trk=hp-identity-photo oracle oracle sql oracle pl sql oracle sqlplus curso curso de oracle curso de sql curso de pl sql curso de sqlplus sql developer toad pl / sql developer desarrollo de aplicaciones programador desarrollador como ser programador como ser desarrollador certificacion certificacion oracle certificaciones 1z0-061 1z0-062 dba dba oracle administrador de base de datos administrador de base de datos oracle database oracle preparar certificacion oracle oracle expert oracle experto oramex el mundo de oracle mario ruiz mario ruiz marioruizcommx buenas practicas como usar pl sql como usar oracle como usar toad como usar sqlplus preguntas de la certificacion braindumps oracle linux linux batch awk perl shell scripting shell
Views: 2663 Mario Ruiz
bip 003 020 use of IF else in templates
 
14:43
BI Publisher EBS BI Publisher Hands On Labs - How to install BIP software on desk top. To see the files used for the lab please check out www.oracleerpxlabs.com This video will show how to use Learn about Control Statements use of IF else in templates
Views: 729 Tom Gregory
PL/SQL tutorial IF THEN ELSE (IF-ELSE) Statement in PL/SQL
 
04:07
This video is about pl sql basics,pl sql basic programs,basic pl sql programs,oracle pl sql basics,pl sql basics with examples,basic pl sql,basic pl sql queries,basics of pl sql,pl sql basics tutorial,pl sql basic concepts,basic pl
Views: 166 Nayabsoft
Tutorial 9 : IF - ELSIF - ELSE in Oracle
 
08:14
Hi Friends! Here we are learning about IF - ELSIF - ELSE Statement in Oracle. Hope the concept would be clear to you. For any confusion or doubt let me know in comment box. Link IF STATEMENT Explained : https://youtu.be/y6L-2JhVpe0 Link IF - ELSE Statement Explained : https://youtu.be/NpofYRtMrlE Thanks. Happy Coding :)
Views: 65 YourSmartCode
MySQL- If Else Condition Example
 
03:45
if else condition in mysql select query How to Write IF Else Condition in MySQL Website : http://intactabode.com/ linkedin https://www.linkedin.com/in/suryam-jy-ab471815b/ Google Plus https://plus.google.com/u/0/106052339846662160710 Twitter https://twitter.com/jysuryam Facebook https://www.facebook.com/intactabode/
Views: 295 Intact Abode
PL/SQL Conditional Statements Example - Case Statements in PL SQL - If Then Else in PL SQL
 
28:58
Conditional statements are important in any language and so they are important in Oracle PL/SQL language also. They allow conditional execution of lines of code. #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Videos to visit : PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss Code for complex programs of this video : If-then-elsif-then-else-end if; Problem : Calculate salary with formula salary = basic + allowance under following terms - (1) basic can not be less than 1800 and more than 10,000 (2) basic between 1800 and 3000 allownace is 120% of basic (3) basic above 3000 and up to 5000 allowance rate 130% of basic (4) basic above 5000 and up to 7000 allowance rate 140% of basic (5) basic above 7000 allowance rate is 150% Input to the program is basic Output print : basic, calculated allowance, and salary = basic + allowance declare basic number; salary number; allow number; minbas number := 1800; maxbas number := 10000; baslim1 number := 3000; baslim2 number := 5000; baslim3 number := 7000; allow1 number := 120; allow2 number := 130; allow3 number := 140; allow4 number := 150; invalid exception; begin basic := '&basic'; if basic [less than] minbas or basic [greater than] maxbas then raise invalid; elsif basic between minbas and baslim1 then allow := basic * allow1/100; elsif basic [greater than] baslim1 and basic [less than equal] baslim2 then allow := basic * allow2/100; elsif basic [greater than] baslim2 and basic [less than equal] baslim3 then allow := basic * allow3/100; else allow := basic * allow4/100; end if; salary := basic + allow; dbms_output.put_line('Basic : '||basic); dbms_output.put_line('Allowance : '||allow); dbms_output.put_line('salary : '||salary); exception when value_error then dbms_output.put_line('basic has to be number'); when invalid then dbms_output.put_line('basic must be in valid range'); end; CASE control structure ========================================================== Case was introduced in oracle 9i. It is equivalent to if-elsif structure demonstrated above, but simplifies it by taking expression only for once, in normal use but tests the evaluation of expression with value for equality. Problem : consider a school which has alternate day half day and weekly off on Sunday. We want to display the name of the day and if it is half day or full day or holiday. The input is numeric week day, with 1 as Sunday. declare daynum number(1); err exception; begin daynum := '&DayNumber'; if daynum [less than] 1 or daynum [greater than] 7 then raise err; end if; case daynum when 1 then dbms_output.put_line('it is Sunday : weekly off'); when 2 then dbms_output.put_line('it is Monday : Full Day'); when 3 then dbms_output.put_line('it is Tuesday : Half Day'); when 4 then dbms_output.put_line('it is Wednesday : Full Day'); when 5 then dbms_output.put_line('it is Thursday : Half Day'); when 6 then dbms_output.put_line('it is Friday : Full Day'); else dbms_output.put_line('it is Saturday : Half Day'); End case; exception when err then dbms_output.put_line('numeric week day 1 to 7 only accepted'); when value_error then dbms_output.put_line('input must be between 1 to 7 only'); end; CASE in Searched form declare basic number; salary number; allow number; minbas number := 1800; maxbas number := 10000; baslim1 number := 3000; baslim2 number := 5000; baslim3 number := 7000; allow1 number := 120; allow2 number := 130; allow3 number := 140; allow4 number := 150; invalid exception; begin basic := '&basic'; CASE when basic [less than] minbas or basic [greater than] maxbas then raise invalid; when basic between minbas and baslim1 then allow := basic * allow1/100; when basic [greater than] baslim1 and basic [less than equal] baslim2 then allow := basic * allow2/100; when basic [greater than] baslim2 and basic [less than equal] baslim3 then allow := basic * allow3/100; else allow := basic * allow4/100; end case; salary := basic + allow; dbms_output.put_line('Basic : '||basic); dbms_output.put_line('Allowance : '||allow); dbms_output.put_line('salary : '||salary); exception when value_error then dbms_output.put_line('basic has to be number'); when invalid then dbms_output.put_line('basic must be in valid range'); end;
Views: 74 Crazy4 DB
xslt template usage and if else condition with example
 
10:58
xslt mapping template use with example
Views: 1895 SAP PI Reference
PL-SQL tutorial 24 - Selection Control Structure IF-ELSE
 
05:16
Hi guys today i am going to explain about Selection Control Structure IF-ELSE in PL/SQL how to write a code in condition. Oracle database Unbeatable,Unbreakable Platform..
Views: 245 Oracle World
PL SQL Tutorials for Beginners | IF THEN ELSE Conditions
 
08:44
PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. The IF-THEN-ELSIF statement allows you to choose between several alternatives. An IF-THEN statement can be followed by an optional ELSIF...ELSE statement. The ELSIF clause lets you add additional conditions. When using IF-THEN-ELSIF statements there are few points to keep in mind. It's ELSIF, not ELSEIF An IF-THEN statement can have zero or one ELSE's and it must come after any ELSIF's. An IF-THEN statement can have zero to many ELSIF's and they must come before the ELSE. Once an ELSIF succeeds, none of the remaining ELSIF's or ELSE's will be tested. Subscribe to our Channel for more videos https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg
Views: 137 Puzzle Guru
Oracle Sql Step by Step Approach (071 if then else case statement)
 
03:20
Oracle Sql Step by Step Approach (071 if then else case statement) Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry Learn to become a fee-earning SQL developer in just seven weeks. This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer. This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database. Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement. Like,Comment,Share
Oracle tutorial : User Defined Exception in Oracle PL SQL
 
05:59
Oracle tutorial: User Defined Exception in Oracle PL SQL pl sql exception handling pl sql exception handling examples This video will show you how to raise user defined exceptions in oracle. Example: BEGIN IF condition THEN RAISE exception_name; END IF; EXCEPTION WHEN exception_name THEN statement; END; 1)We can defined exception to make your own exception. 2)This exception must be declare yourself and RAISE statement to raise explicitly. Declare exception : user_define_exception_name EXCEPTION; RAISE exception : RAISE user_define_exception_name; How to use : WHEN user_define_exception_name THEN //User Action lets see an example DECLARE exception1 EXCEPTION; g NUMBER; BEGIN FOR g IN (SELECT * FROM EMPLOYEE) LOOP IF g.ID = 7 THEN RAISE exception1; END IF; END LOOP; EXCEPTION WHEN exception1 THEN dbms_output.put_line(‘WE HAVE FOUND EMPLOYEE NUMBER 7’); END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 211 Tech Query Pond
0404 Using IF Statements
 
04:16
PHP is one of the leading technical web building education . Its very simple and easy to learn. Here we are showing 1 PHP Uses 2 PHP Installation 3 PHP Development 4 PHP using with PL/Sql 5 Pl/Sql Installation 6 Create and using Database using Oracle etc are shown in this video Thanks for watching
PL/SQL Tutorial 6 : IF-THEN-ELSE Conditional Statement
 
09:52
Pl/SQL Tutorial 6 In these video the basic concept IF-THEN-ELSE statement of PL/SQL is explained Syntax:- IF condition THEN statements to be executed if condition is true; ELSE statements to be executed if condition is false; end if; The statements inside THEN and ELSE is executed if the condition is true. The statements inside ELSE and END IF is executed if the condition is false. We Hope You Understand these video Please Subscribe to our channel. Thank you for Watching.
SQL 063 Scalar Functions, CASE WHEN ELSE or IF THEN ELSE?
 
02:50
Explains the CASE WHEN ELSE Statement Scalar Function in place of IF THEN ELSE. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 4003 cbtinc
Tutorial#68 SubQuery in Oracle SQL Database by rakesh malviya
 
08:15
Explaining what is SubQuery in Oracle SQL and How SubQuery internally work in Oracle SQL database a subquery is a query within a query(Parent and Child Query). You can create subqueries within your SQL statements. These subqueries can reside in the WHERE, FROM and SELECT clause ------------------------------------------------------------------------------ Assignment Link: Assignment Link will come Soon --------------------------------------------------------------------------------------- In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow Rakesh Malviya on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 87 EqualConnect Coach
PL/SQL Tutorial 20- PL_SQL Searched Case  Statements in PL/SQL By JavaInHand (in Hindi)
 
06:46
Searched Case Statements in pl/sql? Syntax of Searched Case Statements in pl/sql? example of Searched Case Statements in pl/sql? pl/sql tutorial for beginners in hindi
Views: 68 JavaInHand
Multiple IF statements
 
05:28
This tutorial creates a compare program, that allows you to enter two numbers. The program then uses multiple IF Statements to show on screen the correct response.
Views: 212 Mr_Wemyss
Intermediate MySQL: Select If Statements
 
01:57
This tutorial goes over how to use an if statement inside of a select query to get new/better results. Twitter ► https://twitter.com/ShieldCrush Instagram ► https://www.instagram.com/BrentFarris
Views: 6082 Brent Farris
EXIST Function in SQL
 
08:04
Join Discussion: http://www.techtud.com/video-lecture/exist-function-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 40425 Techtud
HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
 
10:17
Using HAVING clause and difference with GROUP BY & WHERE clause in SQL statement Link for scripts on my blog: https://sqlwithmanoj.com/2015/05/23/sql-basics-difference-between-where-group-by-and-having-clause/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 75117 SQL with Manoj
PL/SQL Tutorial 15- PL_SQL WHILE LOOP Statements in Oracle Database By JavaInHand (in Hindi)
 
07:49
How to used while loop in pl/sql? While loop example while loop syntax ------------------------------------------------------------ www.javainhand.com
Views: 303 JavaInHand
SQL With - How to Use the With (CTE) Statement in SQL Server - SQL Training Online
 
06:33
http://www.sqltrainingonline.com SQL With - How to Use the WITH Statement/Common Table Expressions (CTE) in SQL Server - SQL Training Online In this video, I introduce the SQL WITH statement (also known as Common Table Expressions or CTE) and show you the basics of how it is used. The SQL WITH Statement is called Common Table Expressions or CTE for short in SQL Server The SQL WITH statement is used for 2 primary reasons: 1) To move Subqueries to make the SQL easier to read. 2) To do recursive queries in SQL Today, I just want to talk about the subquery piece. I first want to take a look at the Employee table in the SQL Training Online Simple Database. select * from employee To talk about the SQL WITH statement, I have to first talk about and show you a subquery. select * from ( select * from employee ) a So that is an example of a subquery. But, we want to talk about the SQL WITH, which allows you to move the subquery up and make the SQL a lot easier to read. Here is the same query using the WITH statement. WITH cteEmployee (employee_number,employee_name,manager) AS ( select employee_number,employee_name,manager from employee ) select * from cteEmployee You can see that we start with the WITH clause and then we can use any name we want to name our CTE. In this case, I use "cteEmployee". Then we need to specify the columns inside of parenthesis. Next comes the AS clause. And finally, we just SELECT from the cteEmployee table we created. And, that's it. But, I want to take it a step further and join the cteEmployee CTE back to the Employee table and get the Manager's name. Here is an example of that. WITH cteEmployee (employee_number,employee_name,manager) AS ( select employee_number,employee_name,manager from employee ) select cte.employee_number ,cte.employee_name ,cte.manager ,e.employee_name as manager_name from cteEmployee cte INNER JOIN employee e on cte.manager = e.employee_number That's it. That is the basic introduction into the SQL WITH statement in SQL Server. Microsoft also has some good examples on this. 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: 24322 Joey Blue
Java Programming Tutorial - If/Else if/Else Statements - Episode 5
 
05:53
Github Repository: https://github.com/The-SourceCode/Java-8-Programming-Tutorial Java 8 Docs: https://docs.oracle.com/javase/8/docs/api/ Java Tutorials: https://docs.oracle.com/javase/tutorial/ _________________________________ Thank you for tuning in to this episode of TheSourceCode! If you enjoyed this video make sure to show your support by liking, commenting your thoughts, and sharing for all your friends to see and learn! If you learned something new, if this video helped you, or if you want to share you work Tweet to #TSCCoding. Become a Patreon TODAY! https://www.patreon.com/TheSourceCode _________________________________ Referral Links: Create your own Patreon: https://patreon.com/invite/znzoqq Join us on Discord: https://discord.gg/w24CQMR _________________________________ Github: https://github.com/The-SourceCode Forums: https://tscforum.com Twitter: https://twitter.com/The_Source_Code _________________________________ Intro Music: https://soundcloud.com/digital-math/digital-math-joystick
Views: 1048 {TheSourceCode}
Nested If Then Else statement in pl/sql
 
04:08
Nested If Then Else statement in pl/sql Share, Support, Subscribe!!! Subscribe: https://www.youtube.com/channel/UC1P3... Youtube: https://www.youtube.com/channel/UC1P3... Twitter: https://twitter.com/csetuts4you Facebook: https://www.facebook.com/csetuts4you/ Instagram: https://www.instagram.com/csetuts4you/ Google Plus: https://plus.google.com/u/0/+csetuts4you About : This is my youtube channel its name is Technical Notes that means computer science and engineering tutorials for you. the aim of my channel is to provide you to the best programming language concept and other subjective concept and different technology concept. so friends please visit to my Technical Notes youtube channel and subscribe it. this is fully free channel. and please share this link to all yours friends to get these benefits.., New Video is Posted Everyday :)
Views: 40 Technical Notes