Answer / kiran r

An Exception is error handling part when ever error occurs exception raises.
Exceptions are classified as
1. Predefined Exception
2.User defined exception
some of predefined Exceptions are:
NO DATA FOUND, TOO MANY ROWS, CURSOR ALREADY OPEN, INVALID CURSOR, INVALID NUMBER, ZERO DIVIDED

What is parameter substitution in sql?

0 Answers  

---

what is variable in package specification

3 Answers  

---

Explain unique key in sql.

0 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

Which is better stored procedure or query?

0 Answers  

---

Can we insert data into view?

0 Answers  

---

Explain the uses of a database trigger?

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  

---

What is a record in a database?

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---