Home
Search results “Oracle loop for sql”
PL/SQL tutorial 11: PL/SQL Simple Loop in Oracle Database by Manish Sharma RebellionRider.com
 
04:21
First tutorial in Iterative statement series explaining concepts of Simple Loop in PL/SQL With a quick brief intro of Loops in Oracle PL/SQL ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/simple-loop Previous Tutorial ► IF-THEN : https://youtu.be/IWvuFD6eD30 ► Simple CASE Statement https://youtu.be/DMlDwOmqAzo ► Searched CASE Statement https://youtu.be/jk7k4TDs3F0 ► DECODE Statement https://youtu.be/lKXqXINCNLo ------------------------------------------------------------------------- ►►►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: 73641 Manish Sharma
PL/SQL tutorial 13: PL/SQL FOR Loop In Oracle Database by Manish Sharma RebellionRider.com
 
06:14
3rd and the last tutorial in Iterative/loop statement in Oracle PL/SQL series explaining concepts of FOR loop with examples by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/numeric-for-loop-in-pl-sql Previous Tutorial ► While Loop https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►►►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: 60751 Manish Sharma
PL/SQL tutorial 30: Cursor FOR Loop In Oracle Database By Manish Sharma
 
04:33
Learn How To Work with Database (Explicit or Implicit) Cursors using Cursor For Loop in Oracle Database With Example By Manish Sharma on RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-1 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ►Install SQL Developer: https://youtu.be/zliF8kXVmeE ------------------------------------------------------------------------- ►►►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: 43069 Manish Sharma
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: 63684 Manish Sharma
06- Oracle PL/ SQL Arabic Course - Basic loop التكرار
 
09:09
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر لتعلم أوراكل من الصفر حتى الاحتراف فى درس اليوم نتحدث عن Basic loop التكرار .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com/
Views: 4400 Ask Gad
70- Oracle PL SQL Loops - For Loop تعليم أوراكل
 
08:01
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL - For Loop Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
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
68 - Oracle PL/SQL Loops - Loop Statement تعليم أوراكل
 
15:04
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Loop Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
08- Oracle PL /SQL arabic course   For loop  اوراكل ديفلوبر
 
04:52
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح PL/SQL فى درس اليوم نتحدث عن For loop .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 3679 Ask Gad
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
71. FOR LOOP Looping Command in PL/SQL Oracle
 
09:54
In this video you will learn about FOR LOOP Looping Command 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: 5373 ITORIAN
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
Cursor For Loop in Oracle PLSQL
 
02:46
This video shows how to fetch values in a cursor using Cursor For Loop.
Views: 876 yrrhelp
PL/SQL Simple Loop in Oracle Database
 
05:55
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: 83 Nayabsoft
18/125 Oracle PLSQL: Basic Loop
 
11:41
Learn Oracle PLSQL EXAM 1Z0-144
Views: 1622 khaled alkhudari
IF,While Loop in SQL Server
 
57:10
Website:https://www.eclasess.com loops in sql server If loop While Loop
07- Oracle PL SQL arabic course   while loop - شرح  PL/SQL اوراكل ديفلوبر
 
05:38
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح PL/SQL فى درس اليوم نتحدث عن كيفية استخدام جمل التكرار While loop .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 4098 Ask Gad
72. LOOP Looping Command in PL/SQL Oracle
 
02:20
In this video you will learn about LOOP Looping Command 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: 3799 ITORIAN
PL/SQL: Cursors using FOR loop
 
05:10
In this tutorial, you'll learn h.ow to write a cursor using for loop and the advantage of it. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. 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. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 18557 radhikaravikumar
Introduction to Oracle: PL-SQL - LOOP Statement
 
04:36
Introduction to Oracle: PL-SQL - LOOP Statement
Views: 242 David Hays
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: 30662 Manish Sharma
Oracle Pl/sql Cursors (Implicit, Explicit, Open-Fetch-Close, FOR LOOP cursors, Cursor Attributes)
 
21:53
This video is to understand the concept of Oracle PL/SQL Cursors (implicit and explicit ). The video includes tutorial on how to work with Oracle PL/SQL Cursor in everyday programming.
Views: 4751 Kishan Mashru
Oracle PL/SQL Tutorials | PL:SQL EXIT and CONTINUE in FOR LOOP | Mr.Vaman Deshmukh
 
