Home
Search results “Cursor oracle found”
PL/SQL Tutorial  5 : PLSQL Cursors , Implicit Cursors & Explicit Cursors
 
16:07
Oracle PLSQL Tutorials For Beginners 5 : PLSQL Cursors , Implicit Cursors & Explicit Cursors Cursor Attributes 1) %FOUND 2) %NOTFOUND 3) %ISOPEN 4) %ROWCOUNT SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 782 TechLake
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: 270 YourSmartCode
دورة Oracle Developer - الدرس التاسع عشر -  explicit cursor
 
20:31
في هذا الدرس سنتعلم الأمور التالية : Explicit cursors Explicit Cursor Attributes %ISOPEN %NOTFOUND %FOUND %ROWCOUNT
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: 4550 Ask Gad
Implicit cursor attributes in oracle plsql.
 
16:36
In this oracle tutorial I have demonstrated 4 attributes of oracle pl sql implicit cursor. Among this SQL%ISOPEN is not important and of least use, but the other three attributes are very important. These are SQL%ROWCOUNT, SQL%FOUND and SQL%NOTFOUND.
Views: 725 Subhroneel Ganguly
Tutorial 26 : EXPLICIT CURSOR IN PL SQL || DECLARE || OPEN || FETCH DATA || CLOSE
 
06:55
Hi Friends, Here we are learning, What is Explicit Cursor? And How we can use that? We are learning about how to DECLARE CURSOR, OPEN CURSOR, FETCH DATA INTO CURSOR and CLOSE CURSOR. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (Cursor Introduction) : https://youtu.be/XlunuLQZUmw Link (Implicit Cursor and Cursor attributes explained, %FOUND, %NOTFOUND, %ROWCOUNT) : https://youtu.be/9_XHNWEgJnE Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding :)
Views: 75 YourSmartCode
Oracle Rownum vs Rowcount
 
05:01
Oracle Rownum Vs Rowcount
Views: 95 Siva Academy
Oracle DECODE Function
 
04:31
https://www.databasestar.com/oracle-decode-function/ The Oracle DECODE function lets you perform IF-THEN-ELSE functionality in your queries. It’s similar to a CASE statement. The syntax of the DECODE function is: DECODE ( expression, search, result [, search, result]... [,default] ) The parameters of the Oracle DECODE function are: - expression (mandatory): This is the value to compare. - search (mandatory): This is the value to compare against the expression. - result (mandatory): This is the return value if the search value matches the expression value. There can be multiple combinations of search and result values, and the result value is attached to the previous search value. - default (optional): If none of the search values match, then this value is returned. If this is not provided, the DECODE function will return NULL if no matches are found. If you compare this to an IF-THEN-ELSE statement, it would look like this: IF (expression = search) THEN result [ELSE IF (expression = search) THEN result] ELSE default END IF The parameters can be one of many different data types, and the return type is calculated from them. Earlier I mentioned it’s similar to CASE. So why would you use one and not the other? - DECODE is an older function, and CASE was introduced as a replacement for DECODE. - CASE offers more flexibility then DECODE - CASE is also easier to read and debug (in my opinion) The performance of these functions is the same, so if you’re considering using DECODE, I would suggest using CASE instead. For more information about the Oracle DECODE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-decode-function/
Views: 592 Database Star
COL10: Working with Multilevel (Nested) Collections
 
49:01
You can define collections of collections (directly or indirectly). The multilevel collection is one of the most complicated and powerful features of PL/SQL. This lesson covers the syntax and then explores through several examples how to leverage this feature. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. Code to explore topics in this video may be found at Oracle Live SQL: https://livesql.oracle.com/apex/livesql/file/index.html#nested+collection ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
PL/SQL tutorial | Cursor in Oracle Database 11g Complete guide
 
13:50
Learn in depth about cursor in oracle database 11g, and why to use cursor.Writing Implicit cursor and explicit cursor following using 'for loop' inside cursor to fetch multiple records from oracle database. Cursor in Oracle Cursor in PL/SQL Oracle Cursor PL/SQL Cursor What is cursor in PL/SQL How to use cursor in PL/SQL Implicit cursor in PL/SQL Explicit cursor in PL/SQL A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set. Implicit Cursors Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, when there is no explicit cursor for the statement. Programmers cannot control the implicit cursors and the information in it. %FOUND Returns TRUE if an INSERT, UPDATE, or DELETE statement affected one or more rows or a SELECT INTO statement returned one or more rows. Otherwise, it returns FALSE. %NOTFOUND The logical opposite of %FOUND. It returns TRUE if an INSERT, UPDATE, or DELETE statement affected no rows, or a SELECT INTO statement returned no rows. Otherwise, it returns FALSE. %ISOPEN Always returns FALSE for implicit cursors, because Oracle closes the SQL cursor automatically after executing its associated SQL statement. %ROWCOUNT Returns the number of rows affected by an INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. Explicit Cursors Explicit cursors are programmer-defined cursors for gaining more control over the context area. An explicit cursor should be defined in the declaration section of the PL/SQL Block. It is created on a SELECT Statement which returns more than one row Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 2235 Specialize Automation
Oracle Core, Лекция 8-2
 
