Skip to content

Instantly share code, notes, and snippets.

@abhi1010

abhi1010/gist:11365686

Created April 28, 2014 08:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abhi1010/11365686 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abhi1010/11365686 to your computer and use it in GitHub Desktop.
Download ZIP
View all the columns of a given table
Raw
gistfile1.sql
SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='ASGDLX_TBLBRAND'
where "ASGDLX_TBLBRAND" is the table name.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment