Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rocky-455
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 |
Post New Answer View All Answers
How to delete a user account in oracle?
How to specify default values in insert statement using oracle?
Explain index?
Is insert autocommit in oracle?
List out the types of joins.
What is a relational database management system?
How to get execution statistics reports on query statements?
How do we get field details of a table?
How remove data files before opening a database?
What is a partition in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to create an oracle database manually?
What are the different pseudo commands? Explain in general?
how to clone 9i Database on to 10g Database.
why dont we assign not null constraint as table level constraint.
