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;

What is an Oracle database Partial Backup?

1151

---

What is Restricted Mode of Instance Startup in Oracle?

1191

---

What are different types of transactions in ar? : oracle accounts receivable

1283

---

Where in the Oracle directory tree structure are audit traces placed?

2629

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2459

---

key flexfield structure

2166

---

Explain the payment term in ar. : oracle accounts receivable

1101

---

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

2211

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

1327

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2507

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1164

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2258

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1768

---

Are These Dff's Flexible?

1164

---

How many segment are present in Oracle Manufacturing

2311

---