create a blank table with no column

Question

Is it possible to create a table without any column? If YES then how can I do it in oracle.

Answer 1

1. Create table without columns:

   CREATE TABLE tab();

ORA-00904: : invalid identifier

2. Create with one column and try to drop it:

   CREATE TABLE tab(t INT);
   ALTER TABLE tab
   DROP COLUMN t;

ORA-12983: cannot drop all columns in a table

The construct with no column does not have any sense. If you need table as placeholder use DUAL like:

SELECT 1 + 1 AS result
FROM dual;

Answer 2

A table is a collection of columns and rows. You need at least one column.