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  

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

what are local and global variables and their differences? : Sql dba

0 Answers  

---

What does varchar include?

0 Answers  

---

What is a sql driver?

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

Is primary key a clustered index?

0 Answers  

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

How do you create a db file?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What does pl sql stand for?

0 Answers  

---