Geeks Talk

Prepare for your Next Interview




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?...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 11-12-2007
Expert Member
 
Join Date: Sep 2007
Posts: 754
Thanks: 22
Thanked 66 Times in 64 Posts
krishnaindia2007 is on a distinguished road
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?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 11-13-2007
Expert Member
 
Join Date: Apr 2007
Location: Bangalore
Posts: 462
Thanks: 23
Thanked 57 Times in 56 Posts
susarlasireesha is on a distinguished road
Re: A View Doubt

Use sys.All_views
Reply With Quote
  #3 (permalink)  
Old 11-13-2007
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,483
Thanks: 8
Thanked 128 Times in 115 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: A View Doubt

You many not have priviliges to select from All_views . Use User_views instead.
Reply With Quote
  #4 (permalink)  
Old 11-13-2007
Expert Member
 
Join Date: Sep 2007
Posts: 754
Thanks: 22
Thanked 66 Times in 64 Posts
krishnaindia2007 is on a distinguished road
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?
Reply With Quote
  #5 (permalink)  
Old 11-13-2007
Junior Member
 
Join Date: Nov 2007
Location: india
Posts: 26
Thanks: 4
Thanked 3 Times in 3 Posts
pande.dhiraj is on a distinguished road
Re: A View Doubt

you can see that in the user_views and dba_views or all_views
Reply With Quote
  #6 (permalink)  
Old 11-13-2007
Junior Member
 
Join Date: Nov 2007
Location: india
Posts: 26
Thanks: 4
Thanked 3 Times in 3 Posts
pande.dhiraj is on a distinguished road
Re: A View Doubt

Quote:
Originally Posted by krishnaindia2007 View Post
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;
Reply With Quote
The Following User Says Thank You to pande.dhiraj For This Useful Post:
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


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.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved