Skip to content

Instantly share code, notes, and snippets.

@jaehoo

jaehoo/ora_desc.sql

Created August 5, 2014 17:35
Show Gist options
  • Save jaehoo/d4a442aaecb107209f8d to your computer and use it in GitHub Desktop.
Save jaehoo/d4a442aaecb107209f8d to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Describe Table - Alt
Raw
ora_desc.sql
SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='ORD';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment