Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What is the use of index in hive?

0 Answers  

---

Is sqlite thread safe?

0 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

Where do we use pl sql?

0 Answers  

---

---

Which is faster view or stored procedure?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What is bulk collections?

2 Answers  

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

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  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---