How to get a list of all tables in the database?



How to get a list of all tables in the database?..

Answer / tr

select * from tab;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How to grant create session privilege to a user in oracle?

0 Answers  


if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,


How to assign a tablespace to a users in oracle?

0 Answers  


Is it possible to enter only time value into a column of a table in sql?

2 Answers  


How do you handle duplicate records in a database?

1 Answers  


master table and child table performances and comparisons in Oracle ?

0 Answers  


what is the use of rank function?

1 Answers  


What is the difference between Delete, Truncate and Drop in Oracle?

0 Answers   MCN Solutions,


I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers  


Differentiate between function and procedure in oracle.

0 Answers  


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)