Desc in Oracle

Submitted by:Tim Kelly

Date added:19 March, 2011

Category:PL SQL

Showing here an example of PL SQL Query

Tags: oracle query

Code Snippet:

      SELECT
COLUMN_NAME,
CONCAT(CONCAT(CONCAT(DATA_TYPE,'('), DATA_LENGTH),')') TYPE,
NULLABLE IS_NULL
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'my_table_name';
 
 

Comments