Home
Search results “Fetch exit when oracle”
11-Oracle PL-SQL Arabic Course   Explicit Cursors اوراكل ديفلوبر
 
15:45
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح SQL فى درس اليوم نجيب على السؤال ماهو الكيرسور(CURSOR)؟ كما نتحدث عن الفرق بين: Implicit cursor – Explicit cursor وكذلك خطوات انشاء Explicit cursor و هى: Declare cursor – Open cursor – fetch cursor - close cursor. كما نتناول بالشرح : Explicit cursor attributes: %isopen %found %notfound %rowcount SYNTAX: CURSOR cursor_name IS select_statement; DECLARE CURSOR c_emp_cursor IS SELECT employee_id, last_name FROM employees WHERE department_id =30; v_emp_record c_emp_cursor%ROWTYPE; BEGIN OPEN c_emp_cursor; LOOP FETCH c_emp_cursor INTO v_emp_record; EXIT WHEN c_emp_cursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE( v_emp_record.employee_id ||' '||v_emp_record.last_name); END LOOP; CLOSE c_emp_cursor; END; ......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 5903 Ask Gad
PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor
 
09:49
RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-3 Previous Tutorial ► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q ► Explicit Cursor: https://youtu.be/3q7dW_d2KVc ► Simple Loop: https://youtu.be/AFx6QYcY1CU ► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ For E-mail address please check the 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: 11367 Manish Sharma
Cursor For Loop in Oracle PLSQL
 
02:46
This video shows how to fetch values in a cursor using Cursor For Loop.
Views: 868 yrrhelp
Oracle tutorial : sys_refcursor  in oracle pl sql (sys_refcursor)
 
09:53
Oracle tutorial : sys_refcursor in oracle pl sql oracle tutorial for beginners cursor in pl sql we can use sys_refcursor as OUT parameter. A cursor is a pointer to a result set for a query. By returning a sys_refcursor you allow the client to fetch many rows from the query as it requires. basically we use sys ref cursor to return set of rows to client. so client can use this result set. u can fetch multiple rows. lets see example.. CREATE OR REPLACE PROCEDURE get_my_list (list OUT SYS_REFCURSOR) AS BEGIN OPEN list FOR SELECT ALTID, FNAME, LNAME FROM EMPLOYEE; END get_my_list; / DECLARE l_cursor SYS_REFCURSOR; ID VARCHAR2(20); FNAME VARCHAR2(20); LNAME VARCHAR2(20); BEGIN get_my_list (list = l_cursor); LOOP FETCH l_cursor INTO ID, FNAME, LNAME; EXIT WHEN l_cursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE(ID || ' | ' || FNAME || ' | ' || LNAME); END LOOP; CLOSE l_cursor; END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond database cursor example database cursor sql server cursor
Views: 2263 Tech Query Pond
Advantages of using cursor for loop in Oracle pl sql.
 
10:54
In this oracle tutorial I have compared cursor for loop with a simple loop and end loop cursor. In a simple loop end loop you need to do a lot of stuff like opening the cursor, fetching the record into variable which you need to declare in declaration section, set the condition to exit from the loop and close the cursor, you don't need to do any this in cursor for loop.
Views: 1341 Subhroneel Ganguly
PL/SQL tutorial 12: PL/SQL WHILE Loop in Oracle Database
 
06:33
Iterative statements/loop series learn the concepts of While Loop in PL/SQL or In Oracle Database with Examples. also learn how to handle boolean expression in while loop ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/while-loop-in-pl-sql Previous Tutorial ► Simple Loop: https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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: 63406 Manish Sharma
PL-SQL tutorial 29 - GOTO statement in PL/SQL
 
06:30
Hi guys today i am going to explain about Control Structure --Goto statement in PL/SQL how to write a code in switch case concept. Oracle database Unbeatable,Unbreakable Platform..
Views: 1217 Oracle World
SQL Server Programming Part 6 - WHILE Loops
 
14:48
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 77535 WiseOwlTutorials
Database Cursors using while loop and repeat until loop
 
03:46
Database Cursors using while loop and repeat until loop using stored procedure.
Views: 1081 Professor Saad
Oracle - PL/SQL - Exception Handling
 
08:58
Oracle - PL/SQL - Exception Handling https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Loops in SQL Part - 1
 
