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
0 comments:
Post a Comment
Thank you for your comments we will get back to soon