http://www.itcertificationmaster.com/become-oracle-certified-master-fun-profit-kamil-stawiarski/
Code listings
No code listings in this article.
CONTINUE READING
001Oracle
Oracle 12c – WITH FUNCTION
In Oracle 12c there is a possibility to define a PL/SQL function inside the "WITH" clause, which can reduce the context switching overhead. Short example: SQL> create or replace function F_DUMMY(x number) retur
1 MIN READRead the field notes ↗
002tips&tricks
Script for metadata export in SQL*Plus
Sometimes you have to export all metadata for a schema but you have no access to data pump or other tools. SQL Developer can cause a lot of problems with referential constraints. But there is always a good old
1 MIN READRead the field notes ↗