Answer Posted / guru

stored procedure : It is Pre Compiled Code(PCode) it is stored
in Database. we can reuse without compile.

Function: It need compile whenever it will run.

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1654

---

What are group functions in oracle?

1038

---

How to export data with a field delimiter?

1037

---

Is rowid unique in oracle?

997

---

Can group functions be mixed with non-group selection fields?

1018

---

How would you change old and new values in an insert, delete and update triggers?

1015

---

Explain the use of analyse option in exp command.

1124

---

What are the differences between char and nchar in oracle?

1086

---

How to declare a local variable?

1109

---

How to create a temporary table in oracle?

1264

---

How do you store pictures in a database?

1001

---

What is the difference between a hot backup and a cold backup in oracle?

1013

---

Can you create a synonym without having a table?

1038

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1688

---

What are the execution control statements?

1063

---