Difference between Anonymous and Named PL/SQL block.
0
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. |
0 comments: