Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

A View Doubt

This is a discussion on A View Doubt within the Oracle forums, part of the Databases category; We can see code in procedure, functions and triggers using ALL_SOURCE. But How to see a query assosiated with a view?...

Geeks Talk > Databases > Oracle A View Doubt

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   11-12-2007

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 66 Times in 64 Posts

A View Doubt We can see code in procedure, functions and triggers using ALL_SOURCE. But How to see a query assosiated with a view?

Sponsored Links

#2 (permalink)   11-13-2007

susarlasireesha Expert Member   Join Date: Apr 2007 Location: Bangalore Posts: 462 Thanks: 23 Thanked 57 Times in 56 Posts

Re: A View Doubt Use sys.All_views

#3 (permalink)   11-13-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,483 Thanks: 8 Thanked 128 Times in 115 Posts

Re: A View Doubt You many not have priviliges to select from All_views . Use User_views instead.

#4 (permalink)   11-13-2007

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 66 Times in 64 Posts

Re: A View Doubt I have given the following command select text from all_views where view_name='FM_CURRENCY'; I was able to view first two lines only. How to view entire query?

#5 (permalink)   11-13-2007

pande.dhiraj Junior Member   Join Date: Nov 2007 Location: india Posts: 26 Thanks: 4 Thanked 3 Times in 3 Posts

Re: A View Doubt you can see that in the user_views and dba_views or all_views

#6 (permalink)   11-13-2007

pande.dhiraj Junior Member   Join Date: Nov 2007 Location: india Posts: 26 Thanks: 4 Thanked 3 Times in 3 Posts

Re: A View Doubt Quote: Originally Posted by krishnaindia2007 I have given the following command select text from all_views where view_name='FM_CURRENCY'; I was able to view first two lines only. How to view entire query? you just set the long parameter sql> set long 2000;

The Following User Says Thank You to pande.dhiraj For This Useful Post:

krishnaindia2007

Geeks Talk > Databases > Oracle

« Importing Data | Archieve file »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Normal View, Materialised View and Bitmap Index	Geek_Guest	Oracle	3	05-28-2008 12:59 AM
a doubt....	Ammu_R	PHP	1	08-17-2007 10:51 AM
doubt	Santhana KrishnaN	C#	3	06-07-2007 11:42 PM
doubt in qtp	thejovathich	QTP	2	04-30-2007 08:02 AM
Doubt in PHP	blenda	PHP	1	07-20-2006 12:37 PM

All times are GMT -4. The time now is 02:08 PM.