What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 24265 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / s. elaiyaraja
The Main difference between stored procedure and Function
is SP's can return the value or not, but Functions should
return the value.
And We can use the function within the Queries, but sp's we
won't able to use it in the queries.
We can implicitely execute the sp's. But function's we
can't.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How do I know if oracle client is installed on windows?
What privilege is needed for a user to connect to oracle server?
How to create a new tablespace in oracle?
How to select an oracle system id (sid)?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to start instance with a minimal initialization parameter file?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to store pictures on to the database?
Point out the difference between user tables and data dictionary?
Query to retrieve record for a many to many relationship ?
How to define a variable to match a table column data type?
How to define a variable of a specific record type?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What do you mean by merge in oracle?
