Answer / Ritu Rana

PL/SQL (Procedural Language SQL) is a procedural extension of the SQL language. It allows developers to write complex business logic, control structures, and error handling within database stored procedures.nnPL/SQL is primarily used for managing and manipulating data in Oracle databases. It is essential for building Oracle applications because it enables writing more complex logic than plain SQL and can execute multiple SQL statements within a transaction.nnIn addition, PL/SQL provides powerful features like cursors, exceptions, triggers, and sequences that make it an ideal choice for developing high-performance database applications.

Can we connect to postgresql using sql developer?

1 Answers  

---

What is a primary key called that is made up of more than one field?

1 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

Can we use two order by clause in query?

1 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is group by in sql?

1 Answers  

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

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 ?

1 Answers  

---

Which sql statement is used to delete data from a database?

1 Answers  

---

What does select top 1 do in sql?

1 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---