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 |
What is the difference between local variables and global variables?
What is numeric function sql?
in table there r so many rows write a query which two rows r updated last two day befor?
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
IF i write before / after insert / update trigger and i do rollback what will happen?
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
How many clustered indexes can you have?
How do you delete duplicates in sql query using rowid?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
what is the difference between stored procedure and packaged procedure
Can we create foreign key without primary key?
How many joins can you have in sql?