Why do we need cursors in pl sql?

0 Answers  

---

What is varchar data type in sql?

0 Answers  

---

Why do we use procedures?

0 Answers  

---

What is a column in a table?

0 Answers  

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

What are inner and outer joins examples of both?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

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  

---

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,

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---