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;

3. Steps in UAT?

2481

---

can we use lexical perameter in oracle plsql if yes how

2377

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2559

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7777

---

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?

2250

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2129

---

what are the API of GL,PO,AP

2312

---

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

2309

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1207

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1321

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1092

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2382

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1204

---

Difference between transaction type and transaction sources. : oracle accounts receivable

1073

---