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 do you mean by rowid?
What is cold data?
Is it possible to create the following trigger: before or after update trigger for each row?
How many types of literals are available in pl sql?
Why coalesce is used in sql?
how to write date and time literals? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Does google use sql?
What does fetching a cursor do?
What is type and rowtype in pl sql?
How to Declare Fixed Length String Value In PL SQL
what is rollback? : Sql dba
How do you declare a user-defined exception?
Is natural join same as inner join?
How do you truncate?