Home
Search results “Oracle when others then exception”
PL/SQL tutorial 48: Declare User-Define Exception using RAISE_APPLICATION_ERROR
 
06:39
Manish Sharma from RebellionRider.com presents PL/SQL Tutorial on How To Declare User-Define Exception using RAISE_APPLICATION_ERROR in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/user-define-exception-2 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 18850 Manish Sharma
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: 880 Tech Query Pond
7. Compile-time warnings help avoid "WHEN OTHERS THEN NULL".
 
03:23
One of Tom Kyte's favorite pet peeves, the following exception sections "swallow up" errors. EXCEPTION WHEN OTHERS THEN NULL; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE (SQLERRM); In fact, any exception handler that does not re-raise the same exception or another, runs the risk of hiding errors from the calling subprogram, your users, and yourself as you debug your code. Generally, you should log the error, then re-raise it. There are certainly some cases in which this advice does not hold (for example: a function that fetches a single row for a primary key. If there is no row for the key, it's not an application error, so just return NULL). In those cases, include a comment so that the person maintaining your code in the distant future knows that you weren't simply ignoring the Wisdom of the Kyte. Example: EXCEPTION WHEN OTHERS THEN /* No company or this ID, let calling subprogram decide what to do */ RETURN NULL; One way to avoid this problem is to turn on compile-time warnings. Then when your program unit is compiled, you will be warned if the compiler has identified an exception handler that does not contain a RAISE statement or a call to RAISE_APPLICATION_ERROR. 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.
Ask Tom Office Hours: PL/SQL Error Management
 
01:01:44
In our March 2018 session, we explored error management, from raising to handling exceptions. We took a look at SAVE EXCEPTION with FORALL, LOG ERRORS, when it makes sense to "swallow up" an exception - though preferably not with WHEN OTHERS THEN NULL. AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 319 Oracle Developers
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.
6. Always log error (and backtrace) before re-raising the exception.
 
02:28
When you re-raise an exception, you will reset the backtrace (the track back to the line on which the error was raised) and might change the error code (if you raise a different exception to propagate the exception "upwards"). So it is extremely important to call you error logging subprogram (see previous Good to Know) before you re-raise an exception. 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.
PL/SQL tutorial 49: Declare user define exception using PRAGMA EXCEPTION_INIT in Oracle Database
 
08:24
RebellionRider.com presents PL/SQL Tutorial on How to declare user define exception using PRAGMA EXCEPTION_INIT in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/user-define-exception-3 Previous Tutorial ► User-Define Exception using RAISE_APPLICATION_ERROR https://youtu.be/k3xCWONvRxY ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 16915 Manish Sharma
4. Outer block unaware of error if not re-raised.
 
03:03
If you do not re-raise an exception in your exception handler, the outer block doesn't know an error has occurred. Just sayin'. You have a subprogram that invokes another subprogram (or nested block). That "inner" subprogram fails with an exception. It contains an exception handler. It logs the error, but then neglects to re-raise that exception (or another). Control passes out to the invoking subprogram, and it continues executing statements, completely unaware that an error occurred in that inner block. Which means, by the way, that a call to SQLCODE will return 0. This may be just what you want, but make sure you do this deliberately. 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.
Hints and Tips - The simple guide to WHEN OTHERS THEN NULL
 
00:31
A wonderfully simple guide to the usage of WHEN OTHERS THEN NULL in PL/SQL blog: https://connor-mcdonald.com
Views: 486 Connor McDonald
PL/SQL tutorial 22: How To Create Instead-Of Insert Trigger in Oracle Database
 
08:06
Learn how to create Instead of Insert trigger in oracle database on the view by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ My New YouTube Channel ►► http://bit.ly/New-YT-Channel Blog: http://bit.ly/instead-of-insert-trigger Previous Tutorial ► SQL Tutorial 60 View: https://youtu.be/_T6vZVkWzQI ► Startup Trigger: https://youtu.be/UQtsKJ-MPyQ ------------------------------------------------------------------------- ►►►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: 32593 Manish Sharma
PL/SQL tutorial 47: How to declare user-define exception using a EXCEPTION variable
 
05:53
How to declare user-define exception using a variable of EXCEPTION datatype in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/user-define-exception-1 Previous Tutorial ► Introduction to Exception Handling: https://youtu.be/jBzhLOCBuuA ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 18518 Manish Sharma
PL/SQL tutorial 30: Cursor FOR Loop In Oracle Database By Manish Sharma
 
04:33
Learn How To Work with Database (Explicit or Implicit) Cursors using Cursor For Loop in Oracle Database With Example By Manish Sharma on RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-1 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ►Install SQL Developer: https://youtu.be/zliF8kXVmeE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 36558 Manish Sharma
PL/SQL tutorial 39: How To Create PL/SQL Functions in Oracle Database By Manish Sharma
 
06:15
PL/SQL Tutorial for beginners on RebellionRider.com How To Create PL/SQL Functions in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-create-pl-sql-function Previous Tutorial ► Introduction To PL/SQL Function: https://youtu.be/6OJIrPx61mU ► PL/SQL Variables: https://youtu.be/2MNmodawvnE ► PL/SQL Constants: https://youtu.be/r1ypg7WH4GY ------------------------------------------------------------------------- ►►►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: 37967 Manish Sharma
How NOT to Handle Exceptions - Part 1
 
06:43
In which Steven Feuerstein takes a look at several ways you should never handle an exception in your PL/SQL block. To summarize: 1. Don't swallow up or hide errors. 2. Don't simply display error information on the screen through a call to DBMS_OUTPUT.PUT_LINE. 3. Don't handle and re-raise without adding value (logging or doing *something*). Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2017/02/now-not-to-handle-exceptions.html Related LiveSQL script: https://livesql.oracle.com/apex/livesql/file/content_EHHFC36YW2834RB7Z9OE846C6.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 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.
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: 438 khaled alkhudari
75. Exception in PL/SQL Oracle
 
11:34
In this video you will learn about Exception in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 4109 ITORIAN
Function In Oracle PL SQL
 
