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


Please Help Members By Posting Answers For Below Questions

how to get a list of indexes of an existing table? : Sql dba

514


Write a sql query to get the third highest salary of an employee from employee_table?

634


What is primary key in db?

517


Which command is used to delete a package?

577


How to run sql functions in pl/sql?

536






Can we insert data into materialized view?

510


What is pl sql in dbms?

503


What is a pdo connection?

512


What is use of term?

618


how to rename an existing table in mysql? : Sql dba

574


What are the set operators in sql?

551


what is the syntax for using sql_variant_property? : Transact sql

531


Why do we use cursors?

509


What is the current version of sql?

538


What are triggers and its types?

551