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
Explain user account with reference to oracle.
What is a cursor in oracle?
What do you understand by a database object? Can you list a few of them?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Can we store pictures in the database and if so, how it can be done?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is a trigger and what are its types in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is a cursor variable?
How many types of tables are there in oracle?
What are the logical operations?
How do I find my oracle client driver version?
What is the usage of synonyms?
What are dml statements in oracle?
