Home » SQL & PL/SQL » SQL & PL/SQL » about Create table
about Create table [message #20498] Thu, 30 May 2002 02:22 Go to next message
yram
Messages: 75
Registered: February 2001
Member
hi

Can u let me know from which table or view is used to display the message TABLE CREATED after my table is created successfully.

pls help me.

regards
yram
Re: about Create table [message #20532 is a reply to message #20498] Sun, 02 June 2002 17:27 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
I am not ready understand your quation. However, after table is created. you can find this table in this view ...

-- all users
select * from tab;

-- owner of the table
select * from user_tables;

-- access table by user
select * from all_tables;

-- dba (all table)
select * from dba_tables;

hope this is helping. Thanks
Previous Topic: Re: working with dates
Next Topic: URGENT help with a procedure
Goto Forum:
  


Current Time: Wed Apr 24 20:08:16 CDT 2024