07:49
Function In Oracle 1)A stored / user defined function is a set of PLSQL statements you can call by name. 2)Stored functions are very similar to procedures. 3)function always return a value. 4)User functions can be used as part of a SQL expression. Parameters to Function : a)IN Parameters b)OUT Parameters c)IN OUT Parameters Create Function : CREATE OR REPLACE FUNCTION FIND_AGE ( EMP_ID IN VARCHAR2 ) RETURN NUMBER IS EMP_AGE NUMBER; SQLSTRING VARCHAR2(4000); BEGIN SQLSTRING:=’SELECT AGE FROM EMPLOYEE WHERE EMP_ID=’||EMP_ID; EXECUTE IMMEDIATE SQLSTRING INTO EMP_AGE; RETURN EMP_AGE; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001,’Error in Find Age function – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END; Call Function : SELECT FIND_AGE('1') FROM DUAL DROP FUNCTION : Syntax : DROP FUNCTION function_name; DROP FUNCTION FIND_AGE; #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 172 Tech Query Pond
About that error: ORA-06502: numeric or value error
 
12:11
"ORA-06502: numeric or value error" is one of the most commonly occurring and irritating errors for PL/SQL developers. Value too big for its "container"? Trying to stuff a non-numeric string value into a number through implicit conversion? [naughty naughty] In this video, Steven takes a close look at ORA-06502, exploring the ways it can be raised and how best to deal with those scenarios. ============================ 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.
Oracle DBA  How to create sql stored procedure Using Sqlplus
 
03:09
Oracle DBA How to create sql stored procedure Using Sqlplus sql create stored procedure sql stored procedure TO Connect Database 1) Open command Prompt. 2) SET ORACLE_SID=DATABASE NAME 3) SQLPLUS USERNAME/[email protected] CREATE OR REPLACE PROCEDURE INSERT_DATA IS SQLSTRING VARCHAR2(1000); BEGIN SQLSTRING:=’INSERT INTO EMPLOYEE_BKP(ID,NAME,CITY,SALARY,DEPT_NO) ‘; SQLSTRING:=SQLSTRING||’ SELECT ID,NAME,CITY,SALARY,DEPT_NO FROM EMPLOYEE’; EXECUTE IMMEDIATE SQLSTRING; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001,’An error was encountered – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END;
Views: 1045 Tech Query Pond
PL/SQL tutorial 57: PL/SQL Collection Associative Array in Oracle Database
 
08:05
Manish Sharma from RebellionRider presents you the latest PL/SQL tutorial on Collection ASSOCIATIVE ARRAY. In this video, you will learn – - What are Associative Arrays? - How to create Associative Arrays? - How to Insert & Update the data of Associative Array and - How to retrieve the data from an Associative array using two different ways? So if you are wondering whether associative array is a persistent form of collection or not; Is it bounded or unbounded in nature; why should we use this specific collection over others such as VARRAY or Nested Table; What are the differences or similarities between associative array and other collections? Then go ahead and watch the video to find out the answers to all these questions. Hope you will enjoy watching. Do make sure to Like and Share this post/video because that will help others in learning as well as help me and my channel in reaching out. This way we can educate more and more people for FREE. Most importantly SUBSCRIBE to the channel as many such interesting tutorials are coming your way. Thanks. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/associative-array Previous Tutorial ►While Loop: https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 11799 Manish Sharma
Tour the Oracle Dev Gym!
 
06:51
Flex Your Oracle Muscles! [Note: the UI for the Dev Gym has changed since this video was recorded, but the basic operations of taking quizzes is still present. Enjoy!] You make a living working with code and data - both of which are changing all the time. How do you stay at the top of your game? How do you keep all your knowledge fresh, current and readily available when you are confronted by your next challenge? You go to the gym. You exercise your knowledge. You compete against other developers. You work out, getting strong and flexible. You challenge yourself with practice quizzes and tests. ======================================== Copyright © 2016 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.
ORACLE PLSQL Exception: Membangkitkan Kode Kesalahan Sendiri dengan RAISE_APPLICATION_ERROR
 
10:32
RAISE_APPLICATION_ERROR merupakan jenis exception untuk membangkitkan kode kesalahan sesuai keinginan user. Rentang nomor kode kesalahan yang dapat dibangkitkan adalah -20999 s/d -20000.
Views: 246 Boby Siswanto
SQL: Change User Password
 
02:38
In this tutorial, you'll learn how to change user password in sql plus 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: 7941 radhikaravikumar
PL/SQL tutorial 42: How To Create PL/SQL Stored Procedure With Parameters In Oracle Database
 
04:17
Manish from RebellionRider.com presents PL/SQL Tutorial 42 on How To Create PL/SQL Stored Procedure With Parameters In Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-procedure-2 Previous Tutorial ► PL/SQL Tutorial 40: https://youtu.be/buaSuEMi4lw ► PL/SQL Tutorial 41: https://youtu.be/Uld8eE016Kg ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 28655 Manish Sharma
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: 230 Fdo Luis
PL/SQL tutorial 38: Introduction to PL/SQL functions in Oracle Database
 
05:10
PL/SQL tutorial for beginners Introduction to PL/SQL functions in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-plsql-function Previous Tutorial ► Blocks in Oracle Database https://youtu.be/rbarR4_gaH8 ► ------------------------------------------------------------------------- ►►►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: 44562 Manish Sharma
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: 128848 BBarters
PL/SQL tutorial 40 : Introduction to PL/SQL Stored Procedure in Oracle Database By Manish Sharma
 
04:59
Learn what are "stored procedures" in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/stored-procedure Previous Tutorial ► How To Create PL/SQL function: https://youtu.be/93uqcFVtfWA ------------------------------------------------------------------------- ►►►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: 51295 Manish Sharma
1-.Programacion PL/SQL Orientada a Objetos - Arrays
 
10:35
create or replace type ListaTipoArray as array(5) of varchar2(100); / create or replace type ListaNumTipoArray as array(5) of number(1); / declare --datos nombre1 varchar2(10):= 'Mario'; apellido1 varchar2(10):= 'ruiz'; apellido2 varchar2(10):= 'gonzalez'; pais varchar2(10):= 'Mexico'; Ciudad varchar2(10):= 'CDMX'; --declarar variable tipo array DatosPersonales ListaTipoArray; --declarar variable tipo array NumeroDato ListaNumTipoArray; begin --se abren instancias DatosPersonales:= ListaTipoArray(nombre1, apellido1, apellido2, pais, Ciudad); NumeroDato:= ListaNumTipoArray(1, 2, 3, 4, 5); for i in 1 .. 5 loop dbms_output.put_line(NumeroDato(i)||'.'|| DatosPersonales(i)||chr(13)); end loop; exception when others then dbms_output.put_line(sqlerrm); end; POO Programacion PL/SQL Orientada a Objetos oracle oracle sql oracle pl sql oracle sqlplus curso curso de oracle curso de sql curso de pl sql curso de sqlplus sql developer toad pl / sql developer desarrollo de aplicaciones programador desarrollador como ser programador como ser desarrollador certificacion certificacion oracle certificaciones 1z0-061 1z0-062 dba dba oracle administrador de base de datos administrador de base de datos oracle database oracle preparar certificacion oracle oracle expert oracle experto oramex el mundo de oracle mario ruiz mario ruiz marioruizcommx buenas practicas como usar pl sql como usar oracle como usar toad como usar sqlplus preguntas de la certificacion braindumps oracle linux linux batch awk perl shell scripting shell
Views: 631 Mario Ruiz
PL/SQL tutorial 45: How to Create PL/SQL Package in Oracle Database by Manish Sharma
 
