Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21691 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / vaibhavi_dixit
Anonymous block those pl/sql blocks which are not stored in
your DB as an objects, whereas named pl/sql blocks are
those blocks which are stored in DB as an objects.Due to
storage in DB, these named pl/sql blocks can be called from
another named or anonymous blocks, or from any form also...
| Is This Answer Correct ? | 34 Yes | 2 No |
Post New Answer View All Answers
how many values can the set function of mysql take? : Sql dba
what are all different types of collation sensitivity? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What port does sql server use?
what is the difference between a web-garden and a web-farm? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Can we rollback truncate?
Explain foreign key in sql?
Which function is used to return remainder in a division operator in sql?
Mention what pl/sql package consists of?
What is the basic form of sql query?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is union and union all keyword in sql?
How to raise user-defined exception with custom sqlerrm ?
