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 are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1029

---

What is pl sql block in dbms?

995

---

Write a sql query to get the third highest salary of an employee from employee_table?

1065

---

How does sql*loader handles newline characters in a record? : aql loader

1036

---

how do you login to mysql using unix shell? : Sql dba

1072

---

What is the purpose of primary key?

1012

---

What are variables in pl sql?

1154

---

Can we create view in stored procedure?

953

---

What is an inner join sql?

1021

---

Explain commit, rollback and savepoint.

989

---

Why sql query is slow?

978

---

What is the difference between mdf and ndf files?

1110

---

Which constraints we can use while creating database in sql?

1066

---

Explain the significance of the & and && operators in pl sql.

1001

---

How to find 3rd highest salary of an employee from the employee table in sql?

1074

---