what is the difernece between named and anonymous pl/sql
blocks??
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 the disadvantages of mysql? : Sql dba
Does varchar need length?
what is an index? : Sql dba
What is delimiter sql?
explain normalization concept? : Sql dba
What is dialect in sql?
Do we need to rebuild index after truncate?
What is the difference between in and between in sql?
What can sql server reporting services do?
How insert into statements in sql?
what are different types of collation sensitivity? : Sql dba
What is mutating trigger?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How does cross join work in sql?
What are the most important characteristics of pl/sql?