Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26671 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
How do you find current date and time in oracle?
What is an oracle recycle bin?
What is the data pump import utility?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Can the query output be sorted by multiple columns in oracle?
What are the major difference between truncate and delete?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to rename a tablespace in oracle?
How to write a query with a right outer join in oracle?
What is background process in Oracle?
Explain the features of oracle?
How to assign values to variables?
Explain alias?
What happens to the current transaction if the session is killed?
How to write date and time interval literals in oracle?
