how to see the oracle 9i/10g table in pc?
or
In my pc where the table is saved and how to see?
Answer / jp
select * from user_objects where object_type='TABLE';
TABLE IS CAPS
| Is This Answer Correct ? | 6 Yes | 0 No |
Why truncate is used in sql?
What are two parts of package ?
What does varchar include?
What are tables in sql?
Explain UNION,MINUS,UNION ALL, INTERSECT?
How to find 3rd highest salary of an employee from the employee table in sql?
Define the select into statement.
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
What is number function in sql?
What is pseudo column ?
How can I get the number of records affected by a stored procedure?
What are the different types of sql commands?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)