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

Answer Posted / jp

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

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind reference and how can it be created?

771


What is difference between db2 and sql?

721


what are aggregate and scalar functions? : Sql dba

736


How to make a copy values from one column to another in sql?

769


What is auto increment in sql?

825






What is difference between group by and partition by?

688


Can one improve the performance of sql*loader? : aql loader

775


What is cursor and its types?

716


Explain what is an index?

759


write an sql query to find names of employee start with 'a'? : Sql dba

775


Which one is better subquery or joins?

775


What do you mean by rowid?

708


How many types of triggers exist in pl/sql?

730


How many sql statements are used?

748


Write a sql select query that only returns each name only once from a table?

759