41:33
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1bP7sQWHICvy1QQn8GfWHir9Rhx9l2NuPTJ1sFwZPrIw/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/16ZYf--sK4dvxTtJJexq0-OUSiOuZb8cqvkkYzPoYhgU/edit?usp=sharing 1. Session курсор. Типы курсоров 2. Implisit cursor. Ключевое слово sql. Атрибуты implicit курсоров: isopen, found, notfound, rowcount 3. Explicit cursor. Объявление курсора 4. Операции open cursor и close cursor. Возможные exceptions (invalid_cursor, cursor_already_open) 5. Извлечение данных из курсора. Операция fetch 6. Параметры в курсоре 7. Атрибуты explicit курсора: isopen, found, notfound, rowcount 8. Операции select into, select bulk collect into. Возможные исключения: no_data_found, too_many_rows 9. Цикл с курсором (cursor for loop statement) 10. Курсорная переменная (cursor variable). Ref cursor. Сильный и слабые курсоры. 11. Операции с курсорной переменной: open, close, fetch. Возможные исключения: rowtype_mismatch. Тип SYS_REFCURSOR. 12. Курсорное выражение (cursor expression) 13. Использование открытых и закешированных закрытых курсоров при выполнении dml операторов. 14. Параметры БД (open_cursors, session_cashed_cursors, cursor_space_for_time) 15. Словари данных: v$open_cursor, v$sesstat Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
lec 14 of 2 implicit cursor in plsql
 
13:35
http://www.bitsinfotec.in/ What is implicit cursor in plsql in hindi, implicit cursor in pl-sql, cursor in hindi, plsql in hindi cursor, SQL%found, SQL%notfound in pl sql in hindi
Views: 302 JavaTreePoint
PL/SQL:Exceptions
 
12:09
In this tutorial, you'll learn the difference between compile & run time error and how to handle the exceptions..
Views: 15362 radhikaravikumar
Cursors in Oracle PLSQL
 
09:30
This Video Explains. 1. What is CURSOR in Oracle PLSQL 2. How to use cursor in Oracle PLSQL 3. How to declare,open and fetch values in CURSOR 4. CURSOR Attributes 5. Implicit cursor and explicit cursor 6. CURSOR TYPES
Views: 2790 yrrhelp
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: 41547 Manish Sharma
دورة Oracle Developer - الدرس السادس عشر - interacting oracle server
 
19:43
في هذا الدرس سنتعلم الامور التالية : interacting oracle server reference variable insert , update , delete on plsql implicit sql cursor : sql%rowcount sql%notfound sql%found sql%isopen
What is Cursor? Types of Cursors and their Attributes  of Cursors In  Oracle PLSQL
 
21:15
Here I am Discussing About the Cursors in PL/SQL and Types of Cursors and Their Attributes of Cursors.
Views: 2924 Useful Tips
PLS-11: Oracle PL/SQL Reference Cursor
 
08:43
Oracle 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: 74119 Oresoft LWC
PL/SQL tutorial 26: Introduction to PL/SQL Cursor in Oracle Database By Manish Sharma
 
05:10
Learn What are cursors, what are types(Explicit and implicit), and steps of cursor's creation in oracle database by Manish Sharma From RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-database-cursors Previous Tutorial ► Pl/SQL Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►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: 97832 Manish Sharma
how to get your mouse/cursor back (if it has gone missing ) Windows 10
 
02:32
if this helped you leave a comment.
Views: 242490 Master Bones
PLSQL Básico - Cursores Implícitos (Implicit Cursors)
 
14:44
Cuando se ejecutan sentencias DML (select, insert, delete, update) automaticamente se hace el proceso de apertura de la tabla, proceso de la informacion y cerrado, es por eso que se llama Cursor Implícito ya que no necesitamos hacer la declaracion de cursores como lo que pasa para un cursor explícito.
Views: 8867 Daniel Nieto
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: 54971 Manish Sharma
PLS-9: Oracle PL/SQL Cursor
 