25:45
A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . ... If and only if the value of this expression is TRUE , the statements after LOOP execute. cursor_for_loop_statement. Issues a SQL query and loops through the rows in the result set. Writing Loops in SQL. In programming, a loop allows you to write a set of code that will run repeatedly within the same program. Many programming languages have several different types of loop to choose from, but in SQL Server there is only one: the WHILE loop TYPES OF LOOPS 1 SIMPLE LOOPS 2 CURSOR FOR LOOPS 3 WHILE LOOPS 4 NUMARIC FOR LOOPS A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . With each iteration, the sequence of statements is executed, then control resumes at the top of the loop. An EXIT , GOTO , or RAISE statement branches out of the loop. At each iteration, the sequence of statements is executed and then control resumes at the top of the loop. 2. PL/SQL WHILE LOOP. Repeats a statement or group of statements while a given condition is true. It tests the condition before executing the loop body. Variables in SQL procedures (DECLARE, SET statements) ... Values can be assigned to variables using the SET statement or the SELECT INTO statement or as a default value when the variable is declared. Literals, expressions, the result of a query, and special register values can be assigned to variables. The WHILE loop test at the start of the loop and it the condition is false, the loop code is never executed. ... This is referred to as a REPEAT-UNTIL or DO-WHILE loop. PL/SQL does not directly implement a REPEAT-UNTIL loop however it is easy to construct one using an endless loop. The init step is executed first, and only once. This step allows you to declare and initialize any loop control variables. ... If it is true, the loop executes and the process repeats itself (body of loop, then increment step, and then again condition). After the condition becomes false, the 'for' loop terminates.
Views: 214 Technology mart
PL/SQL tutorial 31: Cursor For Loop With Parameterized Cursor In Oracle Database
 
04:24
PL/SQL tutorial 31 Database Cursor for loop part 2. Learn how to work with parameterized cursor using Cursor For Loop in Oracle Database By Manish Sharma at RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-with-parameter-cursor Previous Tutorial ► Cursor For Loop with Simple Cursor https://youtu.be/abgVNjPaMVA ►PL/SQL For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 30537 Manish Sharma
71- Oracle PL SQL  For Loop, While Loop, Loop End Loop Statements تعليم أوراكل
 
32:05
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Loops in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
PL/SQL tutorial 76: Introduction to FORALL statement in Oracle Database
 
04:51
RebellionRider.com presents Introduction to bulk Data processing using FORALL statement in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/forall-01 Previous Tutorial ► PL/SQL Bulk Collect with LIMIT clause ►SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database http://bit.ly/ora-00942 ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 8109 Manish Sharma
PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop
 
09:30
PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop PL-SQL tutorial for Beginners in Hindi and English
Tutorial 25 : IMPLICIT CURSOR IN PL SQL || %ROWCOUNT || %FOUND || %NOTFOUND
 
06:19
Hi Friends, Here we are learning about IMPLICIT CURSOR in Pl SQL. We are getting to know about CURSOR attributes such as %ROWCOUNT, %FOUND, %NOTFOUND. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link for CURSOR Introduction : https://youtu.be/XlunuLQZUmw Link where Anchor Datatype Explained : https://youtu.be/zPD2rnr-34Q Link from where you can get the notes : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 365 YourSmartCode
Tutorial 11 : WHILE Loop in Oracle
 
08:10
Hi Friends! Here we are learning about WHILE Loop in Oracle. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. Link where Simple Loop Explained : https://youtu.be/BJZf-RMwutM Thanks! Happy Coding :)
Views: 81 YourSmartCode
PL/SQL tutorial 28: Cursor Parameter In Oracle Database By Manish Sharma
 
04:54
Learn How To Create Parameterized cursor in Oracle Database with easy to understand example by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-parameter Previous Tutorial ► Create Explicit Cursor: https://youtu.be/3q7dW_d2KVc ►Cursors : https://youtu.be/_snAMqCBitg ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 45438 Manish Sharma
Cursor For Loop in PL/SQL - Explicit Cursor - Parameterized Cursors - Explicit Cursor Orcle
 
