What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / kavitha
An anonymous block is a pl/sql block that appears in your
application and is not named and stored in your database.
A stored procedure or a named block is a pl/sql block that
oracle stores in the database and can be called by name
from any application
| Is This Answer Correct ? | 41 Yes | 12 No |
Post New Answer View All Answers
What is the benefit of foreign key?
Does inner join remove duplicates?
Determine if oracle date is on a weekend?
Does user triggers have entry for trigger with compilation errors?
Explain the types of joins in sql?
What is the maximum size of sqlite database?
What is normalization in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is data types in sql?
What is the difference between delete, truncate and drop command?
What are the two characteristics of a primary key?
how to enter numeric values as hex numbers? : Sql dba
What is mdb stand for?
what are the nonstandard string types? : Sql dba