Oracle show column of table

Column names in oracle sql

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Oracle show column of table

SELECT column_name
  FROM all_tab_cols
 WHERE table_name = 'USERS'
   AND owner = '" +_db+ "'
   AND column_name NOT IN ( 'PASSWORD', 'VERSION', 'ID' )

Source: stackoverflow.com

Oracle show column of table

-- Depending on schema grants:
SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- User tables
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- Access granted
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';	-- All schemas

-- Columns from all tables in a schema (or USER_..., DBA_... instead of ALL_...):
SELECT c.TABLE_NAME, c.DATA_TYPE FROM ALL_TAB_COLS c
JOIN ALL_TABLES t ON t.OWNER = c.OWNER
WHERE OWNER = 'my_schema';

Similar codes

27 votes308 views5 answers
Mysql set password for user
SQL
0 vote287 views1 answer
Oracle sql log to console
SQL
11 votes302 views3 answers
How to get last row of table in sql
SQL
17 votes351 views4 answers
Show all tables in oracle
SQL
0 vote291 views1 answer
How to move a column to different spot mysql
SQL
1 vote276 views1 answer
How to truncate a table in databse
SQL
1 vote299 views1 answer
Setval pgsql
SQL
0 vote287 views2 answers
Sql max count
SQL
0 vote291 views2 answers
Plsql regex match whole word
SQL
0 vote271 views2 answers
Clear window pl sql
SQL