Answer Posted / murali

select level,max(sal) from emp where level=&levelno connect by prior sal>sal group by level;

What do you know by pl/sql cursors?

1035

---

How exception handling is done in advance pl/sql?

918

---

How do I count records in sql?

943

---

What is scope and visibility in PL/SQL?

1114

---

Can we alter stored procedure?

943

---

What is a pragma statement?

1201

---

Can you join a table to itself?

1030

---

how would you enter characters as hex numbers? : Sql dba

936

---

Why stored procedures are faster than query?

969

---

What is cursor in pl sql?

1050

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1035

---

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

958

---

what is unique key constraint? : Sql dba

991

---

what is the different between now() and current_date()? : Sql dba

934

---

Explain the purpose of %type and %rowtype data types with the example?

926

---