What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 24241 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / preethi
another important difference between procedure and function
is inside procedure we can use DML statements but inside the
function only select can be used not delete and update.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is where clause in oracle?
Where do we use decode and case statements?
What are the varoius components of physical database structure of oracle database?
How to assign values to data fields in record variables?
How to store only time; not date and time?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is Virtual Private Database in Oracle?
What is the difference between formal parameters and actual parameters?
How remove data files before opening a database?
Why cursor variables are easier to use than cursors?
What are the differences between interval year to month and interval day to second?
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.
What happens to the current transaction if a ddl statement is executed?
What do you mean by a deadlock?
What is analyze command used for?
