Interested to Buy Any Domain ? << Click Here >> for more details...
what is partitioning? Types of partitioning. explain? what
is the new kind of partitioning type introduced in 9i?
- 0 Answers
- 2318 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can we connect to ORACLE db using Windows Authentication?
difference between bind variable and variable
can you write commit in triggers?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
> 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?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How can Oracle users be audited?
Explain what are synonyms used for?
Explain about functional dependency and its relation with table design?
What is a cursor variable?
What is a system tablespace and when it is created?
How to create a temporary table in oracle?
Oracle General 
