PLSQL Tutorial

Understand Pl Sql Tutorial for beginners or advance  PL/SQl data types, conditions and looping,types of cursor,How to handling PLSQl exceptions, How to define PL/Sql functions procedures packages, and PL/SQl Triggers.

Pl Sql comes after publishing oracle database(version 7) .PLSQL basic structure block  build using

DECLARE,BEGIN,EXCEPTION,END keywords.

This block are define declarative block, executable block, exception handling block and last one end of structure.

So let's start learn PLSQL really  fascinating.

PLSQL (Procedural Language/Structured query Language) execute in Oracle Database.

PLSQL includes procedural language element like  declaration, conditions,looping.

SPOOL is not available in iSQL*Plus

Spool will record all your statements in a text file which will be created in the path specified by you in path directory.

Until and unless you swtich off the spool it won't record your statements but a file will be created in that path.

You can try doing this using SQL * Plus Prompt

spool on

spool f:\students\abc.txt

select * from employees;

 spool off