Answer Posted / vengalrao

Dear Friends,

Depends upon table u can pick one max value is possible,one
table u cannot pick max value of all columans , then u can
refer one any ne column

select depid,max(sal) from <table name> group by depid;

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

---

What are the different types of modules in oracle forms?

1001

---

How do I uninstall oracle client from windows?

1010

---

How to use subqueries in the from clause in oracle?

1113

---

How a database is related to tablespaces?

1032

---

What is the difference between truncate & delete command?

1182

---

Explain oracle’s system global area (sga).

1139

---

Explain about integrity constraint?

1124

---

Compare and contrast between sql and sql server and explain its various functions?

964

---

How to use "startup" command to start default instance?

1035

---

How do I spool in oracle?

1004

---

What are transaction isolation levels supported by oracle?

1072

---

How to bring a tablespace offline?

1065

---

Explain how you would restore a database using RMAN to Point in Time?

2146

---

Can I create users through internet explorer in oracle 10g?

1084

---