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
How to combine two stored procedures in sql?
Is sql free?
Explain the difference between 'between' & 'and' operators in sql
What is the maximum size of sqlite database?
what is the difference between truncate and delete statement? : Transact sql
Can we insert delete data in view?
Explain what is an index?
Is inner join faster than left join?
What is the difference between drop and truncate commands?
Why use stored procedures?
What are all the ddl commands?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
how many values can the set function of mysql take? : Sql dba
Are stored procedures faster than queries?
Why use triggers in sql?