How to bring the name of the fields and type of an oracle table in c#

Asked

Viewed 61 times

1

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

c# oracle

1 answer

1

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

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

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

Browser other questions tagged c# oracle

You are not signed in. Login or sign up in order to post.