Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64124 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / answer
NO NEED TO WATCH ANY OTHER ANSWER .ANSWER 11 IS GOOD.JUST
GO WITH IT
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what is insert all statement in sql
How to experiment a data lock in oracle?
What is object data modeling?
> 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 drop a tablespace?
Can we write insert statement in function in oracle?
 What are the oracle DML commands possible through an update strategy?
What happens to the data files if a tablespace is dropped?
Why cursor variables are easier to use than cursors?
What is the data pump export utility?
Explain what are the different type of segments?
Which is better Oracle or MS SQL? Why?
How to create tables for odbc connection testing?
Explain a synonym?
What is control file used for?
