What is the difference between anonymous block and named
block or stored procedure?

Answer Posted / ganesh

anonymous is unnamed plsql block, cannot save in database,
cannot allow any mode of parameter.

stored programs are saved into database and we can recall
them whenever programe require it, it accept the mode of
parameter like
in,in out,out.

Is This Answer Correct ?    55 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlca in powerbuilder?

536


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

523


Explain the uses of database trigger.

623


What is set serveroutput on in pl sql?

549


How to avoid duplicate records in a query?

557






what are the drivers in mysql? : Sql dba

522


What is the use of index in hive?

523


how to use myisamchk to check or repair myisam tables? : Sql dba

478


How do you optimize a stored procedure in sql?

480


What are the three forms of normalization?

494


What is a procedure in pl sql?

519


What is plpgsql language?

502


What are the types of records?

503


what is a table in a database ? : Sql dba

516


Which query operators in sql is used for pattern matching?

517