difference b/w procedures&functions
Answers were Sorted based on User's Feedback
Answer / abhi choudary
procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / raghu
procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written
Is This Answer Correct ? | 3 Yes | 1 No |
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
explain p2p cycle? what are the tables used for this?
where u do setup of operating unit?
please explain open interface import
What is GLOBAL TEMPORARY TABLE and It's significance ?
What is a value set? List its various types.
which API to return the parameters & valuesets etc
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
do i need to declare bind parameter before using in the query?
Can we create tables in apps schema?
what are the match approvals in PO?