Toad World® Forums

Beta Released (12.1.0.4)

Parser Changes (v254):

  • DML subqueries: Support added for common table expressions with function/procedure program used.
    Example:
DELETE __/*+WITH_PLSQL*/__     FROM (**WITH FUNCTION func RETURN NUMBER AS            BEGIN                             RETURN 7788;           END;**           SELECT * FROM emp WHERE empno = func())
  • The following statements were adjusted to follow the 12c GA grammar:

    • CREATE DATABASE

    • CREATE PLUGGABLE DATABASE

    • ALTER PLUGGABLE DATABASE

    • ALTER TABLE

    • ALTER DISKGROUP

    • GRANT and REVOKE

  • GRANT/REVOKE: Support added for ON COMMIT REFRESH and QUERY REWRITE clauses.

    Example:
    
    GRANT ON COMMIT REFRESH ON myschema.mytable TO myuser
    
  • MERGE: USING clause supports now UNION of subqueries.

    Example:
    
    MERGE INTO ttt **USING** (SELECT * FROM uuu  **                      UNION**                                     SELECT * FROM vvv) bb                ON ( bb.dummy = bb.dummy)                WHEN MATCHED THEN UPDATE SET ee.dummy = '1'
    
  • CREATE TABLE: external table clause accepts now the ILM and [NO]MONITORING clauses, which is undocumented.