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 materialized view in Oracle?
what is the syntax of SELECT command?
What are advantages fo Stored Procedures?
Explain the use of rows option in imp command.
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
What is SQL Tuning Advisor in Oracle?
Are truncate and delete commands same? If so why?
What is the usage of synonyms?
Explain can a view based on another view?
How to convert a date to char in oracle? Give one example.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is the use of Redo Log Information ?