How to bring the fields name and type from an oracle table in C #

1

How do I get the name and type of fields in a table, using Oracle and C # (WPF)?

    
asked by anonymous 17.02.2016 / 18:05

1 answer

1

This query returns the names and field types of a table:

select COLUMN_NAME, DATA_TYPE 
from ALL_TAB_COLUMNS 
where TABLE_NAME = 'NOME_TABELA'

Just run it using your default SQL query engine and read the result.

    
22.02.2016 / 16:57