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 can i read files from a pl/sq l program

3 Answers  

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

What are two statement types in sql?

0 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Can we group by two columns in sql?

0 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---