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 loop in pl sql?

565


what is oltp (online transaction processing)? : Sql dba

525


How is indexing done in search engines?

523


Are dml statements autocommit?

543


What is file based approach?

483






Which command is used to call a stored procedure?

489


Why plvtab is considered as the easiest way to access the pl/sql table?

606


What is string join?

546


What are the parts of a basic sql query?

503


How can the performance of a trigger be improved?

585


Why cross join is used?

622


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

579


What is record in pl sql?

587


What is the difference between join and natural join?

466


How do I find duplicates in a single column in sql?

524