Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Objects
Oracle Objects [message #264848] Tue, 04 September 2007 15:52 Go to next message
florida
Messages: 82
Registered: April 2006
Member
I hear the term Oracle objects alot. Are Oracle Objects considered Tables, Fields, Triggers, Sequences, Foreign Keys etc..?
Re: Oracle Objects [message #264849 is a reply to message #264848] Tue, 04 September 2007 15:54 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
SELECT DISTINCT OBJECT_TYPE FROM DBA_OBJECTS;
Re: Oracle Objects [message #264851 is a reply to message #264849] Tue, 04 September 2007 16:17 Go to previous messageGo to next message
florida
Messages: 82
Registered: April 2006
Member
Thanks I just did the query and I dont see Fields in there so it must be part of the Table object?
Re: Oracle Objects [message #264854 is a reply to message #264848] Tue, 04 September 2007 16:43 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> I dont see Fields in there so it must be part of the Table object?

I don't see anything because you chose to keep the details private to only you.

Fields? please elaborate/clarify/explain to what you refer.
"it"? I am not clear to what you refer.
"so it must be part of the Table object" - If you say so.

What problem are you REALLY trying to solve???????????????
Re: Oracle Objects [message #264917 is a reply to message #264851] Wed, 05 September 2007 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe are you talking about TYPEs?
Have a look at DBA_TYPE% views.

Regards
Michel
Re: Oracle Objects [message #264938 is a reply to message #264848] Wed, 05 September 2007 01:28 Go to previous messageGo to next message
darshanmeel
Messages: 44
Registered: June 2007
Location: India
Member

I think You dont have access to DBA_% views.Please try the same query with ALL_OBJECTS.
This might help you.

Darshan Singh
Re: Oracle Objects [message #265101 is a reply to message #264848] Wed, 05 September 2007 07:33 Go to previous message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Did you mean this

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96594/adobjint.htm
Previous Topic: need help in PLSQL
Next Topic: procedure to find out how many times a perticular character is present in a ginen string
Goto Forum:
  


Current Time: Thu Dec 08 10:08:18 CST 2016

Total time taken to generate the page: 0.06877 seconds