material view and view disadvantages?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to Remove the 3rd highest salary person record from table?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
> 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?
How to pass a parameter to a cursor in oracle?
what is difference between DBMS and RDBMS?
what are archived logs?
How can Oracle users be audited?
Difference between an implicit & an explicit cursor.?
What is tns entry?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
How many data types are supported?