Answer Posted / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

What is PL/SQL ?

1110

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1582

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4666

---

What is parameterized cursor in oracle?

574

---

What is system tablespace?

630

---

---

How to change program global area (pga) in oracle?

582

---

What is null value in oracle?

630

---

How to load data from external tables to regular tables?

539

---

How would you change old and new values in an insert, delete and update triggers?

539

---

What are advantages of dateset in datastage?

1744

---

How data locks are respected in oracle?

572

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3823

---

Explain constraining triggers.

593

---

Can we convert a date to char in oracle and if so, what would be the syntax?

548

---

What is an external table?

586

---