Toad World® Forums

Beta Released (12.11.0.21)

Beta Notes

Formatter

Of the following statements many more instances will be formatted:

  • SELECT …COST() PREDICTION() PREDICTION_DETAILS()
  • ALTER SYSTEM
  • ALTER TABLE
  • ALTER TABLESPACE
  • CREATE TABLESPACE
  • CREATE INDEX
  • ADMINISTER KEY MANAGEMENT
    Grammar

ALTER/CREATE TABLE: The type PLS_INTEGER cannot be used as a data type, this will now be flagged as an error.

Grammar 12cR1

Grammar update to the latest 12cR1 docs (DDL) :

  • ADMINISTER KEY MANAGEMENT
  • CREATE INDEX
  • CREATE PLUGGABLE DATABASE
  • ALTER/CREATE TABLESPACE
  • ALTER SYSTEM
  • ALTER DISKGROUP
    Grammar update to the latest 12cR1 docs (expressions, functions and common clauses) :
    * PREDICTION functions
    * FORMAT JSON clause in expressions