Answer / kiran kumar

FlexRpt The execution file is wrnitten using the
FlexReport API.

FlexSql The execution file is written using the FlexSql API.

Host The execution file is a host script.

Oracle Reports The execution file is an Oracle Reports file.

PL/SQL Stored Procedure The execution file is a stored
procedure.

SQL*Loader The execution file is a SQL script.

SQL*Plus The execution file is a SQL*Plus script.

SQL*Report The execution file is a SQL*Report script.

Spawned The execution file is a C or Pro*C program.

Immediate The execution file is a program written to
run as a subroutine of the concurrent manager. We recommend
against defining new immediate concurrent programs, and
suggest you use either a PL/SQL Stored Procedure or a
Spawned C Program instead.



Composite Datatypes :
? PL/SQL TABLES
? PL/SQL RECORDS
- Nested TABLE
- VARRAY

What is ERP? Architecture of apps?

3 Answers   TCS,

---

Can u define exceptions twice in same block?

3 Answers  

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

In one flat file i got headers and lines data how you can write control file now ?

1 Answers   KPMG,

---

what is the difference between procedure and function

4 Answers  

---

The report output is 10 pages then how many times between pages report trigger will fire?

1 Answers   IBM,

---

What are profile options?

4 Answers   Accenture,

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

in procedure how to return a value

2 Answers   Wipro,

---