select count(*) from tab;

how to get count of tables in particular database in Oracle?

Question Posted / abc

Answer Posted / abc

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain rename?

976

How to turn on or off recycle bin for the session?

1105

How can Oracle users be audited?

1110

How to export data to a csv file?

1301

How to write numeric literals in oracle?

1182

How to add another datafile to a tablespace?

1040

In oracle there is column command, how will you explain that?

1050

Describe the types of sub query?

993

what are the advantages of running a database in archive log mode?

2202

Where is the export dump file located?

1148

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

Give syntax for SQL and ORACLE joins.

1092

Can the query output be sorted by multiple columns in oracle?

992

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

1129

What is SQL Tuning Advisor in Oracle?

1175