what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 19724 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 localdb mssqllocaldb?
How to select unique records from a table?
How to place comments in pl/sql?
Is sql low level language?
What is a sql driver?
Can one improve the performance of sql*loader? : aql loader
Is merge a dml statement?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How do you respond to dementia behavior?
What are predefined functions in sql?
difference between anonymous blocks and sub-programs.
What is optimistic concurrency control? : Transact sql
Are stored procedures faster than queries?
Can unique keys be null?
