what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / vaibhavi_dixit
Anonymous block those pl/sql blocks which are not stored in
your DB as an objects, whereas named pl/sql blocks are
those blocks which are stored in DB as an objects.Due to
storage in DB, these named pl/sql blocks can be called from
another named or anonymous blocks, or from any form also...
Is This Answer Correct ? | 34 Yes | 2 No |
Post New Answer View All Answers
Can we use threading in pl/sql?
What is the difference between cross join and natural join?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How do you sort in sql?
Can sql developer connect to db2?
what does it mean to have quoted_identifier on? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is a boolean in sql?
what are the differences between char and nchar? : Sql dba
what are the t string functions available in tsql? : Transact sql
What are analytical functions in sql?
How do I truncate a word?
Can we change the table name in sql?
What is equi join in sql?