Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26732 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / abapdeveloper09
Adding to S. Elaiyaraja's responnse:
- Functions should have RETURN clause
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to concatenate two text values in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to call a stored function with parameters?
What are the arithmetic operations?
WHAT IS ecc 6.0
Difference between inner join vs where ?
what are archived logs?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Can group functions be mixed with non-group selection fields?
How to add a new column to an existing table with a default value?
What is the simplest tool to run commands on oracle servers?
Does facebook use oracle?
Differentiate between function and procedure in oracle.
What is a directory object?