04:36
Oracle PL/SQL Tutorials | PL:SQL EXIT and CONTINUE in FOR LOOP | Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
19/125 Oracle PLSQL: While Loop
 
04:49
Learn Oracle PLSQL EXAM 1Z0-144
Views: 1373 khaled alkhudari
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: 77769 WiseOwlTutorials
PL/SQL Tutorial 17-NESTED LOOP  in (PL/SQL)Oracle Database By JavaInHand (in Hindi)
 
07:17
NESTED LOOP IN PL/SQL? ---------------------------------------- SYNTAX OF NESTED TABLE IN PL/SQL -------------------------------------------------------------- EXAMPLE OF NESTED LOOP IN PL/QL
Views: 621 JavaInHand
ORACLE PL/SQL - Ejemplo de un Ciclo Loop con Oracle PL/SQL
 
02:59
-------------------------------------------------------------------------------- -- PRIMER PASO: Creacion de una tabla -------------------------------------------------------------------------------- -- Creacion de una tabla create table REGISTRO( nombre varchar2(30), promedio number(15), clave NUMBER(15) ); -------------------------------------------------------------------------------- -- SEGUNDO PASO: Realizamos un Segmento de Codigo que realiza un ciclo loop para -- insertar registros de manera ciclica --------------------------------------------------------------------------------
Views: 655 TurotialesTI
PL-SQL tutorial 26 - Iterative Control Structure Simple loop
 
03:39
Hi guys today i am going to explain about Iterative Control Structure Simple loop in PL/SQL how to write a code in iterative looping concept. Oracle database Unbeatable,Unbreakable Platform..
Views: 694 Oracle World
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: 2065 Mario Ruiz
PL SQL For Loop - PL SQL While Loop Example - Loops in Oracle PL SQL - PL SQL Loop
 
18:19
Oracle PL/SQL has 3 forms of looping statements or looping structures. PL/SQL simple loop, PL/SQLFor Loop and PL/SQL While Loop. All the three have been explained here with nice examples. The code of the example programs has been given below - #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Interview Question : What is Anchored data type in PL/SQL, why is it required to be used? [For answer refer to the list of following videos] Videos to visit : 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 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/ Code for programs : Example simple loop ===================== declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; loop exit when num1 [greater than] num2; if mod(num1, 2) = 0 then sqr := num1 * num1; dbms_output.put_line ('square of '||num1||' is '||sqr); end if; num1 := num1 + 1; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example While Loop ========================== declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; While num1 [less than] num2 loop if mod(num1, 2) = 0 then sqr := num1 * num1; dbms_output.put_line ('square of '||num1||' is '||sqr); end if; num1 := num1 + 1; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example For Loop ========================= declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; for n in num1..num2 loop if mod(n, 2) = 0 then sqr := n * n; dbms_output.put_line ('square of '||n||' is '||sqr); end if; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example Reverse For Loop ============================= declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; for n in reverse num1..num2 loop if mod(n, 2) = 0 then sqr := n * n; dbms_output.put_line ('square of '||n||' is '||sqr); end if; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end;
Views: 69 Crazy4 DB
PL-SQL tutorial 14 - HOW TO USE FOR LOOP
 
04:46
hi guys today we lean how to use FOR LOOP in plsql language Oracle database Unbeatable,Unbreakable Platform.. #FORLOOP
Views: 587 Oracle World
The Importance of Nested Loops Joins in SQL
 
07:37
Nested Loops Joins are one of the primary physical join operators used by SQL Server. In today's episode we discuss how Nested Loops Joins work, as well as how to use that knowledge to troubleshoot a slow performing query's execution plan. Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/bertwagner?sub_confirmation=1 Related blog post with code snippets: https://bertwagner.com/2018/12/11/visualizing-nested-loops-joins-and-understanding-their-implications/ Be sure to check out part 2 on merge joins: https://youtu.be/IFUB8iw46RI And part 3 on hash match joins: https://youtu.be/59C8c7p_hII Additional excellent blog posts that go further in-depth: https://blogs.msdn.microsoft.com/craigfr/2006/07/26/nested-loops-join/ https://sqlserverfast.com/epr/nested-loops/ Follow me on Twitter: https://twitter.com/bertwagner
Views: 1302 Bert Wagner
12- Oracle PL/SQL Arabic Course  Cursor for loop اوراكل  ديفلوبر
 
