What to do if the startbd.bat failed to start the xe instance?
No Answer is Posted For this Question
Be the First to Post Answer
What is the order of defining local variables and sub procedures/functions?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Explain self joins in oracle?
How to connect asp pages to oracle servers?
What is the difference between truncate & delete command?
can a table has a column that has only view data and in other columns we can change data?
What is a materialised view?
> 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 different Oracle database objects?
What privilege is needed for a user to insert rows to tables in another schema?
How to create a server parameter file?
What is rowid and rownum in oracle?