What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / amruta
Anonymous block: It does not have a name. Starts with
DECLARE or BEGIN.
Named block: Starts with Header Block.
like name of block, type of block, parameter.
Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
Is sql a backend language?
What types of commands can be executed in sql*plus?
Can we alter stored procedure?
Write a query to display the current date in sql?
What is compute?
How do I upgrade sql?
State some properties of relational databases?
Enlist the advantages of sql.
What are pl sql data types?
what is the functionality of the function htmlentities? : Sql dba
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How do you select unique values in sql?
What is procedure in pl sql?
What is form and report?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?