Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined stored procedures ?
- 3 Answers
- 13357 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anbu
Stored procedures is like a simple PLSQL/instructions
programme which can perform desired operation to get the
exact output from the oracle server(if the DB is oracle).
The user defined stored proceture can be created by users
and they can use funtions,procedure and packages to get the
output from the database engine.
The next thing is they can call it at any part in the
main programme.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / s.aravindhna
Microsoft SQL Server provides the stored procedure
mechanism to simplify the database development process by
grouping Transact-SQL statements into manageable blocks.
Benefits of Stored Procedures
Why should you use stored procedures? Let's take a look at
the key benefits of this technology:
Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
Efficient reuse of code and programming abstraction. Stored
procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
Stored procedures are very similar to user-defined
functions, but there are subtle differences. For more
information, read Comparing Stored Procedures and User-
Defined Functions.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rishi anand
Stroed procedures are basically set of sql statements.User
defined stored procedures are created by users in which
they can use functions,procedures to get the desired result
from database.
| Is This Answer Correct ? | 4 Yes | 2 No |
What is PL/SQL table ?
How to return multiple rows from the stored procedure?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
What is rename in sql?
What is the use of & in pl sql?
what are the properties and different types of sub-queries? : Sql dba
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
How is debugging done?
What is sql dialect?
how can you see all indexes defined for a table? : Sql dba
What packages(if any) has oracle provided for use by developers?
What are pl/sql cursors?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
