Answer Posted / uday shankar chejerla

select clientnum,high_value_order from ordertab where
high_value_order=(select max(high_value_order) from
ordertab);

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

575

---

Which is better Oracle or MS SQL? Why?

3997

---

Can you assign multiple query result rows to a variable?

562

---

Why does for update in oracle 8 cause an ora-01002 error?

559

---

What is parameterized cursor in oracle?

588

---

---

How to loop through a cursor variable?

579

---

Describe an oracle table?

582

---

How to sort the query output in oracle?

623

---

How to estimate disk space needed for an export job?

572

---

Why does oracle 9i treat an empty string as null?

546

---

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

587

---

What are the restrictions in a oracle read only transaction?

580

---

How to assign data of the deleted row to variables?

593

---

Is it possible to split the print reviewer into more than one region ?

1844

---

How to view existing locks on the database?

561

---