Answer / amit shrivastava

Stored Procedure store in the database as a independent
obejct and can call directly with proc name.

begin
proc_ex (e_name,e_no);
end;

Answer / saleem

Stored procedure is a sequence of statements that perform
specific function.

Answer / kranthi

A stored Procedure is the one which is stored in the
database in a compiled format.Can be used directly as it is
in compiled format.

Answer / sannidhi84

it is a set of sql statements ...where all dml operations
can be done and dql operations as welll...it is stored in
database as compiled format.

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

0 Answers   IBM,

---

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,

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

---

what r the objects u have to do in u experiance

1 Answers  

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

AOL?

4 Answers  

---

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

What are the tables in GL?

3 Answers   Convergys,

---

what is the use of anchors?

2 Answers   IBM,

---

what is pay run id ?

0 Answers  

---