Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle show column of table

SELECT column_name
  FROM all_tab_cols
 WHERE table_name = 'USERS'
   AND owner = '" +_db+ "'
   AND column_name NOT IN ( 'PASSWORD', 'VERSION', 'ID' )
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #oracle #show #column #table
ADD COMMENT
Topic
Name
5+8 =