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
What is sqlca in powerbuilder?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Explain the uses of database trigger.
What is set serveroutput on in pl sql?
How to avoid duplicate records in a query?
what are the drivers in mysql? : Sql dba
What is the use of index in hive?
how to use myisamchk to check or repair myisam tables? : Sql dba
How do you optimize a stored procedure in sql?
What are the three forms of normalization?
What is a procedure in pl sql?
What is plpgsql language?
What are the types of records?
what is a table in a database ? : Sql dba
Which query operators in sql is used for pattern matching?