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: