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

Compare sql & pl/sql

611


What are expressions?

563


Explain ttitle and btitle.

672


How many aggregate functions are available there in sql?

528


what are enums used for in mysql? : Sql dba

610






What is case function?

601


explain what is mysql? : Sql dba

600


Do stored procedures prevent sql injection?

550


Does pl sql work in mysql?

536


What is a database event trigger?

596


What is primary key and foreign key with example?

496


How do I view a sql trace file?

568


Which sql most popular?

556


What is sql exception?

517


What are the built in functions of sql?

567