Home
Search results “Begin end loop oracle”
Oracle tutorial : User Defined Exception in Oracle PL SQL
 
05:59
Oracle tutorial: User Defined Exception in Oracle PL SQL pl sql exception handling pl sql exception handling examples This video will show you how to raise user defined exceptions in oracle. Example: BEGIN IF condition THEN RAISE exception_name; END IF; EXCEPTION WHEN exception_name THEN statement; END; 1)We can defined exception to make your own exception. 2)This exception must be declare yourself and RAISE statement to raise explicitly. Declare exception : user_define_exception_name EXCEPTION; RAISE exception : RAISE user_define_exception_name; How to use : WHEN user_define_exception_name THEN //User Action lets see an example DECLARE exception1 EXCEPTION; g NUMBER; BEGIN FOR g IN (SELECT * FROM EMPLOYEE) LOOP IF g.ID = 7 THEN RAISE exception1; END IF; END LOOP; EXCEPTION WHEN exception1 THEN dbms_output.put_line(‘WE HAVE FOUND EMPLOYEE NUMBER 7’); END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 178 Tech Query Pond
Oracle PL/SQL - Procedures
 
10:41
Oracle PL/SQL - Procedures
Views: 126261 Chris Ostrowski
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: 129 Boby Siswanto
Oracle, Find Failed Queries
 
03:54
It is very difficult to find failed queries executed by Entity Framework. Use following plsql trigger to find quries CREATE TABLE QUERY_LOG ( ID NUMBER, ORA_ERR VARCHAR2(10), EXE_DATE DATE, QRY_LOG NCLOB) / CREATE SEQUENCE QUERY_LOG_ID NOCACHE / CREATE OR REPLACE TRIGGER Failed_To_Extend_Temp AFTER SERVERERROR ON DATABASE DECLARE l_sql_text ora_name_list_t; l_n NUMBER; t1 NCLOB; BEGIN --IF (is_servererror(942) ) THEN l_n := ora_sql_txt(l_sql_text ); FOR I IN 1 .. l_n LOOP t1 := t1||l_sql_text(i); END LOOP; INSERT INTO QUERY_LOG (Id , Ora_Err , EXE_DATE , QRY_LOG) VALUES (QUERY_LOG_ID.Nextval, ora_server_error(1), Sysdate,t1 ); --END IF; END; /
Views: 47 Nivas Shelke
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: 50338 Manish Sharma
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: 17079 radhikaravikumar
SQL Prompt Tips - Begin End Highlighting
 
01:09
See how SQL Prompt v6.4 and later highlight your code.
Views: 593 Steve Jones
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►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: 94826 Manish Sharma
59/125 Oracle PLSQL: Working with Packages / Array Example
 
02:32
Learn Oracle PLSQL EXAM 1Z0-144 -------------------------------------------- --using pl/sql tables in packages create or replace package emp_pkg is type emp_table_type is table of employees%rowtype index by binary_integer; procedure get_employees(p_emps out emp_table_type ); end; ------------------------------- create or replace package body emp_pkg is procedure get_employees(p_emps out emp_table_type ) is begin for emp_record in (select * from employees) loop p_emps( emp_record.employee_id):=emp_record; end loop; end; end; ----------------------------------- declare v_employees emp_pkg.emp_table_type; begin emp_pkg.get_employees(v_employees); dbms_output.put_line(v_employees(101).first_name); end;
Views: 549 khaled alkhudari
LAB8 Mo
 
24:02
--declare --v_emp_email varchar2(10); --begin --select email --into v_emp_email --from employees --where employee_id = 207; --dbms_output.put_line('the email is '||v_emp_email); --exception --when no_data_found then --dbms_output.put_line (' no data found.'); --end; --declare --v_emp_email varchar2(10); --e_select_excep exception; --pragma exception_init(e_select_excep, -01402); --begin select email --into v_emp_email --from employees --where employee_id = 207; --exception --when e_select_excep then --dbms_output.put_line('select failed'); --when others then --dbms_output.put_line(sqlerrm); --end; --declare --v_reg_id number := 5; --e_invalid_region exception; --begin --delete from regions --where region_id = v_reg_id; --if sql % notfound then --raise e_invalid_region; --end if; --exception --dbms_output.put_line('NO delete region id.'); --end; declare e_integrity exception; pragma exception_init (e_integrity, -2292); v_name varchar2(4) := 'four' ; v_regid integer := 5; cursor reg_cursor is select region_id from regions; begin for c_record in reg_cursor loop declare e_no_rows exception; begin dbms_output.put_line(c_record.region_id); update regions set region_name = v_name where region_id = v_regid; if sql%notfound then raise e_no_rows; end if; exception when e_no_rows then dbms_output.put_line('ERROR Sir'); end; end loop; exception when e_integrity then null; end;
Views: 20 Noonim Zuza
SQL: Check Constraint
 
05:11
In this tutorial, you'll learn how to make use of check constraint. 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: 11298 radhikaravikumar
81/125 Oracle PLSQL: Design consideration  / Bulk Binding 2
 