07:22
RebellionRider.com presents PL/SQL Tutorial on How to Create PL/SQL Package in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-package Previous Tutorial ►PL/SQL Function - https://youtu.be/6OJIrPx61mU ► PL/SQL Procedure - https://youtu.be/buaSuEMi4lw ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 23951 Manish Sharma
PL/SQL tutorial 67: PL/SQL Ref Cursors In Oracle Database by Manish Sharma
 
04:33
RebellionRider.com presents introduction to PL/SQL Ref Cursors / Cursor Variable in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-1 Previous Tutorial ►Database Cursor (Playlist): http://bit.ly/2x0JGXz ► Record Datatype (Playlist): http://bit.ly/2xkcHOr ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 11984 Manish Sharma
PL/SQL tutorial 33: Table Based Record Datatype In Oracle Database by Manish Sharma
 
06:48
Learn how to create a table based record type variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-based-records Previous Tutorial ► Introduction To Records: https://youtu.be/1iHbZDuDbis ► SELECT-INTO Statement: 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/ ___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: 30098 Manish Sharma
Oracle Forms | How To Create Basic Login Page -38
 
25:41
Oracle Forms | How To Create Basic Login Page -38 To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY Dear viewer, In this tutorial you will learn how to easily create a login page with Oracle Forms Builder. declare v_record user_info1%rowtype; begin :ERR_MESS:=''; select * into v_record from USER_INFO1 where USER_NAME=:CONTROL.USERNAME; IF v_record.USER_PASS=:CONTROL.PASS THEN --:global.USER_NAME:=v_record.USER_NAME; --:global.memid:=v_record.memid; IF v_record.USER_TYPE= 'admin' then open_form('E:\Micro Credit Project\All Pages\HOME_PAGE.fmx'); elsif v_record.USER_TYPE='operator' then open_form('E:\Micro Credit Project\All Pages\member_PAGE.fmx'); elsif v_record.USER_TYPE='audit' then open_form('E:\Micro Credit Project\All Pages\group_PAGE.fmx'); end if; elsif v_record.USER_PASS ():CONTROL.PASS THEN :ERR_MESS:=('Invalid Password!!'); elsif :CONTROL.PASS is null THEN :ERR_MESS:=('Please enter username/Password!!'); elsif :CONTROL.USERNAME is null THEN :ERR_MESS:=('Please enter username/Password!!'); end if; exception when others then :ERR_MESS:=('Invalid Username/Password!!'); end; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 308 OracleDB Solutions
Shock Therapy for Software Professionals
 
16:07
Humans are creatures of habit, and the programming habits we learn early in our careers or in our use of a certain technology - can be ingrained deeply. That becomes a problem as new versions of the technology are released, or we mature as developers, learn better ways to do things....and then don't do them. In this video, Steven offers a "shock" to relational database developers and encourage a different way of looking at the SQL statements in one's application. ====================================== 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 68: PL/SQL Strong Ref Cursor in Oracle Database
 
07:27
RebellionRider.com presents the second tutorial in PL/SQL Ref Cursors series explaining the concepts of Strong Ref Cursors in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-2 Previous Tutorial ► Record Datatypes: https://youtu.be/8WqpqKUj9l8 ► Database Cursors: https://youtu.be/_snAMqCBitg ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 8407 Manish Sharma
Be Confident in Your Knowledge
 
11:12
It's hard (and stressful) to give presentations on topics on which you are ignorant. Best of all is to have a deep, broad comfort zone with your material. But that isn't always possible. In this video, Steven offers some tips for dealing with that more challenging situation. ====================================== 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 54: PL/SQL VARRAYs in Oracle Database by Manish Sharma
 
05:59
Introduction to PL/SQL VARRAYs in Oracle Database by Manish Sharma from RebellionRider.com. Make sure to subscribe as in next tutorial we will do some example and learn how to create VARRAYs ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/varrays Previous Tutorial ► Create Nested Table: https://youtu.be/cv-WdeFLCvk ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 13615 Manish Sharma
PL/SQL tutorial 62: PL/SQL Collection Method LIMIT in Oracle Database
 
07:38
In this PL/SQL tutorial we will explore the concepts of collection method LIMIT and learn: - What is collection method Limit - How to use this collection method - What are the differences between collection method LIMIT & Collection Method COUNT - What happens when function LIMIT is used with Nested table and Associative array Go ahead and enjoy. Also do not forget to LIKE, SHARE & Subscribe. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/limit-function Previous Tutorial ► Associative Array: https://youtu.be/wGXeD_oWxUk ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5305 Manish Sharma
Oracle PLSQL Online Training and Support
 
