what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / mk
the purpose of an anonymous block is to write a one time
code e.g. you can write statements using SQL PLus editor and
accomplish database changes and do stuff which you can also
do by creating a procedure
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the built in functions of sql?
Can we insert data in view?
What does sign mean sql?
what is column? : Sql dba
How do you update a value in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
how to run 'mysql' commands from a batch file? : Sql dba
How many sectors are in a partition?
Can we use view in stored procedure?
What is hibernate and its relation to sql?
what happens if you no create privilege in a database? : Sql dba
How do I view an execution plan in sql?
What is nosql db?
What is the left table in sql?
How do I edit a trigger in sql developer?