Answer / narenkumar reddy

create or replace
trigger trigger_name
before update on emp
for each row
begin
if job<>'salesman' then
raise_application_error(-20001,'should never receive the
commission')
end if;
end;

What is the difference between a query and a report?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

What is trigger in sql? Explain

0 Answers  

---

What is difference between stored procedure and trigger?

0 Answers  

---

what are the t string functions available in tsql? : Transact sql

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

What is ON DELETE CASCADE?

3 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

what is a cursor? : Sql dba

0 Answers  

---