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.

What type of index should you use on a fact table?

1 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,

---

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

---

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

How can you enable a trace for a session?

2 Answers  

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---