How do I get the name and type of fields in a table, using Oracle and C # (WPF)?
How do I get the name and type of fields in a table, using Oracle and C # (WPF)?
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.