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


Please Help Members By Posting Answers For Below Questions

What are the various levels of constraints?

676


what is single byte over head in oracle..?

1882


Which join is like inner join?

572


Are sql database names case sensitive?

511


Can we join tables without foreign key?

529






what are enums used for in mysql? : Sql dba

620


What is the difference between microsoft sql and mysql?

520


How would you convert date into julian date format?

602


What are aggregate functions in sql?

641


What is the plv (pl/vision) package offers?

625


Are stored procedures faster than queries?

528


Which is faster truncate or drop?

568


Why schema is used in sql?

521


How do I get sql certification?

537


Can we write dml inside a function in sql server?

509