Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
No Answer is Posted For this Question
Be the First to Post Answer
why dont we assign not null constraint as table level constraint.
What is a table index?
How to resolve the ORA-39133 error in Oracle?
What is a Tablespace?
How to view existing locks on the database?
Define the terms primary key foreign key and also the difference between primary and the unique key
What are the different types of databases?
What is dual table oracle?
How do you bind variables in oracle?
How to drop an index?
> 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?
can we pass two out parameters at a time in function?please answer to my question