48:00
Cursor for loop is a very powerful looping structure for Oracle explicit cursor. Parameterized cursors help to make the program more efficient. Cursor for loop when used for explicit cursor makes the program compact and easy to read and write. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 Video Index : What is explicit cursor : 2.00 Why use explicit cursor : 3:39 Step of Explicit Cursor : 7:43 Explicit Cursor attributes : 14:06 Explicit cursor example : 19:40 Cursor For loop : 27:00 Parameterized cursor : 34:52 Cursor for locking for update nowait : 38:49 Program code : Use of explicit cursor with simple loop ==================================== declare n number; s number; e emp.ename%type; cursor c1 is select distinct sal from emp where sal is not null order by sal desc; cursor c2 is select ename from emp where sal = s; begin n := '&EnterRank'; open c1; fetch c1 into s; while c1%found loop if c1%rowcount = n then open c2; loop fetch c2 into e; if c2%found then dbms_output.put_line(e||' '||s); else exit; end if; end loop; exit; end if; fetch c1 into s; end loop; dbms_output.put_line('no more emp'); exception when value_error then dbms_output.put_line('value must be numeric'); end; Using Cursor for loop ================================== declare n number; s number; cursor c1 is select distinct sal from emp where sal is not null order by sal desc; cursor c2 is select ename from emp where sal = s; begin n := '&EnterRank'; for vsal in c1 loop if c1%rowcount = n then s := vsal.sal; for vname in c2 loop dbms_output.put_line(vname.ename||' '||s); end loop; end if; end loop; dbms_output.put_line('no more emp'); exception when value_error then dbms_output.put_line('value must be numeric'); end; Parameterized cursor example ==================================== declare n number; cursor c1 is select distinct sal from emp where sal is not null order by sal desc; cursor c2 (s emp.sal%type) is select ename from emp where sal = s; begin n := '&EnterRank'; for vsal in c1 loop if c1%rowcount = n then for vname in c2(vsal.sal) loop dbms_output.put_line(vname.ename||' '||vsal.sal); end loop; end if; end loop; dbms_output.put_line('no more emp'); exception when value_error then dbms_output.put_line('value must be numeric'); end; Locking for Transaction by explicit cursor ====================================== declare vdno emp.deptno%type; incr number; lck exception; pragma exception_init(lck, -00054); cursor c1 (pdno emp.deptno%type) is select * from emp where deptno = pdno for update nowait; begin vdno := '&DeptNo'; incr := '&Increment'; open c1(vdno); update emp set sal = sal + incr where deptno = vdno; if sql%rowcount [greater than] 0 then dbms_output.put_line(sql%rowcount||' rows updated'); else dbms_output.put_line('department does not exist'); end if; close c1; exception when value_error then dbms_output.put_line('check input values'); when lck then dbms_output.put_line('rows locked - try later'); end;
Views: 61 Crazy4 DB
Oracle  || goto statement in PL/SQL  by Siva
 
07:10
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
Unix tutorial : Unix Shell Script to connect Oracle database
 
05:00
Unix tutorial : Unix Shell Script to connect Oracle database This tutorial will show you how to connect oracle database using the command line in Unix. Here Unix shell scripting is used to connect the database using the sqlplus command. And you can see how to retrieve data from database using the shell script 1)Oracle tutorial : How to connect oracle database using sqlplus command line https://www.youtube.com/watch?v=N2DAK2ty8Gc 2)Job In Oracle : pl sql create job in Oracle Scheduler https://www.youtube.com/watch?v=Nwmt5S4Mod8&t=248s You can learn useful shell scripts for oracle dba oracle scripts for dba in unix oracle dba scripts 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 sqlplus connect to databaseoracle database monitoring shell scripts
Views: 25985 Tech Query Pond
PL/SQL tutorial 27: How To Create An Explicit Cursor In Oracle Database By Manish Sharma
 
05:03
Learn How To Create An Explicit Database Cursor In Oracle with easy to understand example by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-explicit-cursor Previous Tutorial ► Introduction To Database Cursor - https://youtu.be/_snAMqCBitg ► Simple Loop - https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 59796 Manish Sharma
Cursor PLSQL
 
08:23
Criando Cursor PLSQL - Oracle SQL Developer DECLARE -- Declaração do cursor CURSOR cursor_emp IS SELECT name, salary FROM employee; -- Declaração da variavel para trabalhar com o cursor var_simples cursor_emp%ROWTYPE; BEGIN -- Se o cursor nao estiver aberto, abre ele IF NOT cursor_emp%ISOPEN THEN OPEN cursor_emp; END IF; -- Executa o Loop até que nao encontre mais registros no cursor LOOP FETCH cursor_emp INTO var_simples; -- Sai do Loop quando nao houver mais registros para processar EXIT WHEN cursor_emp%NOTFOUND; dbms_output.put_line('NOME: [ ' || var_simples.name || ' ] SALARIO: [ ' || var_simples.salary || ' ]'); END LOOP; CLOSE cursor_emp; END; /
Views: 33 Cida Luna
Chapter 6 : PL/SQL Control Structure (Conditional Statement - If-Else, Case & Loops)
 