03:51
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] Oracle PL/SQL PL-SQL Course Contents Basics of PL/SQL: • PL/SQL architecture • PL/SQL and SQL*Plus • PL/SQL Basics, Variables, Constants, data types & error handling • PL/SQL wrapper utility PL/SQL structures: • Simple blocks • Control structures • PL/SQL records • Recognizing the Basic PL/SQL Block and Its Sections • Describing the Significance of Variables in PL/SQL • Distinguishing Between PL/SQL and Non-PL/SQL Variables • Declaring Variables and Constants • Executing a PL/SQL Block Error checking ? exception handling: • Defining exceptions • Using the when others clause • Ensuring complete error checking • Passing error messages to calling routine Boolean logic in PL/SQL: • Identifying the Uses and Types of Control Structures • Constructing an IF Statement • Constructing and Identifying Different Loop Statements • Controlling Block Flow Using Nested Loops and Labels • Using Logic Tables • If-then-else structure • Testing for numbers characters and Booleans Cursors in PL/SQL: • Cursor basics • Using a cursor for a multi-row SQL query Iteration in PL/SQL: • For loop • While loop PL/SQL tables: • Defining PL/SQL tables • Reasons to use PL/SQL tables • Populating a PL/SQL table • Retrieving from a PL/SQL table Dynamic SQL in PL/SQL: • Introduction to the dbms_sql package • Creating a dynamic SQL statement Nested blocks in PL/SQL: • Introduction to the dbms_sql package • Creating a dynamic SQL statement Triggers in PL/SQL: • Triggers and database events • Defining a trigger • Timing a trigger • Enabling and disabling a trigger Stored procedures, functions and packages: • Basics of stored procedures • Basics of functions • Basics of packages • Defining stored procedures & functions • Function and stored procedures prototypes • Passing arguments to functions and stored procedures • Recompiling functions and stored procedures • Pinning packages in the SGA with dbms_shared_pool.keep • Package forward declaration • Package dependency • Package overloading • Listing package information Bulking in PL/SQL: • Bulk queries • Bulk DML (forall statement) • Using cursor attributes • Analyzing impact of bulk operations Oracle PLSQL training online,Oracle PLSQL training material, Oracle PLSQL training cost,Oracle PLSQL training pdf, Oracle PLSQLtraining in USA uae India,Oracle PLSQL training, online Corporate training malaysia Singapore,Oracle PLSQL software,Oracle PLSQL training in bangalore,Oracle PLSQL training institutes in hyderabad,Oracle PLSQL training in chennai,Oracle PLSQL training in hyderabad, Delhi, Mumbai, Pune,Oracle PLSQL, Oracle PLSQL webinar, online training singapore,Oracle PLSQL eam,Oracle PLSQL as a service,Oracle PLSQLonline Training Oracle PLSQL online TrainingOracle PLSQL online Training Oracle PLSQL online Training maximo scheduler,Oracle PLSQL (consumer product) Oracle PLSQL online TrainingOracle PLSQL online Training Oracle PLSQL online Training Oracle PLSQL online Training Oracle PLSQL online Training , Post Training Support
Views: 15 Trainers Online
PL/SQL 1 - PL SQL environment and variables.
 
05:20
https://drive.google.com/file/d/0BxYoN5rLDBaRSGlZYnI3eHZjQzA/edit?usp=sharing Course objective SQL - PL / SQL: what's the difference? Environment PL / SQL Benefits of PL / SQL Features PL / SQL PL / SQL and then? Example 1 Declare --Optional /* Variables, constants, cursors*/ Begin --Mandatory /* Statements PL/SQL Clauses PL/SQL*/ null; Exception --Optional /*Actions to be performed when an exception is thrown or when an abnormal termination occurred*/ when others then null; End; --Mandatory ----------------------------------- Example 2 set serveroutput on ; BEGIN dbms_output.put_line('Hello World') ; END ; ------------------------------------------------ Example 3 SET SERVEROUTPUT ON DECLARE v_pls_value1 PLS_INTEGER := 0; v_pls_value2 PLS_INTEGER := 1; v_simple_value1 SIMPLE_INTEGER := 0; v_simple_value2 SIMPLE_INTEGER := 1; v_start_time NUMBER; v_end_time NUMBER; BEGIN v_start_time := DBMS_UTILITY.GET_TIME; FOR i in 1..50000000 LOOP v_pls_value1 := v_pls_value1 + v_pls_value2; END LOOP; v_end_time := DBMS_UTILITY.GET_TIME; DBMS_OUTPUT.PUT_LINE ('Elapsed time for PLS_INTEGER: '|| (v_end_time - v_start_time)); v_start_time := DBMS_UTILITY.GET_TIME; FOR i in 1..50000000 LOOP v_simple_value1 := v_simple_value1 + v_simple_value2; END LOOP; v_end_time := DBMS_UTILITY.GET_TIME; DBMS_OUTPUT.PUT_LINE ('Elapsed time for SIMPLE_INTEGER: '|| (v_end_time - v_start_time)); END; ------------------------------------------------ Example 4 DECLARE TYPE client_t IS RECORD ( numero_v NUMBER(4), nom_v CHAR(20), adresse_v CHAR(20) ) ; client1_v client_t ; BEGIN client1_v.numero_v := 2516 ; dbms_output.put_line(client1_v.numero_v); END ;
Views: 1565 Fdo Luis
🌈midAPRIL~midMAY PISCES getting READY for CONFESSION/PROPOSAL? Business/Love/Family
 
27:50
My work is to emphasize on self-empowerment FOR YOU.. it is something that you may able to USE and BENEFIT from instantly, to get courage, affirmation, strength, guidance, clarity to AID your life in the NOW. ORACLE MESSAGE LINKS ARE BELOW! ✨🌸~ Thank you for allowing me to take part of Your voyage! ~ FOR YOUR FREE General MESSAGES from the ORACLE make sure you follow me ✨🌸 WEBSITE https://faydivination.wordpress.com for PERSONAL READING on Instagram https://www.instagram.com/faydivination or on FB https://www.facebook.com/fayintuitive The future is not something that you have to wait for and act out when it happens without willing to work for it or at least try to become a better version of yourself than what you were yesterday. Self work is essential on the path we walk, this is how we evolve. Cause and effect. This is the Nature of Life and Us. You are not the victim of fate and Fate is not the victim of You. Everything happens for a reason, that are most of the time not clear, why (at first). But if it aligns with you that every event, life, situation, people move in an endless circle and interact with each other then I'm the energy reader for you. What is up must come down and what is down must go up -and it will, no exception. My attention centers the core of the subject, we dig deep Friend, and by gaining clarity with me, you may give a chance for yourself to solve and heal those issue(s) so the negative can be lessen and positive can be strengthen – events can (and are) change in the split of a second depending on Your choices you make in your profession/finance/family/romance… and I’m here to help and guide you along this seemingly endless maze we all call, Life. I prefer taking my time in readings to THINK and FEEL before I say what there is to say and using MY VOICE & TONE AS A TOOL to sooth & calm you... by doing so, it helps you to get clarity and being ready to receive. With LOVE, Fay ✨🌸 WEBSITE https://faydivination.wordpress.com for PERSONAL READING Twitter to keep you chirping https://twitter.com/FayDivination Tumblr https://faydivination.tumblr.com ✨🌸 I am honored to use and work with the wisdom, knowledge and the stunning Art & Unique Symbolism of: Stephanie Pui-Mun Law ~ Shadowscapes Jui Guoliang ~ Chinese Tarot YiJing | DeDaoJing Brian Froud ~ Faeries' Oracle Caitlin & John Matthews ~ Celtic and Arthurian Tarot Deborah Koff - Chapin ~ Soulcards Oracle Doreen Virtue ~ Angel Oracle LEGAL DISCLAIMER: 1. All readings are general informations for entertainment purpose only, and are NOT intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice at all. 2. The reading presented in this video is a FREE GENERAL reading from the beginning to the end and you will be NEVER charged for it or navigated elsewhere. 3. By watching/listening to this video you automatically state that you are the minimum 18+yrs of age, you understand and accept that Fay Divination, its psychic(s) and their readings (visual/verbal/written) presented here or elsewhere are NOT responsible for you and/or for your choices, decisions and actions you make in your life based in this video or otherwise. 4. The future is not set in stone. You have FREE WILL to lead your life, act upon or to change it the way You wish it to be, and alone You Are taking responsibility in/for your own life fully. 5. Fay Divination is a honest, direct channel and does NOT use 3rd party engine or company to generate numbers in subscription, likes or views on YouTube or elsewhere. Every "count" you see here is reflecting the realistic stats. This channel is featuring and associating with other honest & genuine channels and public figures, only.
Views: 1909 Fay Divination
A Brujos Fashion Tips for 2018
 
55:24
Two... Well three of the most popular questions I get from YouTube watchers is more about my fashion than about my Spiritual Path and my Brujeria. Many good some puzzling and some plain dumb. Ill answer two here in the video. The 3rd ill answer in this post and that's all I have to say about that. :) 1. I like your style of clothing and jewelry what would you recommend I get as a gift for so and so? 2. I thought all Witches dressed Gothic or like Nature lovers Hippie clothing. Well ill answer that one here. ((No my style is a mix of all that with a bit of Dracula / Gitano / Cowboy / Biker cuddly Bear I guess :) But we all don't dress in Goth or like Hippies from the 60s most of us dress in what society would consider normal every day clothing. )) 3. Are you sure you are Puerto Rican and not from Central America? ((Nope.. I have much love and respects for my Centro & Sur Americano Brujos and Brujas but I am Puro Boriqua. Pure Puerto Rican.))) 100 percent Grade A American Puerto Rican, Pa que Sepas. As for my personal fashion tastes. Well thank you very much, that's sweet and here it is all bundled up in one video. Sancista Brujo Luis. Fashion Tips. That have worked for me since the 1980s 90s until today. If it ain't broke.. Don't fix it, just upgrade it a little every year. :) I always had my own fashion style of clothing and always wore what feels comfortable to me and strayed away and avoid like the plague anything that everyone else is Waring. Always strive to look and feel sexy, suave, comfortable and confident in what you wear. Remeber the clothes don't make the man, the man makes the clothes, but with the correct choices, they can make any man look great. 1. Leather Jacket Black jackets. 2. exsesorise. Silver. silver Silver or stainless steel. Gold is not Rock silver is. Skulls, Snakes and over do it More is definitely not Less. Big studded belts never die out.. Earrings. Nice wrist bracelets. Leather breaded stainless steel or silver. 3. Boots. I stay away from sneakers with the only the exception for Converse. 4. Vintage. I have no problems with vintage and vintage second hand shops. Vintage jeans the best. Jeans relaxed not into skinny jeans.. Well sometimes :). Faded always ment to look old and ruff. 5. I keep it dark, rock with hints of white. Nice White T shirt and call it a day. I try to buy color and can't do it always go back to black sections. 6. HATS All kinds try hats. 7. Bandanas, bandanas bandanas. Many times my face is scruffy. But always clean and moisturized when time to make a video. :) always have a bandana a cap or a hat on. 8. I don't wear Designer labels or store Logos and no I dont show them off. I don't advertise or pay a store to be a walking bilboard for them. I wear the clothese the clothes don't wear me. I don't wear other celebrity mens sport names splattered on my back with numbers over me. I always tend to think when I see others wear that that they are wearing the man they wish they could be and never will be. Only logo are usually old Rock Bands, maybe a Super hero Logo or B for Boston or NY for New York. 9. Vests with a t-shirt. Cut off plaid shirts t-shirt under. Fall vest spring vest very classy and cool. 10. Tats. I like it simple edgy occult symbols. 11. Cologne. Spice like allspice, cloves, aspens, cinnamon, with hints of bergamot and citrus and tonka beans. Smell like a Man, not like a Marica or a Pica Flor. 12. I like a nice black lather Wallet with dog chain to keep my keys safe at all times. My Agua Florida Florida Water Formulary https://youtu.be/BIwQVODaNUY Bay Rum Formulary https://youtu.be/WnPmrxIWU9M Bay Rum Alcoholado https://youtu.be/GKfJLDF9jvQ Polishing Silver Tarnished silver is no match for this aluminum foil recipe. Bring one liter of water, one tablespoon of baking soda, and one piece of aluminum foil to a boil. Drop silverware in the pot for 10 seconds longer if it's very tarnished, then remove using kitchen tongs. Abracadabra Presto Magic!
Views: 3863 SANCISTA BRUJO LUIS
Inauthenticity // Dark Night Of The Soul // Spiritual Awakening! Oracle Card Reading // #Clairvoyant
 
