How to get the name and data type of the columns in a table?

[Renan Orati]

I wonder if there is some way or some function by passing the name of the table I can return the column names and types of the columns ... Note: I do not want a command like \"DESC\" just for show ... I want to return as a SELECT to be able to export with spoll ... vlw!!!!

I appreciate there in advance!!! vlw people!

[Tineks]

And ai Renan, beleza?

in Oracle there is a table named , ALL_TAB_COLUMNS her this recorded some information about each column of your tables.
There follows an example:

Code: Select all

SELECT COLUMN_NAME,
       DATA_TYPE,
       DATA_LENGTH,
       DATA_PRECISION
  FROM ALL_TAB_COLUMNS
WHERE UPPER(TABLE_NAME)='MINHA_TABELA'


[] 's

[Renan Orati]

Our kara!!! vlw same ... did I was kara wheel trying to find a way!
vlwwwwwwwwwwww!!!!!!

[Tineks]

Beauty BRO.!!!

good job there.!!!!!!!!!!!!

[Renan Orati]

kara .... so miss a thing!!! lol the description!!! has how to get the description???
lol vlw!!!!!

[Tineks]

Oops, Yes, Bro.!

the comments u can get in the table ALL_COL_COMMENTS , but you'll have to do a join this table with ALL_TAB_COLUMNS tying the table name and the column name!!

Code: Select all

SELECT COMMENTS
  FROM ALL_COL_COMMENTS
WHERE UPPER(TABLE_NAME)='MINHA_TABELA'


[]'s!!

[Renan Orati]

It worked!!

kara vlw! =)