To select all the columns from a table in Oracle, you can use an asterisk (*). Below is an example of Oracle Select All Columns:
Selecting All The Columns of a Table in Oracle
The following SQL query uses star * (asterisk) to get the all columns:
Select * from EMP;
If your question is to get the all columns from a specific tables, then you can use the following Oracle SQL query:
SELECT table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERE table_name = 'EMP'
Output
| TABLE_NAME | COLUMN_NAME | DATA_TYPE | DATA_LENGTH |
|---|---|---|---|
| EMP | EMPNO | NUMBER | 22 |
| EMP | ENAME | VARCHAR2 | 10 |
| EMP | JOB | VARCHAR2 | 9 |
| EMP | MGR | NUMBER | 22 |
| EMP | HIREDATE | DATE | 7 |
| EMP | SAL | NUMBER | 22 |
| EMP | COMM | NUMBER | 22 |
| EMP | DEPTNO | NUMBER | 22 |
