what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 19709 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
What are types of joins?
Is drop table faster than truncate?
How do I view output in sql developer?
Does normalization improve performance?
What is union, minus and interact commands?
What is the difference between between and in condition operators?
What is the purpose of normalization?
What is query optimization in sql?
How many types of triggers exist in pl/sql?
What is left join in sql?
Why do we use cursors?
discuss about myisam index statistics collection. : Sql dba
What are properties of the transaction?
What are the properties of a transaction?
What is an implicit commit?
