Answer Posted / sujeet sinha

SELECT DISTINCT (a.sal) FROM EMP A WHERE 2 = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

What's dateware house and what's clustor with practicle example

1637

---

How to assign data of the deleted row to variables?

579

---

What are the different pseudo commands? Explain in general?

539

---

What are the different types of record groups in oracle? Explain each of them

600

---

Give the different types of rollback segments.

578

---

---

What is a trigger and what are its types in oracle?

532

---

Why do we need oracle client?

509

---

How to define a data source name (dsn) in odbc manager?

525

---

What are the roles of dba?

612

---

What is enter substitution variable in oracle?

570

---

How to generate query output in html format?

563

---

List out the components of logical database structure of oracle database.

583

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2594

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

551

---

How to drop a tablespace?

568

---