Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohan
With the help of index we can access the data quickly from
the table....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is memory advisor in Oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to open a cursor variable?
> 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 dual table oracle?
How to export your own schema?
Explain enable novalidate constraint.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What do you mean by merge in oracle and how can we merge two tables?
What are the common oracle dba tasks?
How to unlock the sample user account in oracle?
Explain about achiever in sql?
What are named parameters?
What are the types of trigger in oracle?
What are the original export and import utilities?
