Pages

Pages

Difference between Anonymous and Named PL/SQL block.

Difference between Anonymous and Named PL/SQL block:
Anonymous PL/SQL Block
Named PL/SQL Block
1.This is an unnamed PL/SQL Block. 1.This is a named PL/SQL Block.
2.These are stored in operating system. 2.These are stored in oracle database.
3.There is no security. 3.Oracle is providing security.
4.There is no information hiding facility. 4.There is a hiding facility.
5.It requires every time compilation process. 5.It is compiled once and ready to execute
6.Granting privileges on this is not possible. 6.Granting privileges ispossible.
7.These are not accessible to other program. 7.These are accessible by other oracle tools like SQL*PLUS, Oracle Forms,Reports.

No comments:

Post a Comment