Answer / kiran r

A Trigger is block of PLSQL Code which is automatically Executed with response to some events (i.e.., DML).

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

what is a primary key? : Sql dba

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

What is the process of copying data from table a to table b?

0 Answers  

---

What is the Subquery?

4 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... 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;

2 Answers  

---

How to disable a trigger name update_salary?

0 Answers  

---

What is thread join () in threading?

0 Answers  

---

How do I create a sql script?

0 Answers  

---

How do I run a query in pl sql developer?

0 Answers  

---