CODE SNIPPETS

All the Code Snippets and Samples you need

Oracle

How to get all column names of a Table in Oracle

ByAdministrator

Feb 18, 2015 , , , , , , , , , , , ,

To get all column names of a Table in Oracle you can use the following snippet.

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'TABLENAME'

If you are using MSSQL, take a look at this snippet -> How to list all columns from a table in MSSQL

By Administrator

Related Post

Oracle

How to get a list of all tables in Oracle

Feb 15, 2015 Administrator
4 thought on “How to get all column names of a Table in Oracle”

Leave a Reply