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
5633 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 the Symbol use for Inner Join

1 Answers Oracle, TCS,

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers

How to clone the database using RMAN back

0 Answers

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers

please explain about oracle

1 Answers

What is auto invoicing? : oracle accounts receivable

0 Answers

How can you rebuild an index?

1 Answers

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers

What view would you use to determine free space in a tablespace?

0 Answers

what are basic modules required to implement oracle application in any oraganisation?

0 Answers

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers

For more Oracle AllOther Interview Questions Click Here