How to create a table index in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What are the limitations oracle database 10g xe?
Explain an index?
what is the dual table in oracle?
how will I find the first 5 highest salaried employees in each dept in oracle.
What are the basic element of Base configuration of an oracle Database ?
State any two functions of oracle?
How many types of auditing in Oracle?
> 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 oracle database 10g express edition?
How can we find the size of a database?
Which is faster join or subquery in oracle?
What the is the diff between local index and global index. give some example.