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 various levels of constraints?
what is single byte over head in oracle..?
Which join is like inner join?
Are sql database names case sensitive?
Can we join tables without foreign key?
what are enums used for in mysql? : Sql dba
What is the difference between microsoft sql and mysql?
How would you convert date into julian date format?
What are aggregate functions in sql?
What is the plv (pl/vision) package offers?
Are stored procedures faster than queries?
Which is faster truncate or drop?
Why schema is used in sql?
How do I get sql certification?
Can we write dml inside a function in sql server?