how to retrieve only the field names from a database view?

[Gopi22]

Hi Friends,

How can i get all the field names from a particular database view? Is there anyway I can export all the fields from that database view?

Only the fields and not the data.

[vijay152]

Hi Gopi,

Run the report on this Table - sys_db_view_table_field, you will get the list of fields used in Database Views.

you will not get the table in Reports as its Sys Table, so go the Table i mentioned directly and generate your report.

Thanks,

Vijay

[Gopi22]

Hi Vijay,

Thanks for your help.

But what i want is :

I have a database view u_productline_view.

I want all the fields in this view exported. All the field names to be precise.

Is there any way to do that?

If there is a way, please help.

Thanks,

Gopi

[vijay152 · Accepted solution]

Hi Gopi,

if you go to the table sys_db_view_table_field and dot walk in the List Layout, you can see the View(Productline).

See the sample attached:

this will help you to get the list of fields used in that view

[Gopi22]

Hi Vijay,

Thank you for the response. Helped a lot

Thanks,

Gopi