14:03
Learn Oracle PLSQL EXAM 1Z0-144 Bulk Binding Bulk collect begin dbms_output.put_line(sqlerrm (-12899)); end; ------------------------------------------------------------- -------------------------------------------------------------- drop table ename; create table ename as select distinct first_name from employees; select first_name from ename; declare type ename_t is table of varchar2(100); ename_table ename_t:=ename_t(); c number:=0; errors number; begin for i in (select * from ename ) loop c:=c+1; ename_table.extend; ename_table(c):=i.first_name; end loop; forall i in ename_table.first.. ename_table.last save exceptions update ename set first_name=first_name||' to be added:)' --14 char where first_name=ename_table(i); exception when others then errors := sql%bulk_exceptions.count; dbms_output.put_line ('The total number of errors occured are '|| errors); for j in 1..errors loop dbms_output.put_line ('The error iteration is ' || sql%bulk_exceptions(j).error_index || ' and the error code is ' || sql%bulk_exceptions(j).error_code || ' and the error message is ' || sqlerrm ( -sql%bulk_exceptions(j).error_code) ); end loop; end; select * from ename ----------------------------- drop table ename; create table ename as select distinct first_name from employees; select first_name from ename; declare type ename_t is table of varchar2(100); ename_table ename_t:=ename_t(); c number:=0; errors number; begin /* for i in (select * from ename ) loop c:=c+1; ename_table.extend; ename_table(c):=i.first_name; end loop; */ select first_name bulk collect into ename_table from ename; forall i in ename_table.first.. ename_table.last save exceptions update ename set first_name=first_name||' to be added:)' --14 char where first_name=ename_table(i); exception when others then errors := sql%bulk_exceptions.count; dbms_output.put_line ('The total number of errors occured are '|| errors); for j in 1..errors loop dbms_output.put_line ('The error iteration is ' || sql%bulk_exceptions(j).error_index || ' and the error code is ' || sql%bulk_exceptions(j).error_code || ' and the error message is ' || sqlerrm ( -sql%bulk_exceptions(j).error_code) ); end loop; end; select * from ename
Views: 419 khaled alkhudari
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: 52776 Manish Sharma
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . 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: 15321 radhikaravikumar
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: 35209 Manish Sharma
78/125 Oracle PLSQL: Design consideration  / NOCOPY Hint 2
 
15:40
Learn Oracle PLSQL EXAM 1Z0-144 ------------------------------------------------------ create or replace package nocopy_test is type number_t is table of varchar2(32767) index by binary_integer; procedure pass_by_vale(nums in out number_t); procedure pass_by_refernce(nums in out nocopy number_t); procedure init; end; ------------------------------------------------------------------------- create or replace package body nocopy_test is l_numbers number_t; c_array_size number:=1000000; c_it number:=20; procedure pass_by_vale(nums in out number_t) is indx pls_integer; begin indx:=nums.count; end; procedure pass_by_refernce(nums in out nocopy number_t) is indx pls_integer; begin indx:=nums.count; end; procedure init is begin l_numbers.delete; for i in 1..c_array_size loop l_numbers(i):='s'||i; end loop; dbms_output.put_line('start '||to_char(sysdate,'hh:mi:ss') ); for i in 1..1000 loop pass_by_vale(l_numbers); end loop; dbms_output.put_line('end '||to_char(sysdate,'hh:mi:ss') ); dbms_output.put_line('start '||to_char(sysdate,'hh:mi:ss')); for i in 1..1000 loop pass_by_refernce(l_numbers); end loop; dbms_output.put_line('end '||to_char(sysdate,'hh:mi:ss')); end; end; ----------------------------------------- begin nocopy_test.init; end;
Views: 382 khaled alkhudari
Timmy Trumpet - Oracle (Official Music Video)
 
03:06
Timmy Trumpet - Oracle is OUT NOW! Like this track? Download on Beatport or add it to your favourite Spotify/Apple Music playlist by clicking HERE: https://Timmy-Trumpet.lnk.to/Oracle!YT Join our Spinnin' Records Top 100 Playlist ► https://spinninrecords.lnk.to/top100!YT Timmy Trumpet presents his Oracle! And it’s a tune you want to listen to, featuring hypnotizing vocals and a mesmerizing beat, taking you to a higher state of mind in no-time. With lively chords and an ecstatic drop it’s bound to blow your mind, taking the characteristic Timmy Trumpet to new heights! Follow Timmy Trumpet: http://www.timmytrumpet.com https://www.facebook.com/timmytrumpet https://twitter.com/timmytrumpet --- The Spinnin’ Records YouTube channel is the home for all music videos of the world’s leading dance record label! We feature the latest music videos by Spinnin’ artists like Oliver Heldens, Sam Feldt, KSHMR, Ummet Ozcan, Blasterjaxx, Merk & Kremont, Timmy Trumpet, Tujamo, Alok, Curbi, Mike Williams, Lucas & Steve and many, many more! Expect daily uploads of official music videos, lyric videos and artwork videos across genres like dance, house, electro house, future house, deep house, big room and trap. Make sure to subscribe to Spinnin' Records: http://bit.do/spinnintv ..and turn on notifications to stay updated with all new uploads!🔔 Follow Spinnin’ Records: https://open.spotify.com/user/spinninrecordsofficial https://soundcloud.com/spinninrecords https://facebook.com/SpinninRecords https://instagram.com/spinninrecords https://twitter.com/SpinninRecords https://spinninrecords.com #TimmyTrumpet #SpinninRecords #Spinnin
Views: 64652831 Spinnin' Records
Introduction to Oracle: PL-SQL - WHILE Statement
 
03:55
Introduction to Oracle: PL-SQL - WHILE Statement
Views: 91 David Hays
PL/SQL: Ref Cursors
 
09:28
In this tutorial, you'll learn what is ref cursors. 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: 26266 radhikaravikumar
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: 119604 BBarters
PL SQL 2   Databases and transactional applications
 
