Answer / Dharmandra Datt Yadav

1. Expected exceptions: These are user-defined exceptions that are expected to occur during execution, and their handling is specified using a BEGIN-EXCEPTION block or a RAISE statement. 2. Unexpected exceptions: These are unanticipated errors that are not part of the program's normal flow, and they can cause the entire PL/SQL block to terminate abruptly.

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

What are the pre requisites?

1 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

what does it mean to have quoted_identifier on? : Sql dba

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,

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

What is the difference between the sql*loader and import utilities? : aql loader

1 Answers  

---

what are enums used for in mysql? : Sql dba

1 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 Answers  

---

Is sql between inclusive?

1 Answers  

---

why we use nocopy?

2 Answers   Polaris,

---