Features you can use ‘in the database’ include:
- Flashback queries (what did my data look like at a certain moment in time)
- Data Security (only read and write data you are authorized for)
- Performance increase (Set based operations, regular expressions, analytics)
- EBR (near zero downtime application upgrades or support for parallel database worlds)
- Data integrity/quality (Single Point Of Data Integrity)
- Special SQL features like paginating your result.
- Identity columns (12c)
- Invisible columns (12c)
- Whitelisting PL/SQL program units (12c)
- Improvement of execution of PL/SQL in a SQL query (12c)
- Cross session Result cache (both SQL and PL/SQL) (11g)
Informacije o predavanju / Information
Jezik / Language: ENG
O Avtorju / About author
Patrick Barel is a PL/SQL Developer for Qualogy in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins for PL/SQL Developer. He publishes articles on his own blog. In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he has been promoted to ACE Director.
