 | |
differentiating between tables and views
comp.database.oracle comp.database.oracle
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
differentiating between tables and views -
02-29-2004
, 06:49 PM
#2
| |||
| |||
|
|
Using Oracle release 902000100. Assuming I don't have a tool like TOAD how could I tell if what I am using is a view or table? Is there a way to get at the view definition? I have access to sys user id Thanks J. |
#3
| |||
| |||
|
|
In the query below, replace <owner> with the name of the object's owner, and replace <object> with the name of the object: select object_type from all_objects where owner = '<owner>' and object = '<object>' -- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, OCP, CIW ___________________________________ "UNIXNewBie" <nospan (AT) nospam (DOT) com> wrote in message news:FPmdnQGkLcAXFd_d4p2dnA (AT) magma (DOT) ca... Using Oracle release 902000100. Assuming I don't have a tool like TOAD how could I tell if what I am using is a view or table? Is there a way to get at the view definition? I have access to sys user id Thanks J. |
#4
| |||
| |||
|
|
Thanks "Chris Leonard" <s_p_a_m_chris (AT) hotmail (DOT) com> wrote in message news:cjM0c.37$Oz6.64608 (AT) news (DOT) uswest.net... In the query below, replace <owner> with the name of the object's owner, and replace <object> with the name of the object: select object_type from all_objects where owner = '<owner>' and object = '<object>' |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.