Answer Posted / debasish sinha

create or replace trigger trg_sun
before insert on <table name>
begin
if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then
raise_application_error(-20345,'no transaction in sunday');
end if;
end trg_sun;

Is sqlexception checked or unchecked?

541

---

What is the importance of sqlcode and sqlerrm?

851

---

What is sql trigger example?

541

---

What is using in sql?

568

---

How many sql statements are used? Define them.

576

---

---

What is sql*loader?

576

---

Explain commit, rollback and savepoint.

607

---

Does sql*plus also have a pl/sql engine?

563

---

Can you rollback after commit?

532

---

Can we use commit inside a trigger?

529

---

How to add, remove, modify users using sql?

560

---

Will truncate release space?

517

---

How do you optimize a stored procedure query?

566

---

Is join and inner join the same?

543

---

what is bcp? When does it used? : Sql dba

526

---