Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

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>