Learnings

This page is dedicated to collect important Oracle learnings. create table as select and NULL columns converting LONG to CLOB deterministic functions finding partition name based on HIGH_VALUE using TBL$OR$IDX$PART$NUM in SQL, PL/SQL, keyword “PARTITION FOR” CUBE,ROLLUP,GROUPING SETS,GROUPING_ID,GROUPING,GROUP_ID Join operation … Continue reading Learnings