Answer Posted / kanha

Select E1.* From(Select Ename,Deptno,Sal,
Dense_Rank()over
(
Partition By Deptno Order By Sal Desc
)"Top Sal"
From Emp)E1
Where "Top Sal"<=5 Order By Deptno,Sal Desc;

When do you get a .pll extension in oracle?

1076

---

How to write a query with an inner join in oracle?

972

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2198

---

What is a table index?

1011

---

What's dateware house and what's clustor with practicle example

2124

---

What is the difference between substr & instr functions?

1118

---

How many memory layers are in the oracle shared pool?

1103

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1368

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

---

How many file formats are supported to export data?

1133

---

what happened to the global index when I truncate the data in one of the partition?

1959

---

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

1979

---

How to work with data objects interactively?

923

---

State the various uses of dbcc command?

986

---

How to run the anonymous block again?

1065

---