Monday 17 October 2011

Difference in different version of oracle

Some new pl/sql enhancements in oracle 8i and 8

EXECUTE IMMEDIATE Command
New Pragmas-serially reusable, autonomous transactions
New Database Triggers
startup,shutdown,logon,logoff,alter,create,drop

Expanded Oracle Supplied Packages
dbms_profiles,dbms_trace,dbms_debug

Extended Security Methodology
Password expire
Password reuse max
Password grace time
Locking user accounts, and unlocking

No comments:

Post a Comment