stored procedure is a named pl/sql block which accept some parameter and

What is a stored procedure ?

Question Posted / rajesh

Answer Posted / rajesh

stored procedure is a named pl/sql block which accept some
parameter and performs some action....and its a one time
compilation....

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use the cursor's to create the collection in PL/SQL?

1025

how to rename an existing table in mysql? : Sql dba

1064

How does index help in query performance?

1028

how to convert numeric values to character strings? : Sql dba

1105

What problem one might face while writing log information to a data-base table in pl/sql?

1164

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What is primary key secondary key alternate key candidate key?

1037

What is a temporal data type?

1052

Why do we create stored procedures & functions in pl/sql and how are they different?

944

What are database links used for?

1046

How is data stored in sql?

1058

Can we alter stored procedure?

987

What is pl sql script?

1030

Why indexing is needed?

983

Why do we need cursors in pl sql?

1078