27:29
This chapter shows you how to structure the flow of control through a PL/SQL program. You learn how statements are connected by simple but powerful control structures that have a single entry and exit point. Collectively, these structures can handle any situation. Their proper use leads naturally to a well-structured program. This chapter discusses the following topics: Overview of PL/SQL Control Structures Conditional Control: IF and CASE Statements Iterative Control: LOOP and EXIT Statements Sequential Control: GOTO and NULL Statements
41. Ed or Edit Buffer Command in Oracle
 
02:12
In this video you will learn about Ed or Edit command which is also known as buffer command. I will show you a really quick example to show it. I will also show you how to fix SP2-0110: Cannot create save file "afiedt.buf" error. 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: 20264 ITORIAN
05 - Curso de PL/SQL : Sentencia FOR - LOOP
 
07:18
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: 2021 Mario Ruiz
69- Oracle PL SQL Loops - While Loop تعليم أوراكل
 
09:01
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL - While Loop Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
Debugging PL/SQL with Oracle SQL Developer
 
02:37
Quick 2 minute video showing how to open a PL/SQL program in Oracle SQL Developer and debug it, line by line.
Views: 40773 Jeff Smith
Top 30 PLSQL interview questions and answers
 
10:08
Most frequently asked questions: How to get distinct entries from the database? How to get results of any query which is sorted in any order? What is a mutating table error and how can you get around it? Describe the use of %ROWTYPE and %TYPE in PL/SQL What packages (if any) has Oracle provided for use by developers?Describe the use of PL/SQL tables When is a declare statement needed ? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why? What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? How can you find within a PL/SQL block, if a cursor is open? How can you generate debugging output from PL/SQL? What are the types of triggers? What are two parts of package ? what is the difference between to_char and to_date functions? How do you optimize SQL queries ? What are nested triggers ? What is a bitmap index? What is the usage of NVL? write a query for finding the length of the sting. please explain database architecture. How to get employee name from employee table which is the fifth highest salary of the table? Write a query to generate target column. Can we use out parameter in function? What will be the output for the below Query Select 'High' from dual where null = null; what is the difference between stored procedure and packaged procedure What are the steps you take to tune(performance tuning) the code in plsql? what is self join and how it works?? Can you alter procedure with in package? What is substr()&instr()? Difference between case and decode? Can you use sysdate in check constraints? If no, why? Difference between column level constraints & table level constraints? What is optimizer? What is nested_loop join? What is pivot operator? Tell me some oracle 10g features? What is m_view? What is master & detail tables? What is sqlcode and sqlerrm? Diff b/w procedure & packages? What are the dis_adv of packages? How to retrieve top 3 salaries from each departments? Can you update complex view? If no, why? When should rebuild one an index? Tell me some errors? Tell me some restrictions on cursor variables? What is context switching? What is bulk collect? What is nullif()? What is mutating error? What are the module's , you are working? Which will fire default first statement level or row level trigger? What is bulkcollect? And any restrictions in bulkcollect? What is the use of limit clause in bulkcollect? How to debugg your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? How to update complex view? Subscribe here : https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ
Views: 9587 Oracle PL/SQL
How To Use Explicit Cursor On Oracle PL/SQL
 
08:01
Main Components of Oracle PL/SQL are: BEGIN DECLARE END; / One of feature of Oracle PL/SQL is Cursor. There are two type of Cursor available, which are Implicit Cursor and Explicit Cursor. Implicit Cursor will only processing one record, meanwhile Explicit Cursor will process 1 or more records of data. To use Explicit Cursor we can use the 2+6 formula. 2 for two statements on declaration and 6 for six statements on the content (Begin-End). Please Subscribe
Views: 162 Boby Siswanto
PL-SQL 5   Cursors
 
