Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151545 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / karunakar varma
select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What to do if dba lost the system password?
What is the data pump export utility?
What is procedure overloading in oracle?
Explain the use of grant option in imp command.
Use of an integrity constraint is better to validate data. Explain
How do I use os authentication with weblogic jdriver for oracle and connection pools?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the relation of a user account and a schema in oracle?
What are the differences between char and nchar in oracle?
How to load excel data sheet to oracle database
Difference between inner join vs where ?
Why do we use bulk collect in oracle?
What are the different editions of 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?
Why do we need oracle client?
