Answer Posted / deven

select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc

What is the difference between row level and statement level trigger?

1019

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1150

---

What are %type and %rowtype for?

1052

---

Why do we use function in pl sql?

1058

---

What plvcmt and plvrb does in pl/sql?

1319

---

How do I view a sql trace file?

1025

---

Can we insert delete data in view?

950

---

Is trigger a stored procedure?

931

---

Is primary key clustered index?

945

---

Is sql pronounced sequel or sql?

1260

---

How many tables can you join in sql?

957

---

Explain the uses of database trigger.

1112

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

954

---

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

1009

---

How to avoid using cursors?

1117

---