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 do you modify a column in sql?

0 Answers  

---

What is before trigger?

0 Answers  

---

Explain dml and ddl?

0 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

what is data control language? : Sql dba

0 Answers  

---

Which is better varchar or nvarchar?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---