07:17
https://drive.google.com/file/d/0BxYoN5rLDBaRWGRBLWg3RnhXM0E/edit?usp=sharing Course Objectives cursors ---------------------------- Example SET SERVEROUTPUT ON DECLARE vr_zip ZIPCODE%ROWTYPE; BEGIN SELECT * INTO vr_zip FROM zipcode WHERE rownum menor 2; DBMS_OUTPUT.PUT_LINE('City: '||vr_zip.city); DBMS_OUTPUT.PUT_LINE('State: '||vr_zip.state); DBMS_OUTPUT.PUT_LINE('Zip: '||vr_zip.zip); END; ---------------------------- Example SET SERVEROUTPUT ON DECLARE CURSOR c_zip IS SELECT * FROM zipcode; vr_zip c_zip%ROWTYPE; BEGIN OPEN c_zip; LOOP FETCH c_zip INTO vr_zip; EXIT WHEN c_zip%NOTFOUND; DBMS_OUTPUT.PUT_LINE(vr_zip.zip|| ' '||vr_zip.city||' '||vr_zip.state); END LOOP; CLOSE c_zip; END; ---------------------------- Example DECLARE CURSOR c_group_discount IS SELECT DISTINCT s.course_no FROM section s, enrollment e WHERE s.section_id = e.section_id GROUP BY s.course_no, e.section_id, s.section_id HAVING COUNT(*)mayor=8; BEGIN FOR r_group_discount IN c_group_discount LOOP UPDATE course SET cost = cost * .95 WHERE course_no = r_group_discount.course_no; END LOOP; COMMIT; END; ---------------------------- Example DECLARE CURSOR c_grade( i_student_id IN enrollment.student_id%TYPE, i_section_id IN enrollment.section_id%TYPE) IS SELECT final_grade FROM enrollment WHERE student_id = i_student_id AND section_id = i_section_id; CURSOR c_enrollment IS SELECT e.student_id, e.section_id FROM enrollment e, section s WHERE s.course_no = 135 AND e.section_id = s.section_id; BEGIN FOR r_enroll IN c_enrollment LOOP FOR r_grade IN c_grade(r_enroll.student_id, r_enroll.section_id) LOOP UPDATE enrollment SET final_grade = 90 WHERE student_id = r_enroll.student_id AND section_id = r_enroll.section_id; END LOOP; END LOOP; END;
Views: 565 Fdo Luis
aula 2463   PL SQL CURSOR com loop NOTFOUND
 
06:22
Bem vindos a mais um curso de Oracle. Meu nome é Neri Neitzke, sou autor de 6.500 videoaulas. Já ministrei mais de 160 palestras em 8 países (Estados Unidos, Colômbia, Portugal, Angola, Moçambique, Cabo Verde, Guiné-Bissau e por todo o Brasi), entrem em contato para ter uma palestra pelo email [email protected] ou pelo fone 54 3329 5400
Views: 497 Neri Neitzke
What is Hard-Coding in PL/SQL?
 
08:14
Practically Perfect PL/SQL with Steven Feuerstein See the first in a multi-video series that describes the nuances of hard-coding in PL/SQL. 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.
C# Tutorial 11:Database values in textbox if select Combobox
 
12:15
------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter ----------------------------------------------------------------------- how to bind combobox to textbox in C# ComboBox and TextBox‎ C# How to show combo box selected value in a text box‎ C# selecting an item in combobox and display corresponding Populate combobox from database C# How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView C# code add database column to datagridview combobox C# Populate combobox from database How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView code add database column to datagridview combobox Enter values into combobox from database‎ Enter values into combobox from database‎ C#
Views: 211271 ProgrammingKnowledge
how to fetch or populate data from database to jframe or jtable [SOLVED]- java tutorial #14
 
08:06
Bring the data from back end to front end in java netbeans.... or want to see or bring the database's data to your jframe in java or jtable here i will show you how to do that.... ============================================== IMPORTANT LINKS: -- rs2xml ( JAR FILE) https://drive.google.com/file/d/0BwUVtTEFk6GAVzItTzV1ZnlPVE0/view?usp=sharing -- SQLITE JDBC (JAR FILE) https://drive.google.com/file/d/0BwUVtTEFk6GAMmc0WmF0SUl2d3c/view?usp=sharing for any query drop your comments below this video please rate comment and subscribe for more videos..
Views: 78711 GSoft Knowledge
MySQL VB.NET Tutorial 18 : Checkbox , radiobutton and groupbox with Database
 
09:46
GroupBox How to auto create radiobutton and groupbox VB.NET C sharp tutorial How to build two radio button groups in Visual VB.NET 2010 I need to build two groups of radio buttons, so that client can put an answer in ... your radio boxes will be grouped by which group box they are in. ... Defining environment variables for visual studio 2010 to use during build? Radio buttons and check boxes to display selected in textbox Getting User Choices: Using Check Boxes and Radio Buttons Check box, Radio button, and Group box in Visual . Let's now use the check box, radio button, and group box in a single application Radio Buttons - Visual VB.NET
Views: 58473 ProgrammingKnowledge
PL/pgSQL con PostgreSQL 9.5 - Cursores (Cursors, Fetch, Open, Close)
 
