Interested to Buy Any Domain ? << Click Here >> for more details...
If a parameter is used in a query without being previously
defined, what diff. exist betw. report 2.0 and 2.5 when the
query is applied ?
- 0 Answers
- 2243 Views
- Oracle, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to create a stored procedure in oracle?
What is clustered table in Oracle?
Differentiate between translate and replace?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
What is a tns service name?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
How many types of synonyms 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 difference between where clause and having clause?
How do I spool to a csv formatted file using sqlplus?
what is main def between plsql/table and array?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Oracle General 
