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
How to use sql*plus built-in timers?
what is not null constraint? : Sql dba
what are date and time functions in mysql? : Sql dba
What is materialized view. What are different methods of refresh?
Is sql pronounced sequel or sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Why we use stored procedure instead of query?
What are the operators in sql?
Which is better cte or subquery?
What is pivot table in sql?
What are the key differences between SQL and PL SQL?
Is not equal in sql?
who introduced sql?
What is latest version of sql?
Can we group by two columns in sql?