Answer / hari

it is a stored pl/sql block that is used to perform an
action.And it may or may not return values .

parameters are in,out,in out.

we will take the values from parameters.

Answer / dsr

Store Procedure is a procedure. it may or maynot return values.
Ex: create procedure procedure_name

begin

start

end.

Explain materialized views and how they are used.

2 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

how to create an user in oracle 10g.please give me an example..

1 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

What is the disk migration? what is the steps involved in oracle disk migration?

0 Answers  

---

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers  

---

How do you resize a data file?

2 Answers  

---

How client makes connection with server in client/server architecture?

1 Answers   CA,

---

How can you enable a trace for a session?

2 Answers  

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

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?

0 Answers   Cap Gemini,

---