How to connect ms access to oracle servers?
No Answer is Posted For this Question
Be the First to Post Answer
How to list all tables in your schema?
What does COMMIT do ?
Can the query output be sorted by multiple columns in oracle?
What is the difference between a user and a schema in oracle?
What are the Limitations of a CHECK Constraint ?
> 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 are the different oracle database objects?
How to delete a column in an existing table?
How to get maxsal , minsal, ename department wise in single query
How to use in conditions in oracle?
What is archive log in Oracle?
what is the difference between substr and instr function in oracle?