What is the difference between anonymous block and named
blocks?
Answer Posted / anil kumar jampana
1)anonymous block will store in os
where as named block will store in database
2)we can call named block but not anonymous
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
write an sql query to find names of employee start with 'a'? : Sql dba
How can we make an if statement within a select statement?
What is record data type?
Can you selectively load only those records that you need? : aql loader
What is type and rowtype in pl sql?
When can we use the where clause and the having clause?
Why procedure is used in sql?
What is the difference between row level and statement level trigger?
Why is pl sql needed?
How does a trigger work?
Where do we use pl sql?
What is a unique key and primary key and foreign key?
What are the features of pl sql?
what are the 'mysql' command line options? : Sql dba
What is rank dense_rank and partition in sql?