Answer Posted / sanjay pradhan

select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);

How to update values in a table in oracle?

1077

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2297

---

What happens if the update subquery returns multiple rows?

1169

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2313

---

What is the scope of a local variable?

1121

---

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.

1473

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

---

What is oracle rownum?

1016

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2179

---

How to create id with auto_increment on oracle?

1040

---

How to connect to oracle using service name instead of sid?

1067

---

What is a partition in oracle?

1204

---

Difference between inner join vs where ?

1096

---

How can I combine multiple rows into a comma-delimited list in oracle?

1116

---

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

1086

---