Answer Posted / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

What are the Standard Reports and Forms in HRMS?

2301

---

How can we import the data into a database using sql * loader?

1182

---

do you know is it possible to run the interface without using oracle apps?

1108

---

What do you understand by soa?

1152

---

Tell me where we find the status of order information?

1133

---

tell my any difficult situtation you solved in your experience in your company?

2315

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2376

---

In hierarchical structure of a database? we have write query from where we should start?

2238

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2044

---

how can i print random rows in plsql table

2487

---

Do you know where we can check the status of po?

1266

---

Which oracle apps version you are very confident in?

1203

---

what are the balancing segments in AR?

2090

---

How many schemas we have? how many you have used?

2058

---

q)what are the validations in sql*loader

2397

---