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;

Why do we use sqlite?

962

---

What does stand for in sql?

960

---

explain mysql aggregate functions. : Sql dba

980

---

Define commit?

991

---

difference between anonymous blocks and sub-programs.

1126

---

What do you mean by stored procedures?

1004

---

How do I partition a table in sql?

1116

---

how to add a new column to an existing table in mysql? : Sql dba

1061

---

What is a memo field?

958

---

What is the difference between view and stored procedure?

956

---

How do I edit a trigger in sql developer?

988

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2475

---

What is assignment operator in pl sql?

1026

---

Compare sql & pl/sql

1120

---

How to make a copy values from one column to another in sql?

1028

---