CREATE TABLE aaa (ID NUMBER, i NUMBER)
Table created.
INSERT INTO aaa VALUES (1,1)
1 row(s) inserted.
COMMIT
Statement processed.
select column_name,data_type,data_length from user_tab_cols where table_name='AAA'
COLUMN_NAME | DATA_TYPE | DATA_LENGTH | ID | NUMBER | 22 | I | NUMBER | 22 |
---|
ALTER TABLE aaa ADD (a CHAR(7) NOT NULL, b NUMBER)
ORA-01758: table must be empty to add mandatory (NOT NULL) columnMore Details: https://docs.oracle.com/error-help/db/ora-01758
select column_name,data_type,data_length from user_tab_cols where table_name='AAA'
COLUMN_NAME | DATA_TYPE | DATA_LENGTH | ID | NUMBER | 22 | I | NUMBER | 22 | SYS_C00003_17031708:40:16$ | CHAR | 7 | SYS_C00004_17031708:40:16$ | NUMBER | 22 |
---|