Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 58491 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun samal
Anonymous blocks are to be compiled each time when we
require it.But once we compile a named pl/sql block it is
permanently stored as p-code after compilation in the
shared pool of the system global area.
We can call named blocks by any pl/sql block that
appears within an application but we cannot call anonymous
blocks.
| Is This Answer Correct ? | 33 Yes | 2 No |
Post New Answer View All Answers
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How do you concatenate in sql?
How do I run a sql query?
what is a cursor? : Sql dba
How do you create an update query?
What is meant by truncate in sql?
Why left join is used in sql?
Can we use ddl commands in pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Could you please provide oca (oracle 10g) dumps for my certification ?
What will you get by the cursor attribute sql%rowcount?
what are the differences between binary and varbinary? : Sql dba
Does oracle roll back the transaction on an error?
What is thread join () in threading?
How to pipe multiline string to isql?
