How to count duplicated values in a column in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is TNS File
Does facebook use oracle?
How to pass parameters to procedures in oracle?
How to check the oracle tns settings?
How to use "in" parameter properly?
Explain the use of inctype option in exp command.
> 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?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
 How to use an oracle sequence generator in a mapping?
How to loop through data rows in the implicit cursor?
What are advantages of dateset in datastage?