What are user defined stored procedures ?
Answer Posted / 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 |
Post New Answer View All Answers
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is recursive stored procedure?
how to shutdown mysql server? : Sql dba
Can we write ddl statements in functions?
What is range partitioning?
Does oracle use sql?
What is the life of an sql statement?
Which are the different character-manipulation functions in sql?
What is equi join in sql?
Can we insert data into view?
How to raise user-defined exception with custom sqlerrm ?
Why do we use joins?
Which is better varchar or nvarchar?
What is clustered and nonclustered index in sql?
What is dense_rank in sql?