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

What is rank dense_rank and partition in sql?

1043

What are pl/sql cursor exceptions?

1110

What is the purpose of my sql?

953

What is the plv (pl/vision) package offers?

1054

How does one use sql*loader to load images, sound clips and documents? : aql loader

1188

Are dml statements autocommit?

1048

What is sql not null constraint?

1042

what is a control file ? : Sql dba

1045

How do you optimize a stored procedure in sql?

960

Is crud a cuss word?

1036

What is scalar data type in pl sql?

1074

what are the nonstandard string types? : Sql dba

1144

How insert into statements in sql?

1080

Is sql better than excel?

1158

What is error ora-01000: maximum open cursors exceeded

1148