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

  1. COLUMN_NAME,
  2. CONCAT(CONCAT(CONCAT(DATA_TYPE,'('), DATA_LENGTH),')') TYPE,
  3. NULLABLE IS_NULL
  4. FROM USER_TAB_COLUMNS
  5. WHERE TABLE_NAME = 'my_table_name';

Report this snippet  

You need to login to post a comment.