20:34
I am a Seeker, A Seer and a Visionary. I am Your Intuitive Health Coach. This Oracle Card Reading is for m Laurie and those of you who are drawn to watch it. Do you want to know what spirit is trying to tell YOU? You can book a Video Reading with me and I will create a video for you just like this! I will connect to spirit and receive Clairvoyant Visions along with your Oracle Card Reading. I receive messages from spirit using all of my senses. Each message is completely unique and is based on you specifically. When I create them on video they are meant to be shared as they will resonate with others. I also offer private live sessions where you can ask questions as well. Message me if you would like details on purchasing an Oracle Card Video Reading or your Live (via Skype or FB Messenger or telephone call) Intuitive reading now. [email protected] • This video contains a very powerful message with quite a lot of clairvoyant imagery. Because this is a powerful message, If you feel this message is for you and you have any questions that require clarification you can post them below in the comments. I will connect to spirit and ask they they provide clarification for you. This message is for a few specific people who will resonate with all of it and many who will resonate with some. However it resonates with you, is perfect for you. If something does not apply to you or it does not feel right (resonate) then let it go. It was not meant for you. Always let a message sit in your heart space. What I gather from this reading is that you are going through the last phases of the dark night of the soul. You have experienced contrast in childhood and now some of that karma is coming back for you to clear it up so you can move on to your spiritual awakening. A spiritual awakening is a BEAUTIFUL experience. However, it has to do with a great deal of change change and more change. Evolution of the soul moving into the future means symbolic "dying" of the past. You are moving toward a very new life. A wonderful new life! The life you were born to lead. The life you deserve. We incarnate into these physical bodies in each particular lifetime in order for us to learn, grow and expand. To understand love and compassion from every angle including that of the "loveless" and compassionless" Each lifetime we return with soul family members. We play specific roles in eachothers lives. Much like actors in a play. There must be perpetrators in order for there to be victims. In this life you may have learned lessons about victimization. In a previous or future life you may choose to learn lessons about it from the opposite perspective. From spirit perspective, there is no right or wrong. No good or bad. There just is. All that we choose to experience in each life is based loosely on what we came here to learn. We ALWAYS have free will. There is never a time when we do not. We choose our human form. We choose our parents. We choose when we are to be born and what type of experiences we want to have. Then we incarnate with our soul family and play out these different roles in each others lives in order for us to all learn and grow... individually and of course as a collective because we are... all connected to each other and to source. All the time. Always. With no exceptions. I leave you with this today. I feel that this message has a high priority based on the events that are taking place in the world right now. A great deal of contrast and extremes. The carpet has been shaken and the dirt (contrast/negativity) is rising to the surface to be vacuumed away, but before it can be removed it has to rise to the surface. So fear not. The end is not near. We are going through a great time of change. A great time of awakening. Spirit is here to guide us all the time. We need only ask. Remember you are never alone. Choose to learn from the teachers who resonate with your inner being and be sure to interact if you desire because everyone is both teacher and student. We teach eachother and learn from eachother. Always choose teachers who make you feel hope. Who teach you to empower yourself. Not everyone was born to lead others but EVERYONE was born to lead their own lives. You do not need a master. You need guidance and there are many awakened souls now who can offer this guidance to you. Feel your way ... use your emotions as your guide. A.A. Metatron Subscribe to this Youtube Channel Follow me on Facebook at Your Intuitive Health Coach Contact me for a reading at [email protected]
Views: 81 C. Meagan Michael
How to Solve Kernel Panic Issue - not Syncing Fatal Exception in Virtual box
 
00:34
VirtualBox causes “kernel panic – not syncing: fatal exception in interrupt” on the host Issue resolved: Go to your virtual machine - Settings - System Then change Chipset from PIIX3 to ICH9 and enable "Enable IO APIC" After that, your virtual machine will boot without any issue. ******************************************************************************************** Please Bye Web Hosting from any site HostGator, GoDaddy and Bluehost, I will get Small %. Just Click Below Link to Redirect to Website. PLEASE Click Below Link to Redirect to HostGator Web Hosting…. http://goo.gl/znPKM8 PLEASE Click Below Link to Redirect to Bluehost Web Hosting… http://goo.gl/tGawjL -------------------------------------------------------------------------------------------------------------- For Your Information Only I am Willing to Make a FREE or CHARGE Website, if YOU WANT ME TO MAKE A VIDEOS ON Different Technologies/field I WILL DO IT.. Watch Others Videos and Have any Quries Email to me on ([email protected]) ---------------------------------------------------------------------------------------------------------------- NOTE :- For Any Clarification Please Comment Below Comment, Like and Share us and help us to spread. ####--------------------------­------------------------------­------------------------------­#### Subscribe to Cloud Network :- http://goo.gl/LjKGzc Website :- http://www.cloudnetwork.in Like us on Facebook :- http://facebook.com/itcloudnetwork Follow us on Twitter :- http://twitter.com/itcloudnet Circle us on Google+ :- https://goo.gl/StVdHb Pin us on Pinterset :- http://pinterset.com/itcloudnet Add us on LinkedIn :- http://in.linkedin.com/pub/itcloudnet Skype Id :- cloud.network1 E-Mail Id :- [email protected] ####--------------------------­------------------------------­------------------------------­--#### Thanking You Hope U Like it........
Views: 27914 Cloud Network
1.Java Identifiers.
 
16:32
Java is a programming language. It was first developed by James Gosling at Sun Microsystems, which is now a part of Oracle Corporation. It was released in 1995 as a part of Sun Microsystems' Java platform. The language has developed much of its syntax from C and C++. Java applications are usually compiled to bytecode (class file) that can run on any Java Virtual Machine (JVM). Java is currently one of the most popular programming languages being used. It has about 10 million users.Java and JavaScript are not the same thing; in fact, they are not even related. JavaScript is a scripting language which is used mainly inside of web browsers. Java is commonly used to teach students how to program as a first language, yet is still also used by professionals. Java requires that each variable be initialized. Some older languages such as C, allow variables to go uninitialized, which can cause random failures with mysterious bugs. Java requires that each method that declares a return type, always return a value. This also prevents bugs. Java comes with a large set of classes and methods, the Java API that can be used without having to develop as much code "from scratch". Unlike C, Java primitive types, such as int, are always the same size in the number of bits which helps achieve cross-platform compatibility. Java used to be thought of as being slower than C, but that's less important in recent years with computers being faster. Java has exception-handling that requires a programmer to handle error-conditions such an Input/Output errors. Code compiled on one Java platform can be run on other platforms that support Java without modification of either the source-code nor the byte-code. For example, this means that a person can make a Java program for a Windows computer and have it run a Linux computer or a Mac computer. Java is considered as a strongly typed programming language. Thus all variables in the Java programming language ought to have a particular data type. This is either declared or inferred and the Java language only allows programs to run if they adhere to type constraints.If you present a numeric type with data that is not numeric, say textual content, then such declarations would violate Java’s type system. This gives Java the ability of type safety. Java checks if an expression or data is encountered with an incorrect type or none at all. It then automatically flags this occurrence as an error at compile time. Most type-related errors are caught by the Java compiler, hence making a program more secure and safe once compiled completely and successfully. Some languages (such as C) define an interpretation of such a statement and use that interpretation without any warning; others (such as PL/I) define a conversion for almost all such statements and perform the conversion to complete the assignment. Some type errors can still occur at runtime because Java supports a cast operation which is a way of changing the type of one expression to another. However, Java performs run time type checking when doing such casts, so an incorrect type cast will cause a runtime exception rather than succeeding silently and allowing data corruption.
Views: 328 DASARI TUTS
158 Paul Austin LSD  Microdosing  &  Peak  Performance | Legends & Losers Podcast
 
