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
- 58895 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
what is sql? : Sql dba
Is mariadb nosql?
How many types of cursors are available in pl/sql?
Enlist the advantages of sql.
What is the use of function "module procedure" in pl/sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is mutating table error?
Explain the difference between triggers and constraints?
where are cookies actually stored on the hard disk? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
What are the most important ddl statements in sql?
Why do we use procedures in pl sql?
What is the difference between left outer join and left join?
What is difference between nchar and nvarchar?
How to start oracle sql developer?
