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;

Is clustered index a primary key?

0 Answers  

---

how to use like conditions? : Sql dba

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

What is dml and ddl?

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

What are analytic functions in sql?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What is a record in a database?

0 Answers  

---

what is timestamp in mysql? : Sql dba

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

What are schema-level triggers?

0 Answers  

---