Answer Posted / joseph p v

I think your question is as follows.
I need an exception in pl/sql block so that if any errors
occur in the block then no exception should raise?

For that see the below code part :-

exception
when others then
null;

--Example
declare
cha char(5):='TEST';
num number;
begin
num := cha;
exception
when others then null;
end;

What is the difference between numeric and autonumber?

939

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1130

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

---

What is the difference between stored procedure and view?

963

---

What is clustered index sql?

931

---

what is the difference between join and union? : Sql dba

1028

---

How do you add a column to a table?

995

---

how to show all tables with 'mysql'? : Sql dba

1059

---

Which is faster count (*) or count 1?

964

---

List out the acid properties and explain?

904

---

how do you know the version of your mysql server? : Sql dba

936

---

What is the usage of when clause in trigger?

990

---

Why do you partition data?

966

---

How can we optimize a sql query?

982

---

What is pl sql block structure?

974

---