13:27
- Cursores - Declaracion de cursores - Abrir y cerrar cursores - Uso de Cursores - Usando Fetch Todo esta basado en la documentación oficial que se encuentra para esta versión 9.5 . http://www.postgresql.org/docs/9.5/static/index.html
Views: 2500 SYSGAP
How to write the Select Query in SAP ABAP
 
31:22
SAP ABAP : USING SQL QUERY OR SELECT QUERY FOR FETCH THE DATA FROM DATABASE TABLES AND STORE THE INTERNAL TABLE...AND DISPLAY THE RETRIEVABLE DATA WITH USING OF LOOP STATEMENT FROM INTERNAL TABLES INTO STRUCTURE... [email protected]
Views: 61000 Ramesh Kumar
Podcast Episode #18: Understanding the Fetch Block in Scribe Online
 
11:25
The fetch block in Scribe Online IS advanced maps allows an integration the ability to process records from an additional data set—conceptually, this is similar to a sub query. The fetch block is available for any Connector for any entity that supports reads. In this podcast, we will discuss use-cases around the fetch block, including the ability to build ad-hoc relationships when a relationship is not exposed through a Scribe Online Connector. Additionally, you’ll learn how to use the fetch block to process all of your data sets that are in scope of the map. In the sample ADV map blocks to the left, you'll see a map in Scribe Online that will query "sales order" headers from a source, processing each header record from the result set one-at-a-time. For each header, it will upsert a record to the target application, and then process each of the "sales order line item(s)" from a result set returned by the fetch block. After all of the fetched line items have been processed, the map will exit the fetch block and continue through the rest of the map—which has currently been left empty. For users already familiar with Scribe Online Advanced Maps, you can think of the fetch block as a combination of the query and lookup operation blocks. http://blog.scribesoft.com/s01e18-understanding_the_fetch_block_in_scribe_online/
Views: 796 Scribe Software
How to Display Selected Database Columns in JTable in Java Swing
 
03:27
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g Watch More Java Swing(Windows Builder) GUI Tips ans FAQS Here: https://www.youtube.com/playlist?list=PLErD1cRL87W-NzXGuV1tAGO8kf2zrqU0k IN this video i shown How to Display Selected Column in JTable in Java Swing, How to fetch the data and add display them in your prefered jtable __________________________________________________________________ Also Watch More Java Swing Tutorials How to Display Time and Date In java Swing https://youtu.be/i-M08_hATzM How to Set Password Limit Attempts in Java Swing https://youtu.be/6SxzUHHRnsA How to Print JTable Without any Jar in Java Swing https://youtu.be/0Z9IfjIAMo8 How to Increase Font Size in Eclipse IDE https://youtu.be/dcevO7XNjB8 How to Generate Random Numbers in Java Swng https://youtu.be/qvaXkqt9OSU How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/xm1ovgF9FNA How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/1QiWXpqT28s How to Fetch Database Column in JComboBox Java Swing https://youtu.be/V_KkRr0DJ4c Java swing close window on button Clicked https://youtu.be/mblB8eG2mjA How to Display Selected Database Columns in JTable in Java Swing https://youtu.be/oz4iD_lidHg How to Delete Row From JTable in Java Swing https://youtu.be/accjKR4fxUM How to Convert String to Integer and Vice Versa https://youtu.be/MsfpBRZbkxA How to Close Current Frame When Clicked on Exit Java Swing https://youtu.be/PLrnvBIO-lA How to Calculate JTable Column Values in Java Swing https://youtu.be/zu57Gdg5TDY How to Add JTextField Values in Jtable DefaultTableModel in Java Swing https://youtu.be/Wl5guY77TUc How to Add Image to JButton in Java Swing https://youtu.be/jGYqtIWn5OY How to Print Jtable Data in Java Swing https://youtu.be/zaMhFY1-0eI How to Add or Remove Values in Database in Java Swing https://youtu.be/ARQ0UHukZzI How to Generate Random Numbers in Java https://youtu.be/p0psde93IBg How to Show Selected Colomn in JLable From Database in Java https://youtu.be/ydjouDv8tzQ How to Display Message in JLable in Java Swing https://youtu.be/L8xs35wX1QY Validations for JTextField in Java Swing Application https://youtu.be/MxEvihnQOD0 How to Open Two JFrames on One Button Click in Java https://youtu.be/zW9jn8e2lnc
Views: 16955 Intact Abode
MySQL VB.NET Tutorial 16 : How to Link Chart /Graph with Database
 
