Home » Other » Training & Certification » tables and users
tables and users [message #279491] Thu, 08 November 2007 15:21 Go to next message
martiball10
Messages: 1
Registered: November 2007
Junior Member
I need some help with my homework...
i cant figure out how to do these two problems...
7. Display all TABLES in DBA_TABLES that are in TABLESPACE CIS4740. Only the table name.
8. Display all USERS in the DBA_USERS table that have CIS4740 as a DEFAULT_TABLESPACE.
I know part of it is select * from dba_users; but i dont knwo how to specify the tablespace
thanks for the help in advance!
Re: tables and users [message #279496 is a reply to message #279491] Thu, 08 November 2007 16:32 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.dbforums.com/showthread.php?t=1624220
Re: tables and users [message #279497 is a reply to message #279496] Thu, 08 November 2007 16:37 Go to previous messageGo to next message
djayatosu
Messages: 6
Registered: September 2007
Location: USA
Junior Member

laughing my a$$ off!
Re: tables and users [message #279592 is a reply to message #279491] Fri, 09 November 2007 04:37 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did it ever occur to you that it might take you less trouble to find these answers yourself instead of posting it to every forum that has even the slightest relation to Oracle?
Previous Topic: Need to pick the 3rd largest(maximum) val from a table
Next Topic: Oracle Scope
Goto Forum:
  


Current Time: Sat Dec 03 14:20:59 CST 2016

Total time taken to generate the page: 0.06422 seconds