By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (
id INT PRIMARY KEY
);
SELECT table_name, column_name
FROM user_tab_columns;
| TABLE_NAME | COLUMN_NAME |
|---|---|
| TABLE_NAME | ID |
SELECT id FROM table_name;
SELECT ID FROM TABLE_NAME;
SELECT Id FROM TaBlE_nAmE;
SELECT "ID" FROM "TABLE_NAME";
CREATE TABLE "table_name" (
"id" INT PRIMARY KEY
);
SELECT table_name, column_name
FROM user_tab_columns;
| TABLE_NAME | COLUMN_NAME |
|---|---|
| TABLE_NAME | ID |
| table_name | id |
SELECT "id" FROM "table_name";