Home » SQL & PL/SQL » SQL & PL/SQL » View
icon5.gif  View [message #249589] Thu, 05 July 2007 02:18 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi all,

I have one table..but i wnt to chk whether tht table contains view or not? and it shows the view name also

Is there any Dictionary table?

For eg: Just i give the table name then i will get the view name
Re: View [message #249591 is a reply to message #249589] Thu, 05 July 2007 02:22 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You could query user_dependencies, but since your letter 'a' seems to be failing, it will be difficult..
Re: View [message #249598 is a reply to message #249591] Thu, 05 July 2007 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Re: View [message #249618 is a reply to message #249598] Thu, 05 July 2007 03:56 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

may be difficult but user_dependencies doesn't have letter 'a'. Laughing
Re: View [message #249678 is a reply to message #249618] Thu, 05 July 2007 09:35 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ok, you show me how he can query that view in a useful way without using the 'a'...


P.S. Don't bother to try... this is way O/T

[Updated on: Thu, 05 July 2007 09:37]

Report message to a moderator

Previous Topic: How to download oracle table data in an Excel Sheet Using Java
Next Topic: idle instance with / but working instance with full string
Goto Forum:
  


Current Time: Sat Dec 03 17:57:29 CST 2016

Total time taken to generate the page: 0.05276 seconds