What is a stored procedure ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 6/8/07
It is named pl/sql block that can accept parameters to
perform an action and is stored in database is called
stored procedure
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / charumathi
Store Procedure is named PL-SQL block stored in oracle
server when loaded into memory while execution.
A stored procedure is -a named group of SQL statements
-that have been previously created
and stored in the server database.
-Stored procedures accept input
parameters so that a single procedure can be used over the
network by several clients using different input
data.
-Stored procedures reduce network
traffic and improve performance. Additionally, stored
procedures can be used to help ensure the integrity of the
database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajeev
NAMED PL/SQL BLOCK STORED IN ORCALE SERVER , CAN ACCEPT
PARAMETERS AND CAN BE INVOKED REPEATDLY BY NAME .
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / uday
Sp is nothing but Group of T-Sql Statments compiled into a
single execution plan.
Sy: create procedure Pname
{@parameter1 datatype,@parameter2.........)
as
SQL Statments
end
Plz let me know if i am wrong
uday_testing@yahoo.co.in
Is This Answer Correct ? | 0 Yes | 0 No |
Is left join and outer join same?
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')
How many clustered indexes can you have?
How many types of indexes are there in sql?
what is cursor procedure
How to sort the rows in sql.
What can you do with pl sql?
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
Does sqlite need a server?
write a query to delete similar records in same table
how is exception handling handled in mysql? : Sql dba
What is difference between cursor and ref cursor?