06:27
https://drive.google.com/file/d/0BxYoN5rLDBaRMUJuMWs0c1ZrbVU/edit?usp=sharing Course Objectives Variable declaration (again) operators Conversions of data types Nested blocks and variable scope Control Structures Example 1 DECLARE hours_worked INTEGER := 40; employee_count INTEGER := 0; pi CONSTANT REAL := 3.14159; radius REAL := 1; area REAL := (pi * radius**2); BEGIN NULL; END; --------------------------------- Exampl 2 SET SERVEROUTPUT ON DECLARE counter INTEGER; -- initial value is NULL by default BEGIN counter := counter + 1; -- NULL + 1 is still NULL IF counter IS NULL THEN DBMS_OUTPUT.PUT_LINE('counter is NULL'); END IF; END; --------------------------------- Example 3 DECLARE acct_id INTEGER(4) NOT NULL := 9999; a NATURALN := 9999; b POSITIVEN := 9999; c SIMPLE_INTEGER := 9999; BEGIN NULL; END; --------------------------------- Example 4 DECLARE null_string VARCHAR2(80) := TO_CHAR(''); address VARCHAR2(80); zip_code VARCHAR2(80) := SUBSTR(address,25,0); name VARCHAR2(80); valid BOOLEAN := (name != ''); BEGIN DBMS_OUTPUT.PUT_LINE('null_string is'||null_string); IF valid is null THEN DBMS_OUTPUT.PUT_LINE('name is NULL, not ""'); END IF; END; --------------------------------- Example 5 SET SERVEROUTPUT ON DECLARE name VARCHAR(25) NOT NULL := 'Smith'; surname name%TYPE := 'Jones'; BEGIN DBMS_OUTPUT.PUT_LINE('name=' || name); DBMS_OUTPUT.PUT_LINE('surname=' || surname); END; ---------------------------------- Example 6 BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&sv_day'); DBMS_OUTPUT.PUT_LINE ('Tomorrow will be '||'&sv_day'); END; Example 7 ---------------------------------- BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&&sv_day'); DBMS_OUTPUT.PUT_LINE ('The same day is '||'&sv_day'); END; ----------------------------------- Example 8 DECLARE a INTEGER := 2**2*3**2; BEGIN DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a)); END; ---------------------------------- Example 9 SET SERVEROUTPUT ON -- outer_block DECLARE v_test NUMBER := 123; BEGIN DBMS_OUTPUT.PUT_LINE('Outer Block, v_test: '||v_test); -- inner_block DECLARE v_test NUMBER := 456; BEGIN DBMS_OUTPUT.PUT_LINE('Inner Block, v_test: '||v_test); DBMS_OUTPUT.PUT_LINE('In inner Block, ?outer_block.v_test is: '|| outer_block.v_test); END inner_block; ---------------------------------- Example 10 DECLARE v_num NUMBER := &sv_user_num; BEGIN IF MOD(v_num,2) = 0 THEN DBMS_OUTPUT.PUT_LINE (v_num|| ' is even number'); ELSE DBMS_OUTPUT.PUT_LINE (v_num||' is odd number'); END IF; DBMS_OUTPUT.PUT_LINE ('Done'); END; ---------------------------------- Example 11 SET SERVEROUTPUT ON DECLARE x NUMBER := 5; y NUMBER := NULL; BEGIN IF x != y THEN DBMS_OUTPUT.PUT_LINE('x != y'); ELSIF x = y THEN DBMS_OUTPUT.PUT_LINE('x = y'); ELSE DBMS_OUTPUT.PUT_LINE('impossible to define if = or not'); END IF; END; ---------------------------------- Example 12 SET SERVEROUTPUT ON DECLARE a NUMBER := NULL; b NUMBER := NULL; BEGIN IF a = b THEN DBMS_OUTPUT.PUT_LINE('a = b'); ELSIF a != b THEN DBMS_OUTPUT.PUT_LINE('a != b'); ELSE DBMS_OUTPUT.PUT_LINE('umm, it is not known'); END IF; END; ---------------------------------- Example 13 DECLARE x INTEGER := 2; y INTEGER := 5; high INTEGER; BEGIN IF (x mayor y) THEN high := x; ELSE high := y; END IF; IF NOT (x menor y) THEN high := y; ELSE high := x; END IF; DBMS_OUTPUT.PUT_LINE('high is: '||to_char(high)); END; ---------------------------------- Example 14 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE grade WHEN NULL THEN 'No grade assigned' WHEN 'A' THEN 'Excellent' WHEN 'B' THEN 'Very Good' WHEN 'C' THEN 'Good' WHEN 'D' THEN 'Fair' WHEN 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade '||grade||' is '||appraisal); END; ---------------------------------- Example 15 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE WHEN grade IS NULL THEN 'No grade assigned' WHEN grade = 'A' THEN 'Excellent' WHEN grade = 'B' THEN 'Very Good' WHEN grade = 'C' THEN 'Good' WHEN grade = 'D' THEN 'Fair' WHEN grade = 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade ' || grade || ' is ' || appraisal); END;
Views: 204 Fdo Luis
PL/SQL tutorial 5: PL/SQL Constants in Oracle Database  By Manish Sharma RebellionRider.com
 
04:34
Constant is a user defined identifier whose value remains unchanged throughout the program. Watch and learn proper way of initializing and declaring a constant in PL/SQL by Manish Sharma in PL/SQL Tutorial 5 for beginners. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/constants-in-pl-sql Previous Tutorial ► Anchored Datatype (%type) https://youtu.be/Zt0vlmTqhP4 ------------------------------------------------------------------------- ►►►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: 73426 Manish Sharma
PROJECT ZORGO IS WATCHING Official Music Video
 
