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
what are actual and formal parameters?
what is the use of system.effective.date variable in oracle?
What is an oracle?
Can we use bind variables in oracle stored procedure?
How to use subqueries in the from clause in oracle?
Explain the use of consistent option in exp command.
What do you mean by group by clause?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Query to retrieve record for a many to many relationship ?
Is there a function to split a string in plsql?
How a tablespace is related to data files?
How to list all indexes in your schema?
How to turn on or off recycle bin for the instance?
How to use existing values in update statements using oracle?
definition of cluster and non-clustered index?