01:32:41
Get the latest episodes by email: www.legendsandlosers.com/free Get the book Play Bigger on Amazon: https://www.amazon.com/Play-Bigger-Dreamers-Innovators-Dominate/dp/0062407619/ref=sr_1_1?ie=UTF8&qid=1485715097&sr=8-1&keywords=play+bigger+book Paul Austin is committed to changing the cultural conversation about psychedelics through his platform, The Third Wave. Paul wants to help others understand how microdosing could be used as a tool for personal growth and understanding. “Microdosing sits at that avenue where it becomes this palpable way to try psychedelics without being intimidated by the potential of a bad trip or a challenging experience.” - Paul Austin Three Things We Learned Psychedelic use and computer evolution bloomed around the same time Initial research in the 60s showed a relationship between moderate dose on LSD use and breakthroughs in creativity and problem-solving. The research, however, got nipped in the bud when the use of psychedelics was made illegal by the turn of the decade. Still, this didn’t invalidate the claim of some association between higher psychedelic use and the birth of Silicon Valley. What was then counter-cultural is now mainstream A lot of the things frowned upon in the 60s became rising stars in this age of technology. Psychedelics are no exception. This stands to reason, given its role in the process of molding the technological center we all celebrate today. “Yoga, mindfulness meditation, psychedelics, even collective or communal living… a lot of those counter-cultural things are now becoming more mainstream culture in the here and now.” - Paul Austin Psychedelic use is now beyond a medical research model Psychedelics offer the same non-dual, mystical experience related to yoga, meditation, and even a connection with the higher power, as some groups would say. It’s euphoric as much as it is therapeutic. Scientific evidence has made it more acceptable for practical use, particularly in inducing peak performances. Psychedelics bolster creativity and problem-solving. However, there's a need for continued research and dialogue in order to take advantage of the potential of these substances. Utility of microdosing technique to ease people into their effects and make use of them without pitfalls is also just as important. BIO Paul Austin is committed to changing the cultural conversation about psychedelics through his platform, The Third Wave. Because of his work with microdosing, Paul has been featured in Rolling Stone and Business Insider, with additional pieces in the New York Times, Playboy, and Lifehacker. In June 2015 Paul began his first microdosing protocol. Immediately, he noticed improvements in his energy levels, creativity, and a general sense of well-being. The impact of microdosing was so profound on his life that Paul wanted to help others understand how microdosing could be used as a tool for personal growth and understanding.
Views: 236 Legends and Losers
Make Room For THE TRUTH - Vernon Howard
 
05:35
Heed these words, You who wish to probe the depths of nature: If you do not find within yourself that which you seek, neither will you find it outside. In you is hidden the treasure of treasures. Know Thyself and you will know the Universe and the Gods. ― Delphi Oracle In oneself lies the whole world, and if you know how to look and learn, then the door is there and the key is in your hand. Nobody on earth can give you either that key or the door to open, except yourself. - J. Krishnamurti There are only two mistakes one can ever make on the Path To Truth: not starting; and not going all the way. - The Buddha Without self knowledge, without understanding the working and functions of his machine, man cannot be free, he cannot govern himself and he will always remain a slave. ― G.I. Gurdjieff The unexamined life is not worth living. ― Socrates Wonder is the beginning of wisdom. ― Socrates It is unwise to be too sure of one's own wisdom. ― Gandhi Real knowledge is to know the extent of one's ignorance. ― Confucius The only true wisdom is in knowing you know nothing. ― Socrates When told that man lives in delusion everyone thinks of himself as the exception; hence his delusion. ― Vernon Howard Empty your cup so that it may be filled; become devoid to gain totality. ― Bruce Lee Long is the night to him who is awake; long is a mile to him who is tired; long is life to the foolish who do not know the true law. ― Buddha Being ignorant is not so much a shame, as being unwilling to learn. ― Benjamin Franklin Wisdom is the principal thing; therefore get wisdom: and with all thy getting get understanding. ― Proverbs 4:7 Vernon Howard Talks Playlist on Youtube: https://www.youtube.com/watch?v=PM_pMwzWDOM&list=PLKM35g3I0JIN9j6-yiwNPlKyQbE0S49ZP Vernon Howard Books Download: https://mega.co.nz/#!z5NHQbaZ!RUvVlwZWzZGzrOpXimtJbzmh6Yhvu4-1kKVMnGcWPZk Vernon Howard Talks Download: https://thepiratebay.la/search/Vernon%20Howard/0/99/0 Free uTorrent Download: (use this to download the talks) http://www.utorrent.com/ Vernon Howard's Wikipedia Page: https://en.wikipedia.org/wiki/Vernon_Howard Employ your time in improving yourself by other men's writings so that you shall come easily by what others have labored hard for. ― Socrates There is only one good, knowledge, and one evil, ignorance. ― Socrates Ignorance is literally "not knowing" (i-gnosis). It is here especially not knowing the reality of our existential dilemma as beings trapped in the samsaric round. This comes from not seeing the three characteristics of unsatisfactoriness, impermanence and insubstantiality that are inherent in all conditioned phenomena. Instead, the worldling sees the things of the world as satisfying, lasting and real. Because of fundamental ignorance about their true natures, worldlings desire some experiences and detest others. Because of their desires they hate those people and things which thwart them. Because of their hatred, they desire power to destroy. And the blindness and intoxication of both lust and hatred create even greater delusion and ignorance, even to the point of madness. There is simply no way that any variation within the play of desire, aversion and delusion can ever transcend itself. The way out points to that which is beyond all this. We cannot live better than in seeking to become better. ― Socrates The only journey is the one within. ― Rainer Rilke He who is not contented with what he has, would not be contented with what he would like to have. ― Socrates Contentment is natural wealth, luxury is artificial poverty. ― Socrates Prefer knowledge to wealth, for the one is transitory, the other perpetual. ― Socrates If you look for truth, you may find comfort in the end; if you look for comfort you will not get either comfort or truth only soft soap and wishful thinking to begin, and in the end, despair. ― C.S. Lewis It is a great mystery that though the human heart longs for Truth, in which alone it finds liberation and delight, the first reaction of human beings to Truth is one of hostility and fear. ― Anthony de Mello The highest form of ignorance is when you reject something you don't know anything about. ― Wayne Dyer I've come to realize that the biggest problem anywhere in the world is that people's perceptions of reality are compulsively filtered through the screening mesh of what they want and do not want to be true. ― Travis Walton Above all, don't lie to yourself. The man who lies to himself and listens to his own lie comes to a point that he cannot distinguish the truth within him, or around him, and so loses all respect for himself and for others. And having no respect he ceases to love. ― Fyodor Dostoyevsky These things I have spoken unto you, that in me ye might have peace. In the world ye shall have tribulation: but be of good cheer; I have overcome the world. ― John 16:33
"STAND YOUR GROUND" MONDAY,  OCTOBER 30TH 2017-DAILY ORACLE MESSAGE***PLUS NEW CONTEST INFO***
 
