What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / ganesh
anonymous is unnamed plsql block, cannot save in database,
cannot allow any mode of parameter.
stored programs are saved into database and we can recall
them whenever programe require it, it accept the mode of
parameter like
in,in out,out.
| Is This Answer Correct ? | 55 Yes | 3 No |
Post New Answer View All Answers
explain commit and rollback in mysql : sql dba
What is a data definition language?
Is crud a cuss word?
What is sql scripting?
Is pl sql a scripting language?
What is auto increment in sql?
What is sql performance tuning?
When should I use nosql database?
What is %s in sql?
What is meant by user defined function?
Could you please provide oca (oracle 10g) dumps for my certification ?
What are the types of variables use in pl sql?
Can one improve the performance of sql*loader? : aql loader
Can we delete column in sql?
What do you understand by pl/sql cursors?