advanced code snippet search

Posted By

darkapple on 04/16/10


Tagged

table Oracle desc


Versions (?)

Desc in Oracle

 / Published in: PL/SQL
 

URL: http://ss64.com/ora/desc.html

Expand | Embed | Plain Text 
  1. SELECT 
  2. COLUMN_NAME, 
  3. CONCAT(CONCAT(CONCAT(DATA_TYPE,'('), DATA_LENGTH),')') TYPE,
  4. NULLABLE IS_NULL
  5. FROM USER_TAB_COLUMNS
  6. WHERE TABLE_NAME = 'my_table_name';

Report this snippet  

You need to login to post a comment.