What is the difference between anonymous block and named
blocks?
- 3 Answers
- 9876 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil kumar jampana
1)anonymous block will store in os
where as named block will store in database
2)we can call named block but not anonymous
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is sql scripting?
What is sql performance tuning?
What are the two types of cursors in pl sql?
Why do we use %rowtype & %type in plsql?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is the limitation on the block size of pl/sql?
What is a delimiter in sas?
How do I start sql from command line?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Can we rename a column in the output of sql query?
Is left join same as join?
What is pl sql variable?
what happens if you no create privilege in a database? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
What is sql key?
