What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle open database communication (odbc)?
How can Oracle users be audited?
What is an external table?
> 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?
Why is oracle so popular?
What are operators in oracle?
What happens in oracle commit?
Why does oracle 9i treat an empty string as null?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is bind variable in oracle 11g?