Interested to Buy Any Domain ? << Click Here >> for more details...
what are stored procedures?
- 7 Answers
- 26880 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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 |
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
State all possible different index configurations a table can possibly have?
Which environment variables are absolutely critical in order to run the OUI?
How to call a stored function with parameters?
candidate key is subset of super key but not vice-verse explain
How can we find out the duplicate values in an oracle table?
what is the difference between authorization and authentication?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Can we save images in a database and if yes, how?
How to select the name of employee who is getting maximum sal with out using subquery
Draw E-R diagram for many to many relationship ?
Whats the benefit of dbms_stats over analyze?
Oracle General 
