what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 19150 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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 is primary key and foreign key with example?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is trigger explain with example?
What jobs use sql?
What is triggering circuit?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
what is transaction? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is the difference between Union and Union all. Which is faster.
What is the purpose of the sql select top clause?
What are the advantages of pl sql over sql?
What is a loop in sql?
who introduced sql?
What is nosql example?
how to get a list of all tables in a database? : Sql dba