14:01
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح PL SQL فى درس اليوم نتحدث عن Cursor for loop for update current of .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 4332 Ask Gad
Nested Loop Join on SQL
 
05:03
Nested Loop Join on SQl
Views: 203 TUTOR SC
SQL Joins, nested loops and all that in less than 6 minutes
 
05:52
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. A very brief description of how a database performs a join, based on material from a 2-day seminar.
Views: 77958 roughsealtd
PL-SQL tutorial 27 - Iterative Control Structure WHILE LOOP
 
04:39
Hi guys today i am going to explain about Iterative Control Structure while loop in PL/SQL how to write a code in iterative looping concept. Oracle database Unbeatable,Unbreakable Platform..
Views: 254 Oracle World
Oracle 10g PL SQL Class 8-Loop Structure
 
15:51
Website: http://javaknowledge.info Source code: http://www.trainingwithliveproject.com FB Page: https://www.facebook.com/javaknowledgeshare FB Group: https://www.facebook.com/groups/PBPTBD
Views: 281 Java Knowledge
PL-SQL tutorial 28 - Iterative Control Structure FOR LOOP
 
05:47
Hi guys today i am going to explain about Iterative Control Structure For loop in PL/SQL how to write a code in iterative looping concept. Oracle database Unbeatable,Unbreakable Platform..
Views: 305 Oracle World
How to Fetch Data By Using Cursor for loop In Oracle Form
 
06:55
How to Fetch Data By Using Cursor for loop In Oracle Form
Views: 253 Young India
Cursors in sql server   Part 63
 
13:58
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-63-cursors-in-sql-server.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 Relational Database Management Systems, including sql server are very good at handling data in SETS. For example, the following "UPDATE" query, updates a set of rows that matches the condition in the "WHERE" clause at the same time. Update tblProductSales Set UnitPrice = 50 where ProductId = 101 However, if there is ever a need to process the rows, on a row-by-row basis, then cursors are your choice. Cursors are very bad for performance, and should be avoided always. Most of the time, cursors can be very easily replaced using joins. There are different types of cursors in sql server as listed below. We will talk about the differences between these cursor types in a later video session. 1. Forward-Only 2. Static 3. Keyset 4. Dynamic Let us now look at a simple example of using sql server cursor to process one row at time. We will be using tblProducts and tblProductSales tables, for this example. On my machine, there are 400,000 records in tblProducts and 600,000 records in tblProductSales tables. If you want to learn about generating huge amounts of random test data, please watch Part - 61 in sql server video tutorial. The link is below. http://www.youtube.com/user/kudvenkat/videos?flow=grid&view=1 Cursor Example: Let us say, I want to update the UNITPRICE column in tblProductSales table, based on the following criteria 1. If the ProductName = 'Product - 55', Set Unit Price to 55 2. If the ProductName = 'Product - 65', Set Unit Price to 65 3. If the ProductName is like 'Product - 100%', Set Unit Price to 1000 For the SQL code samples used in the demo please visit my blog at the following link http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html The cursor will loop thru each row in tblProductSales table. As there are 600,000 rows, to be processed on a row-by-row basis, it takes around 40 to 45 seconds on my machine. We can achieve this very easily using a join, and this will significantly increase the performance. We will discuss about this in our next video session. To check if the rows have been correctly updated, please use the following query. Select Name, UnitPrice from tblProducts join tblProductSales on tblProducts.Id = tblProductSales.ProductId where (Name='Product - 55' or Name='Product - 65' or Name like 'Product - 100%')
Views: 224509 kudvenkat
pl-sql tutorial in hindi lec 12 (while loop in plsql)
 
04:54
http://www.bitsinfotec.in/
Views: 256 JavaTreePoint
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: 1342 Subhroneel Ganguly
PLS-10: Oracle Pl/SQL Cursors With Parameters
 
11:09
Oracle PL/SQL For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 40538 Oresoft LWC