- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 05:24 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 06:35 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 06:04 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 06:22 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 07:33 AM
Hi Vijay,
Thank you for the response. Helped a lot
Thanks,
Gopi