Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[NEWBIE] How to view contents of a view

567489Mar 16 2007 — edited Mar 18 2007

I have to check the content of the v$sql_text view or rather SQL_TEXT column of v$sql or v$sqlarea view to see which SQL statements are executed but, how can I view the contents of a view?

Aqua Data Studio 4.7.2 that I use is ok for viewing the data of a table but I cannot seem to find a way to display the contents of a view :-C

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2007

Added on Mar 16 2007

#general-database-discussions

3 comments

947 views