What is data block in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How do I learn what codesets are available 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 are the database administrators utilities available?
how to store only time in a data base table
Which Oracle App Is Most Popular One ?
How to loop through data rows in the implicit cursor?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Explain the use of rows option in exp command.
3. Display all the client numbers in the ORDER table. Remove duplicates.
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
Explain oracle instance.