Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21644 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / purushotham
Named pl/sql blocks are nothing but procedures.
procedures are compiled and stored in the database and
a user can call the procedure when required.
whereas anonymous are unnamed pl/sql blocks that will be
available for the time that is executed and it will not the
stored in the Database.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain raise_application_error.
What is an exception in pl/sql?
What is loop in pl sql?
What is the command used to fetch the first 5 characters of a string?
What do you mean by table in sql?
Can we call procedure in select statement?
What is the best free sql database?
How can you load multi line records? : aql loader
Is hadoop a nosql?
What is primary key in db?
How do you remove duplicates without using distinct in sql?
what is a foreign key ? : Sql dba
What is blind sql injection?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
how to create a new table by selecting rows from another table in mysql? : Sql dba