03:02
WE ARE PROJECT ZORGO YOU HAVE BEEN HACKED! Official YouTube Hacker Music Video Listen all you fake celebrities  All you vloggers and YouTube personalities   Project Zorgo is watching everybody And we’re going to delete you one by one  Starting with Chad and Vy We’re going to take back that lie detector guy  And make him work for free! We’re here to turn YouTube  Into Project Zorgo TV  So when you find an abandoned safe or a Tesla on the street  And when you sense the sky is full of drones - filming while you sleep  You’ll know…  Project Zorgo is the future YouTubers will never last  The Doomsday date has been reset  And we’ll all remove off our masks!  And I’ll be Zorgo, you’ll be Zorgo  We’ll be Project Zorgo  I am Zorgo, you are Zorgo - WE ARE PROJECT ZORGO! Listen up youtube celebrities  Pranksters, reality stars with your funny parodies  Project Zorgo watches you, WATCHES EVERYTHING!  And we’ve come to delete Kawaii Kunicorn    The Sharer Family and Papa Jake  Yes something big is happening in Utah  Make no mistake!  We cracked the code - decrypted doomsday  Kept the password on a cassette tape  So when you see an abandoned safe or a Tesla on the street  When you sense the sky is full of drones - filming while you sleep... You’ll know… Project Zorgo is your future, YouTubers are fading fast The Doomsday date has been reset  And we’ll all remove our masks!  And I’ll be Zorgo, you’ll be Zorgo  We’ll be Project Zorgo  Yes I’ll be Zorgo, you’ll be Zorgo  We’ll be Project Zorgo  I am Zorgo, you are Zorgo - WE ARE PROJECT ZORGO! If you would like to join our team and help us stop YouTubers (because they are not REAL celebrities), please gather information and clues on the 'TARGET Channels' and leave us comments with any helpful data you find. Our current TARGET Channels are: Chad Wild Clay https://www.youtube.com/user/chadwildclay Vy Qwaint https://www.youtube.com/user/VyQwaint Stephen Sharer https://www.youtube.com/user/spstricky175 Lizzy Sharer https://www.youtube.com/channel/UCXOSzGyN3EPZfKE2hujeIYA Carter Sharer https://www.youtube.com/user/cjsharer Papa Jake https://www.youtube.com/user/Team0Epiphany Rebecca Zamolo https://www.youtube.com/user/rebeccazamolo1 Matt & Rebecca https://www.youtube.com/channel/UCvo9oZCTg_UaTQbhyXkXX3w Marlin https://www.youtube.com/user/marmarchanmar Kawaii Kunicorn https://www.youtube.com/channel/UC58otONbfRjWcYjlJvHaYfw Carl & Jinger Family https://www.youtube.com/channel/UCneC60ueLDbk6NVzMHUUhKg Jingerrific https://www.youtube.com/channel/UCzwlnJ_NUsmin7DtPRDNCHg Guava Juice https://www.youtube.com/user/aynakoitsroi Lucas and Marcus https://www.youtube.com/user/TwiNboTzVids
Views: 2117752 Kawaii Kunicorn
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: 30876 Jeff Smith
65 - Oracle Introduction to PL/SQL تعليم أوراكل
 
13:48
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
72- Oracle PL SQL - Cursors - Implicit Cursors تعليم أوراكل
 
15:26
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL Cursors - Implicit Cursors in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
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: 25380 Manish Sharma
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: 549 Fdo Luis
PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
 
05:22
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/select-into-statement-pl-sql Previous Tutorial ► 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/ 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: 112687 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: 14 Cida Luna
Shawn Mendes - There's Nothing Holdin' Me Back
 
03:58
Shawn Mendes’ new single “There’s Nothing Holdin’ Me Back” is out now. Get it off Illuminate: iTunes: https://lnk.to/IlluminateDeluxeDL/itunes Apple Music: https://lnk.to/IlluminateDeluxeDL/applemusic Amazon: https://lnk.to/IlluminateDeluxeDL/amazonmp3 Google Play: https://lnk.to/IlluminateDeluxeDL/google-play Spotify: https://lnk.to/IlluminateDeluxeDL/spotify Linkfire: https://lnk.to/IlluminateDeluxe Illuminate World Tour Dates 2017 Tickets on-sale now! http://www.shawnmendesofficial.com/to... North America 7/6 Portland, OR - MODA Center 7/8 Vancouver, BC - Rogers Arena 7/9 Seattle, WA – KeyArena at Seattle Center 7/11 Oakland, CA - Oracle Arena 7/12 Los Angeles, CA - Staples Center 7/14 San Diego, CA - Valley View Casino Center 7/15 Glendale, AZ - Gila River Arena 7/17 Denver, CO - Pepsi Center 7/19 Dallas, TX - American Airlines Center 7/21 San Antonio, TX - AT&T Center 7/22 Houston, TX - Toyota Center 7/25 Tampa, FL - Amalie Arena 7/26 Miami, FL - AmericanAirlines Arena 7/28 Orlando, FL - Amway Center 7/29 Duluth, GA - Infinite Energy Arena 7/31 Nashville, TN - Bridgestone Arena 8/2 Cleveland, OH – Quicken Loans Arena 8/3 Chicago, IL - Allstate Arena 8/5 Omaha, NE - CenturyLink Center Omaha 8/6 St. Paul, MN - EXCEL Energy Center 8/14 Montreal, QC - Centre Bell 8/19 Washington DC - Verizon Arena 8/20 Pittsburgh, PA – CONSOL Energy Center 8/23 Boston, MA - TD Garden Music video by Shawn Mendes performing There's Nothing Holdin' Me Back. (C) 2017 Island Records, a division of UMG Recordings, Inc. http://vevo.ly/NI6a9c
Views: 675757264 ShawnMendesVEVO
All About Binds
 
