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
what is innodb? : Sql dba
Explain the the update statement in sql?
What do you understand by case manipulation functions?
what are the different functions in sorting an array? : Sql dba
How do you determine the current isolation level? : Transact sql
What does inner join mean?
How do I sort a table in sql?
What is asqueryable?
What is the file extension for sql database?
How to select unique records from a table?
define join and explain different type of joins? : Sql dba
what is union, minus and interact commands? : Sql dba
What is a database? Explain
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is trigger in sql and its types?