If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

What is composite data type in pl sql?

0 Answers  

---

How do I kill a query in postgresql?

0 Answers  

---

How can you load multi line records? : aql loader

0 Answers  

---

---

Is left join faster than join?

0 Answers  

---

Explain what is an index?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

What is pl sql code?

0 Answers  

---

What is dynamic sql in pl sql?

0 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  

---