What is store procedure?and how do u take the values from database and run in

What is store procedure?and how do u take the values from
database and run in scripts?

Question Posted / rajesh

2 Answers
5430 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is store procedure?and how do u take the values from database and run in scripts?..

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.

Is This Answer Correct ?

6 Yes

2 No

What is store procedure?and how do u take the values from database and run in scripts?..

Answer / dsr

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

begin

start

end.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

what is different between inline query,subquery& corelated query?

8 Answers Quest,

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers

8. Supporting AP, AR and GL?

0 Answers Oracle,

What is an Oracle database Partial Backup?

0 Answers

Describe what redo logs are.

1 Answers

what is sql*loader parameters and where we will use it.

1 Answers Accenture,

What Are Cross Validation & Adi?

0 Answers Oracle,

Give the reasoning behind using an index.

2 Answers

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers

For more Oracle AllOther Interview Questions Click Here