06:16
TO USE OR PRINT this presentation click : http://videosliders.com/r/184 ============================================================== All About Binds Thomas Kyte ,It’s All About Binds ,Agenda Performance Is it just about sharing SQL (or is this really a parsing talk in disguise) Scalability Security Do I always want to bind? What is bind variable peeking? Is it good or evil in disguise or a bit of both? I’m binding, but it isn’t sharing – what’s up with that? So the developers don't bind is cursor_sharing = force/similar appropriate system wide? What is the real difference between cursor_sharing = force/similar and which should we use under what circumstances? ,Performance What is involved in all Parses The “conventional” parse - syntax Semantic check What about a hard parse Optimization (can you spell C.P.U…) Row Source Generation And then we can finally execute it Soft Parse is lighter weight But it is called a “shared” pool, not “your” pool Shared data structures have to be protected Optimization can be avoided Row Source Generation can be avoided Bind01.sql ,Performance Wonder if it might affect memory utilization? Strange that count(*) is so low for that first query isn’t it. Unfortunate that sum(sharable_mem) is so high (and remember, it really is 10 times that amount) Bind02.sql ,Scalability But it runs fast enough and I’ll buy more memory Does it really? Run bind03.sql [email protected]> select 11/10000 from dual; 11/10000 ---------- .0011 ,Latch Algorithm Loop for I in 1 .. 1 loop try to get latch if got latch, return if I = 1 then misses=misses+1 end loop INCREMENT WAIT COUNT sleep Add WAIT TIME End loop; ,More multi-user USERS NOBIND_CPU PARSE_MANY_CPU PARSE_ONCE_CPU ------- ---------- -------------- -------------- 1.00 .27 .07 .03 2.00 .72 .21 .09 3.00 1.46 .38 .13 4.00 2.59 .67 .27 5.00 3.20 .85 .34 6.00 4.20 1.01 .40 7.00 4.79 1.20 .51 8.00 5.74 1.44 .53 9.00 6.27 1.60 .64 10.00 7.16 1.76 .72 ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / begin set_udump('C:\ORA4\admin\ora4\udump2'' scope=memory utl_file_dir=''*'' scope=spfile user_dump_dest=''C:\ORA4\admin\ora4\udump2'); end; ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin if ( p_udump NOT LIKE '%=%' ) then execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; else raise_application_error(-20000,'Sorry, but for safety reasons this procedure does not allow "=" in the parameter value'); end if; end; ,Do I always want to bind? Always say “Never say Never” Never say “Always” You do not want to Over Bind Always Bind Why…. ,Do I always want to bind? Over Binding Compulsive disorder to eradicate all literals in SQL Brought on by taking good advice to an illogical extreme Do we need to bind those? Might it be a bad thing to bind those? Begin for x in ( select object_name from user_objects where object_type in ( ‘TABLE’, ‘INDEX’ )) loop … ,Do I always want to bind? Always Binding Data warehouse – no way. When you run queries per second, yes. When you run queries that take seconds, maybe, maybe no. Conside
Views: 55 slide show me
Oracle Database - Capturando erros da aplicação no banco de dados
 
08:05
Segue abaixo o script: CREATE TABLE database_errors ( DT DATE, USERNAME VARCHAR2 (30), IP VARCHAR2 (15), CLIENT_INFO VARCHAR2 (64), CLIENT_IDENTIFIER VARCHAR2 (512), ACTION_INFO VARCHAR2 (512), INSTANCE_NUMBER NUMBER (2), SESSION_SID NUMBER (10), OS_USER VARCHAR2 (15), MSG VARCHAR2 (4000), STMT CLOB ); CREATE OR REPLACE TRIGGER catch_errors AFTER SERVERERROR ON DATABASE DECLARE sql_text ora_name_list_t; msg_ VARCHAR2 (32767) := NULL; stmt_ VARCHAR2 (32767) := NULL; BEGIN FOR DEPTH IN 1 .. ora_server_error_depth LOOP msg_ := msg_ || ora_server_error_msg (DEPTH); END LOOP; FOR i IN 1 .. ora_sql_txt (sql_text) LOOP stmt_ := stmt_ || sql_text (i); END LOOP; IF msg_ NOT LIKE 'ORA-25228%' THEN INSERT INTO database_errors (DT, USERNAME, IP, CLIENT_INFO, CLIENT_IDENTIFIER, ACTION_INFO, INSTANCE_NUMBER, SESSION_SID, OS_USER, MSG, STMT) VALUES (SYSDATE, ora_login_user, SYS_CONTEXT ('USERENV', 'IP_ADDRESS'), SYS_CONTEXT ('USERENV', 'CLIENT_INFO'), SYS_CONTEXT ('USERENV', 'CLIENT_IDENTIFIER'), SYS_CONTEXT ('USERENV', 'ACTION'), SYS_CONTEXT ('USERENV', 'INSTANCE'), SYS_CONTEXT ('USERENV', 'SID'), SYS_CONTEXT ('USERENV', 'OS_USER'), substr(msg_,1,4000), stmt_); END IF; END; / Fonte (adaptado): http://www.adp-gmbh.ch/ora/sql/trigger/servererror.html
Views: 176 Datamanager TI
PL SQL 4   Databases and transactional applications
 
