what are stored procedures?
Answers were Sorted based on User's Feedback
Answer / suresh
Stored Procedure are the precomplied set of sql command.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pushpa
stored procedures means containing a precompiled block of
code.
if we call stored procedures they need not compiled,only
execution takes place.
with this advantage ,work on database is less.
with these sps we can perform business logics.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / akn
Its nothing but a set of T-SQL statements combined to
perform a single task of several tasks. Its basicaly like a
Macro so when you invoke the Stored Procedure,you actually
run a set of statements
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jyoti ranjan samal
Store procedure can invoke DDL&DML statement and can return
value.
2.You can also execute one procedure to another procedure.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sapna kalburgi
Stored procedure is a set of SQL statements used to perform
some particular task.
Is This Answer Correct ? | 0 Yes | 0 No |
1. Store procedure may or may not return a value. If we want to return a value then we need to pass the parameters like INPUT & OUTPUT parameters
2. It can allowed SELECT/INSERT/UPDATE/DELETE Statements. It can be change state of table.
3. It can call Functions, Views, and Procedures inside procedures.
Is This Answer Correct ? | 0 Yes | 0 No |
what is the syntax of CREATE command?
What is data block in Oracle?
Explain the use of parfile option in exp command.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
create one table to capture an employee details with a primary key.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to load excel data sheet to oracle database
What is meant by an index?
How to convert csv to table in oracle?
What is transport network substrate (tns) in oracle?
What happens if you lost a data file?
How to write an inner join with the where clause in oracle?