Answer Posted / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

How do I find duplicates in two columns?

552

---

Why sql query is slow?

577

---

What is dense_rank in sql?

544

---

Explain the the delete statements in sql?

579

---

How many joins can you have in sql?

520

---

---

what are date and time intervals? : Sql dba

566

---

How do I copy a table in sql?

517

---

How you improve the performance of sql*loader? : aql loader

579

---

Explain the insert into statements in sql?

565

---

What is sharding in sql?

565

---

What is meant by truncate in sql?

522

---

How to Declare Fixed Length String Value In PL SQL

663

---

How to fix oracle error ora-00942: table or view does not exist

568

---

Are stored procedures faster than queries?

523

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

524

---