08:00
https://drive.google.com/file/d/0BxYoN5rLDBaRTjhOWWZsMjdPejQ/edit?usp=sharing Course Objectives Exceptions create table enrollment (student_id number not null, course varchar2(10)); insert into enrollment values(1,'A1'); insert into enrollment values(2,'A1') insert into enrollment values(1,'B3'); create table instructor (instructor_id number not null, first_name varchar2(20) not null, last_name varchar2(20) not null, course varchar2(10)); insert into instructor values (10,'camille','salinesi','A1'); insert into instructor values (10,'camille','salinesi','B12'); insert into instructor values (15,'Raul','Mazo','A1'); Example 1 DECLARE v_num1 INTEGER := &sv_num1; v_num2 INTEGER := &sv_num2; v_result NUMBER; BEGIN v_result := v_num1 / v_num2; DBMS_OUTPUT.PUT_LINE ('v_result: '||v_result); EXCEPTION WHEN ZERO_DIVIDE THEN DBMS_OUTPUT.PUT_LINE ('A number cannot be divided by zero.'); END; ----------------------------- Example 2 SET SERVEROUTPUT ON; DECLARE v_num NUMBER := &sv_num; BEGIN DBMS_OUTPUT.PUT_LINE ('Square root of '||v_num||' is '||SQRT(v_num)); EXCEPTION WHEN VALUE_ERROR THEN DBMS_OUTPUT.PUT_LINE ('An error has occurred'); END; ----------------------------- example 3 SET SERVEROUTPUT ON; DECLARE v_num NUMBER := &sv_num; BEGIN IF v_num mayor= 0 THEN DBMS_OUTPUT.PUT_LINE ('Square root of '||v_num ||'is '||SQRT(v_num)); ELSE DBMS_OUTPUT.PUT_LINE ('A number cannot be negative'); END IF; END; ---------------------------- Example 4 DECLARE v_student_name VARCHAR2(50); BEGIN SELECT first_name||' '||last_name INTO v_student_name FROM student WHERE student_id = 101; DBMS_OUTPUT.PUT_LINE ('Student name is '||v_student_name); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('There is no such student'); END; -------------------------- Example 5 DECLARE v_student_id NUMBER := &sv_student_id; v_enrolled VARCHAR2(3) := 'NO'; BEGIN DBMS_OUTPUT.PUT_LINE ('Check if the student is enrolled'); SELECT 'YES' INTO v_enrolled FROM enrollment WHERE student_id = v_student_id; DBMS_OUTPUT.PUT_LINE ('The student is enrolled into one course'); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('The student is not enrolled'); WHEN TOO_MANY_ROWS THEN DBMS_OUTPUT.PUT_LINE ('The student is enrolled in too many courses'); END; -------------------------- Example 5 DECLARE v_instructor_id NUMBER := &sv_instructor_id; v_instructor_name VARCHAR2(50); BEGIN SELECT first_name||' '||last_name INTO v_instructor_name FROM instructor WHERE instructor_id = v_instructor_id; DBMS_OUTPUT.PUT_LINE ('Instructor name is '||v_instructor_name); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('An error has occurred'); END; -------------------------- Example 6 DECLARE v_student_id student.student_id%type := &sv_student_id; v_total_courses NUMBER; e_invalid_id EXCEPTION; BEGIN IF v_student_id menor 0 THEN RAISE e_invalid_id; ELSE SELECT COUNT(*) INTO v_total_courses FROM enrollment WHERE student_id = v_student_id; DBMS_OUTPUT.PUT_LINE ('The student is registered for '||v_total_courses||' courses'); END IF; DBMS_OUTPUT.PUT_LINE ('No exception has been raised'); EXCEPTION WHEN e_invalid_id THEN DBMS_OUTPUT.PUT_LINE ('An id cannot be negative'); END; ------------------------ Example 7 set serveroutput on DECLARE e_test_exception EXCEPTION; BEGIN DBMS_OUTPUT.PUT_LINE ('Exception has not been raised'); RAISE e_test_exception; DBMS_OUTPUT.PUT_LINE ('Exception has been raised'); EXCEPTION WHEN e_test_exception THEN DBMS_OUTPUT.PUT_LINE ('An error has occurred'); END; ------------------------ Example 8 set serveroutput on; DECLARE v_zip VARCHAR2(5) := '&sv_zip'; v_city VARCHAR2(15); v_state CHAR(2); v_err_code NUMBER; v_err_msg VARCHAR2(200); BEGIN SELECT city, state INTO v_city, v_state FROM zipcode WHERE zip = v_zip; DBMS_OUTPUT.PUT_LINE (v_city||', '||v_state); EXCEPTION WHEN OTHERS THEN v_err_code := SQLCODE; v_err_msg := SUBSTR(SQLERRM, 1, 200); DBMS_OUTPUT.PUT_LINE ('Error code: '||v_err_code); DBMS_OUTPUT.PUT_LINE ('Error message: '||v_err_msg); END;
Views: 228 Fdo Luis
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: 87759 Manish Sharma
How to Put a String on a Yoyo and Adjust it for Play
 
07:01
Learn the right way to put new yoyo string onto a yoyo, how to adjust the string length for your height, properly retie the slipknot, and put it onto your finger. http://yoyotricks.com/ Get new yoyo string for your yoyo here: https://yoyotricks.com/shop/cat/yoyo-store/yoyo-string/
Views: 207827 yotricks
Turing & The Halting Problem - Computerphile
 
06:14
Alan Turing almost accidentally created the blueprint for the modern day digital computer. Here Mark Jago takes us through The Halting Problem. Turing Machines Explained: https://youtu.be/dNRDvLACg5Q Busy Beaver: https://youtu.be/CE8UhcyJS0I VR Simulator: http://youtu.be/Lm0lA0enPSk What on Earth is Recursion?: http://youtu.be/Mv9NEXX1VHc Thanks to Assistant Professor Mark Jago of the University of Nottingham. http://www.facebook.com/computerphile https://twitter.com/computer_phile This video was filmed and edited by Sean Riley. Computer Science at the University of Nottingham: http://bit.ly/nottscomputer Computerphile is a sister project to Brady Haran's Numberphile. See the full list of Brady's video projects at: http://bit.ly/bradychannels
Views: 473569 Computerphile
Rae Sremmurd - Come Get Her (Explicit)
 
04:37
“SremmLife” available now! iTunes: http://smarturl.it/SremmLife Google Play: http://smarturl.it/SremmLifeGP Amazon: http://smarturl.it/SremmLifeAmz http://raesremmurd.com http://twitter.com/raesremmurd http://instagram.com/raesremmurd http://facebook.com/raesremmurd http://vevo.ly/oenrK5
Views: 71736360 RaeSremmurdVEVO
Oracle Certified Associate Exam: Identifying the Valid Targets of the Enhanced for Loop
 
