Table Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Table
  4. The table is created with no rows if the query returned no rows
SQL> CREATE TABLE Y AS SELECT * FROM X WHERE 1 = 2;
SQL>