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
- 58827 Views
- I also Faced
- E-Mail Answers
Answer Posted / ranjith
The anonymous block statement is an executable statement
that can contain PL/SQL control statements and SQL
statements. It can be used to implement procedural logic in
a scripting language.
named block or stored procedure is a pl/sql block that
oracle stores in the database and can be called by name
from any application
examples are function,procedure and packages,etc.....
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is dbo in sql?
What are tuples in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is the use of procedures?
what is 'trigger' in sql? : Sql dba
Is sql considered coding?
What is clustered and nonclustered index in sql?
i have some prob lem to tell me about my self in interview first round ...
What is difference between rank () row_number () and dense_rank () in sql?
Which constraints we can use while creating database in sql?
Is sql a backend language?
What is range partitioning?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How to use boolean type in select statement?
