Re: Oracle table listing question
From: Timo Haatainen <Timo.Haatainen_at_ttgroup.fi>
Date: 1996/04/01
Message-ID: <315FBFCA.69B6_at_ttgroup.fi>#1/1
Date: 1996/04/01
Message-ID: <315FBFCA.69B6_at_ttgroup.fi>#1/1
Jason Garing wrote:
>
> We are working with Oracle for a class project and we would like to know
> if there is a command that will give a listing of all the tables created
> only for a specified user-id???
>
> Thanks.
SELECT table_name FROM sys.all_tables WHERE owner = 'you name it';
Timo Received on Mon Apr 01 1996 - 00:00:00 CEST