1 / 8

Lecture-5

Lecture-5. 4. PL/SQL allows declaration and use of variables in blocks of code. These variables can be used to store intermediate results of a query for later processing, or calculate values and insert them into an Oracle table later.

marcin
Download Presentation

Lecture-5

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lecture-5

  2. 4. PL/SQL allows declaration and use of variables in blocks of code. These variables can be used to store intermediate results of a query for later processing, or calculate values and insert them into an Oracle table later. 5. Via PL/SQL, all sorts of calculations can be done quickly and efficiently without the use of the Oracle engine. DECLARE Declaration of memory variables, constants, cursors, etc. in PL/SQL BEGIN SQL executable statements PL/SQL executable statements EXCEPTION SQL or PL/SQL code to handle errors that may arise during the execution of the code END;

  3. Oracle Engine PL/SQL block of code DECLARE Procedural Statements, BEGIN Procedural Statements, SQL statements; EXCEPTIONS SQL statements; END; PL/SQL Engine SQL Statement Executor

More Related