Answer Posted / guru

The PRAGMA EXECPTION_INIT tells the complier to associate an
exception with an oracle error. To get an error message
of a specific oracle error.

e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error
number)


Example

declare
salary number;
FOUND_NOTHING exception;
Pragma exception_init(FOUND_NOTHING ,100);
begin
select sal in to salaryfrom emp where ename ='ANURAG';
dbms_output.put_line(salary);
exception
WHEN FOUND_NOTHING THEN
dbms_output.put_line(SQLERRM);
end;

What does where 1/2 mean in sql?

1048

---

What jobs use sql?

966

---

Can we change the table name in sql?

925

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

939

---

Can we use two order by clause in query?

948

---

Why truncate is faster than delete?

1088

---

What are the built in functions of sql?

1014

---

Show the two pl/sql cursor exceptions.

1165

---

Define select, insert, create, delete, update, drop keywords

1035

---

Sql technical questions

1251

---

What are stuff and replace function?

1063

---

Can you sum a count in sql?

985

---

what is a trigger? : Sql dba

1009

---

What is rank function in sql?

997

---

What is difference between joins and union?

1101

---