sql - 创建一个没有列的空白表

Question

是否可以创建没有任何列的表？如果是，那么我如何在 oracle 中做到这一点。

Answer 1

创建没有列的表:

CREATE TABLE tab();

ORA-00904: : invalid identifier

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

   CREATE TABLE tab(t INT);ALTER TABLE tabDROP 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;