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.

About the author

Donec non enim in turpis pulvinar facilisis. Ut felis. Praesent dapibus, neque id cursus faucibus. Aenean fermentum, eget tincidunt.

0 comments:

Recent Posts