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 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,

---

What is sql engine in oracle?

0 Answers  

---

What is localdb mssqllocaldb?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

Can we use view in stored procedure?

0 Answers  

---

What is trigger in sql and its types?

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Which command is used to call a stored procedure?

0 Answers  

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

---