Answer Posted / nagaraju nampally

select * from (select ename,sal,deptno,dense_rank()
over(partition by deptno order by sal)rnk from emp)x where
x.rnk<5

How to resolve name conflicts between variables and columns?

1040

---

> 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?

2037

---

Explain the difference between a procedure and a function?

1182

---

What is an index associated with a constraint?

1043

---

How to display employee records who gets more salary than the average salary in the department?

1069

---

What is the dynamic sql in oracle?

1083

---

Explain the difference between replace() and translate() functions in oracle?

1045

---

Explain the difference between sql and oracle?

1088

---

please explain.. DB architecture ...

2030

---

What is oracle thin client?

1029

---

What is a user account in oracle?

1130

---

When do you get a .pll extension in oracle?

1154

---

How to convert numbers to characters in oracle?

1036

---

Define oracle database

1050

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2330

---