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 |
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
Explain the dml?
What is a Shared SQL pool ?
How to create a temporary table in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to call a stored function with parameters?
What is the difference between truncate & delete command?
can u plz provide me oca sql dumps please i need them
How to invoke the data pump export utility?
What is the implicit cursor in oracle?
Can a property clause itself be based on a property clause ?