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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you go about increasing the buffer cache hit ratio?

2251


can we use lexical perameter in oracle plsql if yes how

2074


How would you determine who has added a row to a table?

2038


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1885


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

809


Difference between negative and positive adjustments : oracle accounts receivable

829


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1792


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

1993


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1856


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1890


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?

2175


What is auto invoicing? Explain : oracle accounts receivable

809


What are different types of receipt reversals ? Explain them : oracle accounts receivable

977


key flexfield structure

1866


Differentiate between transaction type and transaction source? : oracle accounts receivable

873