Re: Views for a table
Experiment with dba_dependencies view. - Kirti --- Mauricio Vélez <[EMAIL PROTECTED]> wrote: > Hi everybody > > I have the following question > > How can I query a table's views? > > For example I have the table students and I want to know the views related to this > table. > > Thanks, > Mauricio Vélez > > > - > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. Try it! __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Views for a table
The only privilege you can grant to yourself : GRANT RTFM TO [WITH GRANT OPTION]; Igor Neyman wrote: > > Mladen, > > Any privileges required to view this table, or just common sense? :-) > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > -Original Message- > Mladen Gogala > Sent: Friday, January 23, 2004 1:24 PM > To: Multiple recipients of list ORACLE-L > > The table you want to look into is USER_OTN, Column DOCUMENTATION. > > On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: > > Hi everybody > > > > I have the following question > > > > How can I query a table's views? > > > > For example I have the table students and I want to know the views > > related to this table. > > > > Thanks, > > Mauricio V?lez > > > > > > - > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Views for a table
Mladen, Any privileges required to view this table, or just common sense? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, January 23, 2004 1:24 PM To: Multiple recipients of list ORACLE-L The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: > Hi everybody > > I have the following question > > How can I query a table's views? > > For example I have the table students and I want to know the views > related to this table. > > Thanks, > Mauricio V?lez > > > - > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Views for a table
Title: Message Query DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and referenced_type='TABLE'. -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: Views for a table Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: Views for a table
The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio V?lez - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Views for a table
Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!