03:11
http://www.pearsonitcertification.com/store/oracle-certified-associate-java-se-7-programmer-exam-9780789753670 Identifying the Valid Targets of the Enhanced for Loop is an excerpt from, "Oracle Certified Associate, Java SE 7 Programmer Exam (1Z0 803)" Complete Video Course. Oracle Certified Associate, Java SE 7 Programmer Exam Complete Video Course is a comprehensive training course designed to help you master the Java Certified Associate exam. The course brings the Java Certified Associate exam topics to life through the use of real-world live instruction, demonstrations, and animations, so these foundational Java programming topics are easy and fun to learn. Simon Roberts—a leading Java instructor, trainer, book author and video trainer, and creator of the original Sun Certified Programmer, Developer, and Architect certifications for Sun Microsystems—will walk you through each topic covered in the exam, so you have a full understanding of the material. He begins with an introduction to the Oracle Certification program and also discusses preparation and test-taking strategies, so you can begin your training confidently. Simon then dives into the exam topics, covering all objectives in the Associate exam using a variety of video presentation styles, including live whiteboarding, code demonstrations, and dynamic KeyNote presentations. The course also includes dynamic interactive exercises and quizzes, so you can test your knowledge at the end of each section of the course. Skill Level Beginning to Intermediate Who Should Take This Course The primary audience includes candidates for the Oracle Certified Java SE 7 Associate Exam; however, anyone interested in building a basic competence in the Java programming language will benefit from using this course.
11G features
 
11:48
11G features / Drop Table Test; / 1) Invisible Index / Create Table Test (A Number, B Varchar2(20) ); / Begin For I In 1..100000 loop Insert Into Test Values(I,'test'||I); End Loop; end; / explain plan for Select * From Test where b='test1850'; / Select * From Table(Dbms_Xplan.Display()); / Create Index In_test On Test(b) visible; / Alter Index In_test Invisible; / Alter Index In_test Visible; / Select * From User_Indexes Where Table_Name='TEST'; / ===================== 2) Sql Result Cache / 1. 1st Time It Will Execute The Query From Db 2. After That If We Execute The Same Query, It Wont Execute The Query Again In Db. It Will Fetch The Result From This Cache Memory. ===================== 3) Read only table: / Drop Table Test1; / Create Table Test1 ( A Number, B Number, C Varchar2(20) ); / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / Alter Table Test1 read only; / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / Alter Table Test1 Read write; / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / =========================== 4) Virtual Column; ====== / Drop Table Hist_Student; / CREATE TABLE HIST_STUDENT( ST_MARKS NUMBER, St_Max_Marks Number, St_Perc Number As (round(St_Marks/St_Max_Marks)*100), sum_marks number as (st_marks+st_max_marks) ); / Insert Into Hist_Student (St_Marks,St_Max_Marks) Values(93,150); Insert Into Hist_Student (St_Marks,St_Max_Marks) Values(85,100); / Select * From Hist_Student; / ====================== 5)Listagg / Syntax: / LISTAGG - LISTAGG (measure_expr [, 'delimiter_expr']) WITHIN GROUP (ORDER By Clause) [Over Partition Byclause] / Select Department_Id, Listagg( first_Name,',') Within Group(Order By Salary) Employees From Employees group by department_id; ====================== 6) Sequence Usage / DECLARE L_ID NUMBER; BEGIN L_ID:= TEST_SEQ.NEXTVAL; End; / 7) Regexp_Count / WITH C AS (SELECT ‘Sachin Tendulkar’ STARS FROM DUAL UNION ALL Select ‘virender Sehwag’ Stars From Dual Union All SELECT ‘Gautam Gambhir’ STA`RS FROM DUAL UNION ALL SELECT ‘MS Dhoni’ STARS FROM DUAL UNION ALL SELECT ‘Yuvraj Singh’ STARS FROM DUAL) SELECT STARS, REGEXP_COUNT(STARS, ‘s’, 1, ‘i’) S FROM C; STARS S --------- -- Sachin Tendulkar 1 Virender Sehwag 1 Gautam Gambhir 0 MS Dhoni 1 Yuvraj Singh 1
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: 68940 WiseOwlTutorials
Creating a database, table, and inserting - SQLite3 with Python 3 part 1
 
10:59
Welcome to an SQLite mini-series! SQLite, as the name suggests, is a lite version of an SQL database. SQLite3 comes as a part of the Python 3 standard library. Databases offer, typically, a superior method of high-volume data input and output over a typical file such as a text file. SQLite is a "light" version that works based on SQL syntax. SQL is a programming language in itself, but is a very popular database language. Many websites use MySQL, for example. SQLite truly shines because it is extremely lightweight. Setting up an SQLite database is nearly instant, there is no server to set up, no users to define, and no permissions to concern yourself with. For this reason, it is often used as a developmental and protyping database, but it can and is used in production. The main issue with SQLite is that it winds up being much like any other flat-file, so high volume input/output, especially with simultaneous queries, can be problematic and slow. You may then ask, what really is the difference between a typical file and sqlite. First, SQLite will let you structure your data as a database, which can easily be queried, so you get that functionality both with adding new content and calling upon it later. Each table would likely need its own file if you were doing plain files, and SQLite is all in one. SQLite is also going to be buffering your data. A flat file will require a full load before you can start querying the full dataset, SQLite files don't work that way. Finally, edits do not require the entire file to be re-saved, it's just that part of the file. This improves performance significantly. Alright great, let's dive into some SQLite. https://pythonprogramming.net/sql-database-python-part-1-inserting-database/ Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo https://pythonprogramming.net https://twitter.com/sentdex https://www.facebook.com/pythonprogramming.net/ https://plus.google.com/+sentdex
Views: 204223 sentdex
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training
 
26:14
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com Oracle 11g – SQL & PL/SQL The Oracle database environment 1.Reviewing basic architecture concepts 2.Oracle 10g Architecture 3.Main features of 9i and 10g Basic SQL*PLUS commands 1.Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL Basic SELECT Statement 1.Writing the statement in sql plus, Running the SELECT statement Ordering the output 1.Single Column, Descending order, multiple column sorts Conditional retrieval of data 1.Working with complex conditions, AND OR NOT LIKE BETWEEN Working with variables 1.Creating and using variables, Command substitution Pseudo columns and functions 1.Pseudo Columns, Row num, Sys date, User & UID, the Dual Table 2.Working with character functions 3.UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), 4.TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE 5.Working with date functions 6.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() Using non-character function 1.ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins Using the SET operators 1.Union, Intersect, minus Aggregating data using group functions 1.GROUP BY, HAVING Creating Sub queries 1.Single Row sub queries, Multiple row Sub queries Enhancing groups function 1.ROLLUP, CUBE Transaction Control Language 1.Rollback, Commit, save point Processing hierarchies 1.creating the Tree structure, LEVEL, CONNECT BY Data Manipulation Language 1.INSERT, UPDATE, DELETE Data Definition Language 1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE Using Declarative Constraints 1.Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized Views, Other Data dictionary views Database Security 1.Object Privileges, Granting access to objects Improving query performance 1.Planning and managing the tuning process, Employing tuning tools, Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output, Optimizer concepts, Fundamentals of access paths, Gathering object and system statistics with DBMS_STATS, Utilizing hints and optimizer mode, Specifying first-rows optimization, Determining the driving table Other Concepts 1.The Relational Database Model, The system Development Lifecycle, Overview of normalization PL/SQL Blocks 1.Structure, Writing Anonymous Blocks Variables 1.Oracle Data types, TYPE and ROWTYPE declarations, Value assignments Control structures 1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, 2.LOOP END , LOOP statement, WHILE condition, FOR condition Cursors 1.Implicit and Explicit Cursors, Cursor Manipulation statements, 2.OPEN FETCH CLOSE EXIT WHEN Printing Values to Screen Procedures 1.Creating and Calling Procedures Functions 1.Creating and Calling Functions Packages 1.Package Header, Package Body Design Tips and Techniques 1.Format of standard packages in an application, Spec and Body, NOCOPY hint Triggers 1.Database triggers, calling procedures from triggers Dynamic SQL 1.EXECUTE IMMEDIATE, DBMS_SQL package Oracle Supplied packages 1.DBMS_OUTPUT, UTL_FILE Collection data types 1.Associative Arrays, Nested tables, VARRAYs Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com
Understanding Asynchronous Processing and Patterns in Node js
 
50:42
One of the things that make Node.js so efficient is its asynchronous nature. Unfortunately, newcomers to Node.js often fall victim to the “pyramid of doom,” as anonymous callback functions pile up. The resulting code is often hard to understand and even harder to debug. Is this just par for the course when working with Node.js? It doesn't have to be! In this session, attendees will learn how to tame the asynchronous nature of Node.js using several tools and techniques including, named functions, Promises, the Async library and more. Dan McGhan is an Oracle Developer Advocate with a focus on JavaScript and Oracle Database. He started his programming career as a back-end Oracle Database developer specializing in SQL and PL/SQL. A few years later he began working with JavaScript in the front-end and mid-tier to create web apps and APIs. These days he enjoys sharing his love for JavaScript, Node.js, and Oracle Database via his blog at https://jsao.io. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 521 Oracle Developers
Tim Hall - Oracle Database expert
 
01:40
Tim is an ACE Director and he usually present at the Oracle Technology tour Latin America about his latest experiences working with SQL and Databases.
Views: 179 OracleAmericaLatina
The Oracle - 18' Freestyle
 
03:22
I do NOT own the instrumental This is my first freestyle, hope y'all like it :) Lyrics: niggas wanna kick it all off with a jump start i pump hearts when them niggas in the hood bump my art i make master pieces, got holier bars than Jesus and it increases the fire in the air that you are breathin call me a dragon, braggin my rhyme scheme and time seems hard thats why i rhyme neat and like Queens i'm straight forward, the product of mass destruction i cant stand fake niggas like white functions and bust em i'm like a gat, fast and nasty, like flash you cant catch me i'm the godfather son, you cant even clap me i'm right off the top, call a cop for the rhymes i kill the crimes are real, rob my style and you too will feel how its like to be dead, the heat gets hotter more hot than what Nas did to Sean Carter i'm heavily leathal spit like a gun that you fear you'll end up like Tekkishi if you come too near wannabe thugs are about to get bust i just can't stand how these niggas must hold guns and act tough like they aint got no hands a prostitute can take more if you pay her four grands i've got more friends than foes so i'm fearless you bring along your clique and i make a clear mess bloodbath, when i bust gats like a cripp ever seen the heaven, i'll cut short the trip caught the snitch who been fucking with the crew you hypocrite nigga, you aint no proof i wont turn you in, i'll murder you friend i hate cops too man, just moving with the trends you wanna proceed to me i'd prefer caution i'm awesome, went to the stages just to rock em my rhymes are deadly and i hope that you get me before we have a beef and the reaper let me do his job, i load the glock and make you drop rock the gat back at you nigga how you like that? ayo check it The Oracle in the house be rocking it like Kendrick i'm sendin a message to the lutanents i'm better at letting niggas grave become full i'm lustful for hard punchlines and rhymes that are hurtful when it comes to rappin i'm a veteran better than any nigga you listening name your favorite rapper and im dissin him im hardcore, and im ruthless step to me son and i'll make you toothless i've been rappin holy and my rhymes aint fruitless you're useless and my stealthy lethal rhymes will leave you clueless my flow can be really hard to catch, like dash when i rap fast niggas just stare back, i'm here at the mic bustin it like gats and guns i rap for fun, i'm the last one to spit some real shit that real niggas enjoy there's a rap throne and im the king, boy
Views: 165 The Oracle

Examples of a cover letter for a retail job descriptions
Paper writing service
Santa clara address admissions essay
How to start a cover letter engineering intern
Purpose of a cover letter in a business plan