23:59
Oracle 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: 126461 Oresoft LWC
PLSQL Básico - Cursores Implicitos (vs cursores explìcitos) - Excepciones
 
21:50
Un cursor implícito es ejecutado cuando una sentencia DML es lanzada. En el caso de las sentencias UPDATE, DELETE, INSERT no es necesario agregar más código para ser usadas aunque se puede obtener informacion del proceso que ejecutaron tal como ver si encontró el set a procesar con SQL%FOUND o SQL%NOTFOUND y cuantas lineas fueron procesadas con SQL%ROWCOUNT. En el caso de la sentencia SELECT es donde se dan más diferencias ya que un cursor implícito está diseñado para regresar el resultado de una sola fila con una o más columnas, en el caso de que haya más de un resultado o ninguno, enviará un mensaje de error, cuando el manejo de los errores lo hacemos en la parte de EXCEPTION estamos transladando escenarios previstos a una parte de excepciones que tiene otro propósito. Se recomienda siempre usar cursores explícitos ya que nos da control para el manejo de los distintos escenarios por lo tanto también se muestran las diferencias entre usar cursores implícitos y explicitos.
Views: 18393 Daniel Nieto
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: 17738 radhikaravikumar
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: 40140 Oresoft LWC
9. Send app-specific error message with RAISE_APPLICATION_ERROR.
 
02:26
If you execute a SELECT-INTO that does not identify any rows, the PL/SQL runtime engine raises: ORA-01403 and the error message (retrieved via SQLERRM or DBMS_UTILITY.FORMAT_ERROR_STACK) is simply "No data found". That may be exactly what you want your users to see. But there is a very good chance you'd like to offer something more informative, such as "An employee with that ID is not in the system." In this case, you can use RAISE_APPLICATION_ERROR, as in: CREATE OR REPLACE PACKAGE BODY employees_mgr IS FUNCTION onerow (employee_id_in IN hr.employees.employee_id%TYPE) RETURN hr.employees%ROWTYPE RESULT_CACHE IS l_employee hr.employees%ROWTYPE; BEGIN SELECT * INTO l_employee FROM hr.employees WHERE employee_id = employee_id_in; RETURN l_employee; EXCEPTION WHEN NO_DATA_FOUND THEN raise_application_error ( -20000, 'An employee with that ID is not in the system.'); END; END; Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
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: 450 Neri Neitzke
Oracle tutorial : Exception Handling In Oracle PL SQL
 
13:21
Oracle tutorial : Exception Handling In Oracle PL SQL pl sql exception no data found pl sql select no data found oracle trigger exception pl sql exception handling best practice CREATE OR REPLACE PROCEDURE ORA_EXCE_HANDLING IS MYQUERY VARCHAR2(100); STR_ID VARCHAR2(10); BEGIN MYQUERY:='SELECT ID FROM MYDEV.EMPLOYEE111 WHERE ID=''1'''; DBMS_OUTPUT.PUT_LINE('QUERY '||MYQUERY); BEGIN EXECUTE IMMEDIATE MYQUERY INTO STR_ID; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('EXCEPTION CAPTURE.'); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('OTHER EXCEPTION IS CAPTURE HERE :'||SQLERRM); END; DBMS_OUTPUT.PUT_LINE('EMPLOYEE ID '||STR_ID); END; #techquerypond https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 899 Tech Query Pond
Tutorial 37 : CURSOR Based Record Datatype
 
04:44
Hi Friends, Here we are learning about Cursor Based Record Datatype. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (Explicit Cursor) : https://youtu.be/vUMX9AnAOt8 Link (Record Datatype Introduction) : https://youtu.be/luVXGF1Bp_E Link (Table Based Record Datatype Example 1) : https://youtu.be/SS850dKNWvA Link (Table Based Record Datatype Example 2) : https://youtu.be/808lITrp3mQ Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding :)
Views: 105 YourSmartCode
SQL Cursors - Quick Guide to using Cursors in SQL
 
04:17
Just a quick guide to using Cursors in SQL Server. The code used can be found here: http://adf.ly/bIUIJ
Views: 556 CodeChannel
PLSQL 6 (%TYPE, %ROWTYPE, CURSORS)
 
59:18
ORACLE PL/SQL %TYPE , %ROWTYPE ATTRIBUTES AND CURSORS
CS3041: A PL/SQL Crash Course
 
05:36
This is a presentation recorded for module CS3041 in Trinity College Dublin. The links used in the presentation can be found below: Example of Use - PL/SQL: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html DML and DDL: http://www.coders-hub.com/2013/04/sql-statements-ddl-dml-dcl.html#.VktGAHbhDgA Querying Multiple Tables: http://www.techrepublic.com/article/sql-basics-query-multiple-tables/ Transactions: http://www.tutorialspoint.com/plsql/plsql_transactions.htm Trigger Commands: http://www.tutorialspoint.com/plsql/plsql_triggers.htm Flow Control: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html
Views: 283 Yasir Mohamed
PL/SQL: Cursors (Implicit)
 
