How to do paging with oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What types of joins are used in writing subqueries?
How will you differentiate between varchar & varchar2?
How to execute a stored procedure in oracle?
What do you understand by a database object?
if i am using dml statement in function. then i am writing select statement what was the output
Why oracle is used?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to use windows user to connect to the server?
what is shell?
how to retrieve data from different tables ,place this data in different excel worksheets.
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
> 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?