WCPSS Lifelong Learning with Community Schools’ Post

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Learn a Database 23c new feature: the Automatic SQL Transpiler. This is a declarative technique that can improve the efficiency of all code that combines SQL and PL/SQL. Is there a downside to it? Not that I can see. #dba #oracle #oracledatabase #sql #developer #23c #oracle23c #newfeature #orclapex https://lnkd.in/g46DDBdD

Repair SQL performance in Oracle Database with plan baselines. You do not need to be an expert, just use this feature and see the outcome. DBMS_SPM.ADD_VERIFIED_SQL_PLAN_BASELINE This is a 23c feature and has been backported to 19c (19.22 onwards) Click on the link below to learn more about this feature:

#SQL #just_curious RDBM : Oracle 1)To print 1 to 10 query: Select level from dual connect by level <=10; 2) To print 1 to 10 reverse query: Select level from dual connect by level <=10 order by level desc; PL/SQL: -------- 1)To print 1 to 10 begin FOR i in 1..6 Loop DBMS_OUTPUT.PUT_LINE(i); end loop; end; / 2)To print 1 to 10 reverse begin FOR i IN REVERSE 1..6 Loop DBMS_OUTPUT.PUT_LINE(i); end loop; end; /

Rafal presents another nice dive into our Database CICD features with a review of SQLcl Projects #cicd #oracle #sqcl #database #process #bestpractice