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
