Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21974 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / dev
YOU CAN NOT PASS PARAMETERS IN ANONYMOUS BLOCK
WHERE AS YOU CAN PASS IT IN NAMED PLSQL BLOCK.
YOU CAN CALL NAMED BLOCK FROM ANY DB(USING DB LINK)
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How many sql databases can you have on one server?
What is Collation Sensitivity ? What are the various type ?
What is difference between joins and union?
what are tables and fields? : Sql dba
Is inner join faster than left join?
What is the size of partition table?
What is the difference between stored procedure and view?
Does truncate release storage space?
How to use transactions efficiently : transact sql
Explain architecture of sql server notification services?
what is “go” in t-sql? : Transact sql
Is left join inner or outer by default?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is a primary key sql?
what is the difference between delete and truncate statement in sql? : Sql dba