08:28
In this tutorial, you'll learn what is a cursor and the types of cursors available in the pl/sql...
Views: 19948 radhikaravikumar
Trigger Commands and PL/SQL Resources
 
01:03
This video aims to provide a brief introduction to the resources team ACME found useful when researching Trigger Commands in SQL and PL/SQL. links: https://mariadb.com/kb/en/sql-99/24-sql-triggers/trigger/ http://www.codeproject.com/Articles/25600/Triggers-SQL-Server http://www.tutorialspoint.com/plsql/plsql_triggers.htm http://en.wikipedia.org/wiki/PL/SQL http://plsql-tutorial.com/
Views: 137 Charles Hebert
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 141499 BBarters
How to Fix Kali Linux Black Screen error
 
00:55
How to Install Kali Linux - https://youtu.be/eF1Im_Ggoqk Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 108582 Geeky Shows
PL/SQL Tutorial : EXECUTE IMMEDIATE with USING Clause
 
02:43
PL/SQL Tutorial : EXECUTE IMMEDIATE with USING Clause SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 134 TechLake
Tutorial 1 - Creating a basic form with Oracle Form Builder 10G
 
07:12
Creating a very simple form using Oracle Developer Suite 10G. Shows the basics of connecting to your database and using the data block wizard, as well as running and querying the form. PLEASE NOTE: This demonstration assumes that the viewer has a working knowledge of SQL and PL/SQL. Tutorial 2: Using radio buttons can be found at the following link: http://www.youtube.com/watch?v=X5L3rHU5TBY UPDATE: Just an update regarding this video. Many people have asked me why I do not use voice overs. I specifically created these videos so that the students I teach have access to additional material outside of class and our LMS. Because we are based in South Africa, where internet access is still a challenge and mobile data costs are high, one of the key goals when I made these tutorials were to keep them as small and bandwidth efficient as possible, thus the lack of voice overs. Never in my wildest dreams did I expect that the videos would become so popular outside of my small circle of students. Please let me know if you would like to see more videos, and if yes, which topics would you like to see covered?
Views: 246384 Ricardo da Rocha
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: 210952 kudvenkat
Cursors-4u tutorial
 
02:33
In this video i will show you how to download and select the cursor that you want with cursors 4 u!
Views: 6859 Jamison Bullard
How To Change & Use The Host key In VirtualBox on Windows10 Tutorial
 
03:45
How To Change & Use The Host key In VirtualBox on Windows10 Tutorial In this Windows 10 Tutorial I will be showing you how to change and use the host key in Oracle Virtual Box this is a easy to follow Windows Tutorial. The Host key by default in VitrualBox is the right cntrl button. NEW ComputerSluggish Plus Channel: https://www.youtube.com/channel/UCDGkYY98rV-0ZgOAkBpZFxA Donate Now! https://paypal.me/computersluggish (All Donations Are A Big Help At Making My Channel Grow.) #VirtualBox #Windows10 #Windows10Tutorials #ComputerSluggish
Cursor Property in CSS (Hindi)
 
02:51
Topics: Cursor Property in CSS Make sure you have basic knowledge of HTML before watching Cascading Style Sheet (CSS) Tutorials. You can find out our HTML Complete Video tutorials : http://goo.gl/O254f9 Feel free to share this video: CSS Complete Video Tutorial Playlist: https://goo.gl/1QNdiB Check Out Our Other Playlists: https://www.youtube.com/user/GeekyShow1/playlists SUBSCRIBE to Learn Programming Language ! http://goo.gl/glkZMr Learn more about subject: http://www.geekyshows.com/ __ If you found this video valuable, give it a like. If you know someone who needs to see it, share it. If you have questions ask below in comment section. Add it to a playlist if you want to watch it later. ___ T A L K W I T H M E ! Business Email: [email protected] Youtube Channel: https://www.youtube.com/c/geekyshow1 Facebook: https://www.facebook.com/GeekyShow Twitter: https://twitter.com/Geekyshow1 Google Plus: https://plus.google.com/+Geekyshowsgeek Website: http://www.geekyshows.com/ ___ Make sure you LIKE, SUBSCRIBE, COMMENT, and REQUEST A VIDEO! :) ___
Views: 1043 Geeky Shows
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►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/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ 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: 341261 Manish Sharma