Answer / uday shankar chejerla

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

Answer / vijayaragavan

select clientnum, max(high_value_order) from ordertab group
by clientnum;

Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---

Why do you use stored procedures and state some of its disadvantages?

0 Answers  

---

how to join query for one source type is oracle another source type is sql server ?

0 Answers   iGate,

---

What is difference between SUBSTR and INSTR?

1 Answers  

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

How do I limit the number of oracle database connections generated by weblogic server?

0 Answers  

---

What are temporal data types in oracle?

0 Answers  

---

How to export your connection information to a file?

0 Answers  

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

what is shell?

2 Answers   Microsoft,

---