Answer Posted / nishi
Form, Menu, Library
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop an index?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How do I learn what codesets are available in oracle?
Why do we need oracle client?
What is the use of aggregate functions in oracle?
What is the simplest tool to run commands on oracle servers?
What is the difference between 10g OEM and 11g OEM?
How to use subqueries with the in operator using oracle?
What privilege is needed for a user to delete rows from tables in another schema?
Please explain drop constraint oracle?
Explain about functional dependency and its relation with table design?
What privilege is needed for a user to query tables in another schema?
How to write numeric literals in oracle?
What is the relation of a user account and a schema 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?