19:00
Creating graph in Windows Forms Application Mysql vb.net Data Binding a Chart to a Database visual basic Line chart in c# using data from database - Graph database for vb.NET How to Create Excel graphs using vb Program Creating graphs using visual studio Graph And Sql Data - C# Programming Using Chart Control in Visual Studio 2010 C beginners Creating graph in Windows Forms Application Charts in SQL Server Reporting Mysql Threaded plotting in Visual Studio visual basic with Windows Forms vb.net Windows Forms application How to reload a fastline chart using Windows.Forms Windows Charting Application Learn the Windows Forms Chart Control How do I plot data on a Chart in a CLR Form in C#?‎ Mysql how to draw line graph in .net?‎ Mysql Plot with visual studio C# express‎ Mysql
Views: 78716 ProgrammingKnowledge
Insert Update Delete View and search data from database in C#.net
 
13:47
Need Help Or Need code? Feel Free To Contact Us Here http://www.noblecomputer.co.in/support.php using this tutorial you can easily understand that how you can do Insert Update Delete and View data from database in C#.net | insert update delete in c#.net | Insert Update Delete View and search data from database in C#.net,Legen Ansicht aktualisieren und Suchdaten aus der Datenbank in C # .net Löschen,Insérez Update Supprimer Afficher et recherche les données de base de données en C # .net, database connectivity in c#, c# connection to sql server.
Views: 390767 Amit Andipara
SEARCHING/SHOWING RECORD FROM DATABASE USING RESULT SET & PREPARED STATEMENT IN JAVA IN HINDI
 
15:09
SEARCHING RECORD FROM DATABASE USING RESULT SET & PREPARED STATEMENT IN JAVA IN HINDI SHOWING RECORD IN DATABASE USING RESULT SET & PREPARED STATEMENT IN JAVA IN HINDI HOW TO INSERT, UPDATE , DELETE , SEARCH RECORD IN JAVA HOW TO SEARCH RECORD ON CLICK IN JAVA USRE FORM EASY TO MAKE SEARCH BUTTON IN JAVA DESKTOP APPLICATION 2017 how to make java application how to use insert button in java how to insert record in java how to connect java with sql server how to make desktop application in java how to make school management system in java how to use java netbeans to make desktop application desktop application in java how to make jframe in java how to search record in jframe how to update record in jframe how to delete record in jframe ===================== CODE ===================== public void ShowRecord(){ try { String sql = "select EmpName,EmpDepartment,EmpSalary,Doj,Email,Gender,[status],Dol from empinfo where empid='" + txtempid.getText() + "' "; pst = con.prepareStatement(sql); rs = pst.executeQuery(); if (rs.next()) { txtempname.setText(rs.getString(1)); ComboDep.setSelectedItem(rs.getString(2)); txtempsalary.setText(rs.getString(3)); txtempdoj.setText(rs.getString(4)); txtemail.setText(rs.getString(5)); String gender = rs.getString(6); if (gender.equalsIgnoreCase("male")) { malebtn.setSelected(true); } if (gender.equalsIgnoreCase("female")) { femalebtn.setSelected(true); } String state = rs.getString(7); if (state.equalsIgnoreCase("working")) { status.setSelected(false); } if (state.equalsIgnoreCase("left")) { status.setSelected(true); } txtdol.setText(rs.getString(8)); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e); } } HOW TO MAKE EMPLOYEE MANAGEMENT SYSTEM ON JAVA More Relevant videos (Desktop application) • How to make Java Desktop Application how to make user form more attractive using mouseEnter event https://www.youtube.com/watch?v=1uRbKtNi3sA • How to make Desktop Application how to add Items in Combobox and add Column in jtable https://www.youtube.com/watch?v=IVjUQe_OWwo • How to make java Desktop Application how to use jTable , Radio button & Group button https://www.youtube.com/watch?v=8zSLJfta-dM • How to make Desktop Application - How to make GUI on java in Urdu/hindi https://www.youtube.com/watch?v=buGArtryr_U • How to make Java Desktop Application How to use jpanel in Java Desktop Application (2) https://www.youtube.com/watch?v=Npvw9wP3Cfo • How to make Java Desktop Application How to use jpanel in Java Desktop Application (1) https://www.youtube.com/watch?v=33_u6UaZzQM • How to make Java Desktop Application - How to login on Enter key pressed in Java in Urdu/Hindi https://www.youtube.com/watch?v=eCHb_VUkIcE • Java Desktop Application - How to show and hide password in java in Urdu/Hindi https://www.youtube.com/watch?v=jJtVgxcrHe8 • Java Desktop Application - How to make Login Form in java in Urdu/Hindi https://www.youtube.com/watch?v=zi7LfGq00oo • Java Desktop Application - How to make Exit Button & Minimize Button in java https://www.youtube.com/watch?v=ms0BoZkVS5k • Java Desktop Application - How to make Splash screen in java in urdu & hindi https://www.youtube.com/watch?v=ZHpXkeBAsP0 • HOW TO MAKE DESKTOP JAVA APPLICATION SUCH AS SCHOOL MANAGEMENT SYSTEM https://www.youtube.com/watch?v=bS5sTT9-yB0 • HOW TO UPDATE RECORD IN JAVA USER FORM AND HOW TO MAKE UPDATE BUTTON IN JAVA https://youtu.be/1vXjP1PIUOo
SQL Server Exit Stored Procedure with RETURN
 
