How to use T-SQL statement to all fields of a view in Oracel?

土豆君

As the title; in SQLserver, as long as I know the name of the view, I can get all the fields of the view by querying two system tables. How can I achieve this in Oracle?

海蓝之谜

select * from user_tab_column where table_name = 'xxx'

whbilly

select view_name, text from user_vies where view_name = upper ('yourname');

whbilly

The above statement gets the view creation statement

still alright

select * from user_tab_column where table_name = upper ('yourname');
Get field names and comments

panda_ren

sqlplus window:
SQL> desc view_name
This won't do

土豆君

The brother upstairs can indeed get the data I want, but I have to get it through ADO.NET, what should I do? I have just contacted Oracel, I hope you can elaborate a little bit, I am grateful and disrespectful

panda_ren

select * from view_name where rownum <2
Column information can be obtained by using the fields property of ADO.NET