Answer / shafeeq

Select max(salary) from emp;

Answer / pradeep kolakala

Select max(sal) from ithpharma.UserRole where version
not in (select max(sal) from ithpharma.UserRole)

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

---

What is a subquery in oracle?

0 Answers  

---

How to recover a dropped index?

1 Answers  

---

How to write a query with a right outer join in oracle?

0 Answers  

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

how to get last monday of a month?

2 Answers   Multifonds,

---

Does oracle database need java?

0 Answers  

---

Explain the truncate in oracle?

0 Answers  

---

Point the difference between translate and replace?

0 Answers  

---

What is a cursor and what are the steps need to be taken?

0 Answers  

---