select * from user_objects where object

how to see the oracle 9i/10g table in pc?
or
In my pc where the table is saved and how to see?

Question Posted / jp

Answer Posted / jp

select * from user_objects where object_type='TABLE';
TABLE IS CAPS

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select random rows from a table?

1060

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1245

How many types of literals are available in pl sql?

1096

what is msql? : Sql dba

967

What is information schema in sql?

1053

Can we create table inside stored procedure?

937

Explain unique key in sql.

987

What is right join sql?

950

Why do we need sharding?

976

What program will open a mdb file?

948

Why do we need databases?

1021

What is a data definition language?

1078

What is use of trigger?

908

What are all the different normalizations?

1020

What is trigger and how to use it in sql?

1006