Answer Posted / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

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

1056

---

What are the types of variables use in pl sql?

1001

---

What are triggers and its types?

1020

---

What are its different types of dbms?

981

---

What is a data definition language?

1053

---

What is the use of sqldataadapter?

928

---

Which version of sql do I have?

1023

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1025

---

Which is better stored procedure or query?

940

---

What is consistency?

1081

---

What is the use of nvl function?

1146

---

Can a trigger call a stored procedure?

1030

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

979

---

Can we use delete in merge statement?

1021

---

How is a process of pl/sql compiled?

1111

---