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
- 59173 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
Which join is default?
Who developed sql?
What is the best partition size for windows 10?
How do you optimize a query?
What are crud methods?
What is package in pl sql?
Why stored procedure is better than query?
what are the differences between require and include, include_once and require_once? : Sql dba
How do I truncate a sql log file?
What are the types of subqueries?
Can we use ddl statements in stored procedure?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
How do I write a cron which will run a sql query and mail the results to agroup?
What is dialect in sql?
Differentiate between sga and pga.
