Answer Posted / kd

"select substr(ename,-5)as name from emp " is not right
because you will get no name if the ename is shorter than 5
letters.
right way:
select reverse (substr (reverse(ename), 1, 5))
from emp;

Is there any link between pr form(purchse requisition)and po form(purchase order)

2727

---

How would you determine what sessions are connected and what resources they are waiting for?

2127

---

What view would you use to determine free space in a tablespace?

2224

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2864

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2026

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3936

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

---

1. What is PO rate variance gain and loss?

2920

---

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2186

---

What is the disk migration? what is the steps involved in oracle disk migration?

1222

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2073

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

---

Explain about party and customer in ar : oracle accounts receivable

1211

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2216

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3581

---