04:19
Spiritual monthly message brought to you by Therapeutic Intuitive Tarot & Oracle Readings. Fastest way to book a private reading is to directly contact me via email at [email protected] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Therapeutic Intuitive Tarot & Oracle Readings INTRODUCTION PRICE LIST $50.00 *** 30 minute minimum *** Emailed Recorded Video (Live Skype/Video Chat AVAILABLE NOVEMBER 2017) *** Phone Reading UNAVAILABLE due to nature/time consumption of reading *** General/Topic Focused Readings *** Extensive/In Depth Readings (NOT to exceed 1 hour) $25.00 *** Celtic Cross Spread *** General/Topic Focused *** Emailed Recorded Video (Live Skype/Video Chat AVAILABLE NOVEMBER 2017) *** Phone Reading Available (w/ Screenshot of Reading emailed) *** General/Topic Focused Readings *** Not to exceed 30 minutes $20.00 *** ALL Other Tarot Spreads (w/ the EXCEPTION of specials and 1/3 card readings) *** Emailed Recorded Video (Live Skype/Video Chat AVAILABLE NOVEMBER 2017) *** Phone Reading AVAILABLE (w/ screenshot of reading emailed) *** General/Topic Focused Readings *** Not to exceed 30 minutes $13.00 *** 3-Card Spread (Ex. Past, Present, Future) *** Specific to certain Questions/Topics (Past, Present, Future/ Yes or No Readings) *** General/Topic Focused Also Available *** Emailed Recorded Video (Live Skype/Video Chat AVAILABLE NOVEMBER 2017) *** Emailed written reading w/ screenshot of reading included *** Phone Readings UNAVAILABLE $10.00 *** 1-Question/1 Answer Tarot Readings *** Emailed Recorded Video ONLY (LIVE NOT AVAILABLE) *** Emailed Written Reading w/ screenshot of reading included *** Phone Readings (NOT AVAILABLE) *** TOPIC FOCUSED QUESTIONS ONLY ~~~~MONTHLY SPECIALS~~~ $3.33 *** 1-Question/1 Answer Tarot Readings *** Emailed Recorded Video ONLY (LIVE NOT AVAILABLE) *** Email written Reading w/ Screenshot of reading included *** Phone Readings (NOT AVAILABLE) $7.77 *** LIBRA/SCORPIO OCTOBER BIRTHDAY READING SPECIAL*** *** Choice of 1-Question/1 Answer Reading, General Celtic Cross Spread *** Emailed Recorded Video ONLy (LIVE NOT AVAILABLE) *** Emailed Written Reading w/ screenshot of spread included *** Phone Readings (NOT AVAILABLE) *** (((Proof of Birthday/Sign REQUIRED))) $11.11 *** OCTOBER MONTHLY LOVE READING SPECIAL*** *** Spread of Choice Selected by Reader upon booking *** Emailed Recorded Video ONLY (LIVE NOT AVAILABLE) *** Emailed Written Reading w/ screenshot of spread included *** Phone Readings (NOT AVAILABLE) ALL READINGS MUST BE SCHEDULED, BOOKED & PURCHASED BEFORE ANY READINGS TAKE PLACE. THERE IS A 24-72 HOUR TURN AROUND TIME FROM THE TIME OF REQUEST UNTIL BOOKING IS SCHEDULED/CONFIRMED. ALL PAYMENTS MUST BE MADE PRIOR TO ANY QUESTIONS WILL BE ANSWERED IF NOT OF A GENERAL NATURE. (((HOWEVER MOSTLY ALL GENERAL QUESTIONS CAN BE ANSWERED VIA YOUTUBE PAGE VIDEOS AND SIMPLY COMMENTING BELOW ONE OF MY VIDEOS))) READER WILL BE REQUIRED TO VERIFY DOB PRIOR TO SPECIAL BIRTHDAY MONTH READINGS (ONLY FAIR TO THE BIRTHDAY SIGN, EVERYBODY CANNOT BE SPECIAL EVERY MONTH) AFTER READING IS BOOKED & CONFIRMED, READER WILL EMAIL CONFIRMATION WITH A SHORT MESSAGE WHERE PROSPECTIVE CLIENT IS THEN ABLE TO OBTAIN ADDITIONAL Q&A OR FAQ'S SPECIFICALLY TO YOUR READINGS AND READER WILL RESPOND W/I 24 HOURS BUT MOST DEFINITELY PRIOR TO YOUR READING TAKING PLACE, THANK YOU FOR YOUR INTEREST IN MY READINGS AND MY ENERGY AND I LOOK FORWARD TO READING FOR YOU SOON! LOVE, LIGHT & POSITIVE ENERGY!!!
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
Gemini, Love! Fighting Temptations! Mid-Month March ‘18
 
36:08
STEPS TO BOOKING A PRIVATE READINGS: 1.) Send me a Backstory/ signs of persons involved: [email protected] 2.) Payment (My Readings are avg. 75-90 Mins long: $77/ $57 payable to PayPal.me/EugeneKenyatta ($77 dollars is the price, however I’m making exceptions for students and those going through financial difficulties. Please if you can pay the full amount, DO SO!) 3.) 4 day Wait time for readings to be submitted after payment is made. If you don’t receive your reading within 4 days, PLEASE let me know!) For On-The-Phone/ EMERGENCY/ Video Chats please find me on INSTANTGO ( https://instantgo.com/soulmateexperience ) if you don’t have an Apple product, then shoot me an Email.

The jazz singer essay
Tell us about yourself mba essay template
Super project case study solution
Xuxub must die essay scholarships
Essay on epilepsy