02:38
DECLARE @myMessage varchar(100) EXEC Testing @salary = 200000, @Sex = 'Other', @Message = @myMessage OUTPUT select @myMessage as [Out Put] --===============CREATE PROC=================== CREATE PROC Testing @salary int, @sex varchar(100), @Message varchar(100) OUTPUT AS BEGIN IF @salary LESSTHAN 100000 BEGIN SET @Message = 'Sorry you cannot join our club, make more money!' RETURN END SET @Message = CASE @sex WHEN 'Male' THEN 'Welcome, Club Somking Jacket is in the Mail!' WHEN 'Female' THEN 'Welcome, Club Dress is in the Mail!' ELSE 'Welcome, Club Hat is in the Mail!' END END
Views: 195 CKWTech LLC
Loops in SQL Part - 2
 
10:27
A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . ... If and only if the value of this expression is TRUE , the statements after LOOP execute. cursor_for_loop_statement. Issues a SQL query and loops through the rows in the result set. Writing Loops in SQL. In programming, a loop allows you to write a set of code that will run repeatedly within the same program. Many programming languages have several different types of loop to choose from, but in SQL Server there is only one: the WHILE loop TYPES OF LOOPS 1 SIMPLE LOOPS 2 CURSOR FOR LOOPS 3 WHILE LOOPS 4 NUMARIC FOR LOOPS A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . With each iteration, the sequence of statements is executed, then control resumes at the top of the loop. An EXIT , GOTO , or RAISE statement branches out of the loop. At each iteration, the sequence of statements is executed and then control resumes at the top of the loop. 2. PL/SQL WHILE LOOP. Repeats a statement or group of statements while a given condition is true. It tests the condition before executing the loop body. Variables in SQL procedures (DECLARE, SET statements) ... Values can be assigned to variables using the SET statement or the SELECT INTO statement or as a default value when the variable is declared. Literals, expressions, the result of a query, and special register values can be assigned to variables. The WHILE loop test at the start of the loop and it the condition is false, the loop code is never executed. ... This is referred to as a REPEAT-UNTIL or DO-WHILE loop. PL/SQL does not directly implement a REPEAT-UNTIL loop however it is easy to construct one using an endless loop. The init step is executed first, and only once. This step allows you to declare and initialize any loop control variables. ... If it is true, the loop executes and the process repeats itself (body of loop, then increment step, and then again condition). After the condition becomes false, the 'for' loop terminates.
Views: 22 Technology mart
How to Install phpMyAdmin on  RHEL7
 
09:05
How to Install phpMyAdmin on RHEL7 Install Apache Mysql and PHP: https://youtu.be/E3P34-FsVto For More Tutorials, Tips, Tricks and Hacks on Linux, Oracle, Android, Windows, Whatsapp click on the Below Links. Subscribe : https://www.youtube.com/subscription_center?add_user=technologylair Website : http://techlair.info Facebook : https://www.facebook.com/technologylair
Views: 148 TechLair
C# Tutorial 23: How to use DateTimePicker and save date in Database
 
14:04
Visual C# .NET Controls The Date Time Picker - Date Picker C# - How do I set my datetimepicker date? visual C# - DateTimePicker date to string C# How to compare the time of a DateTimePicker control and the How do I get value from Date time picker and Month calendar C# How to pass values to a dateTimePicker control‎ C# How to change DateTimePicker control to 24h time format ? Getting started with the DateTimePicker Visual Studio 2012 RC - Age calculation from Converting date time picker value into t_time type date time picker‎ - 7 posts DateTimePicker - Visual C# assign SYSTEMTIME to DateTimePicker Control‎ C#
Views: 336579 ProgrammingKnowledge