Answer / surya

Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.

The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:

SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;

What is serial sql?

0 Answers  

---

What are sql queries used for?

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

What are different types of keys?

0 Answers  

---

Is sql an operating system?

0 Answers  

---

discuss about myisam key cache. : Sql dba

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 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  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

What are different joins used in sql?

0 Answers  

---