SQL Oracle Specific

Oracle-specific features — SEQUENCE, ROWNUM, SYSDATE, CONNECT BY, PL/SQL. This category documents 44 SQL oracle specific entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: SEQUENCE (Oracle), ROWNUM / FETCH FIRST, SYSDATE / CURRENT_DATE, CONNECT BY (Hierarchical), DUAL Table, MERGE INTO (Oracle), FLASHBACK QUERY, WITH FUNCTION (Oracle 12c+), MATCH_RECOGNIZE, COLLECT() / CAST(COLLECT()), NVL() / NVL2() / NULLIF(), DECODE(), LISTAGG() (Oracle), XMLTABLE / JSON_TABLE (Oracle), PIVOT / UNPIVOT (Oracle), SYS_REFCURSOR / CURSOR, LAST_QUERY_COST (Oracle), Oracle COMMIT Options, Oracle Flashback Table / Drop, TO_CHAR() / TO_DATE(), Oracle Analytic Functions, Oracle PL/SQL (Procedural), Oracle Virtual Column, Oracle Partition Pruning, Oracle Flashback Query (AS OF), Oracle Analytic LAG/LEAD IGNORE NULLS, LISTAGG with OVERFLOW (Oracle 12.2+), Oracle BULK COLLECT, Oracle MERGE with DELETE, Oracle CURRENT_DATE vs SYSDATE, Oracle EXTRACT with Timezone, Oracle Nested Tables, Oracle VARRAY (Variable Array), Oracle Data Pump (expdp/impdp), Oracle MATERIALIZED VIEW (Refresh), Oracle DUAL Table Details, Oracle HIERARCHICAL QUERY LEVEL, Oracle EXTERNAL TABLE, Oracle JSON Functions, Oracle SAMPLE Clause, and more. Not sure where to start? SEQUENCE (Oracle) and ROWNUM / FETCH FIRST are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.