Answer / anuradha

Select Item_Name,
Item_Cost,
Round(Item_Cost, -2) Hundred_Round,
Round(Item_Cost, -1) Ten_Round,
Round(Item_Cost, 0) Unit_Round,
Round(Item_Cost, 1) Tenth_Round,
Round(Item_Cost, 2) Hundredth_Round
From Items;

What is a public synonym?

1 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

How to login to the server without an instance?

0 Answers  

---

which sql command we can use to get a print out from oracle?

2 Answers   iFlex, INDUS,

---

What is tns entry?

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

How to pass a cursor variable to a procedure?

0 Answers  

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,

---

How to delete an existing row from a table in oracle?

0 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

How to use existing values in update statements using oracle?

0 Answers  

---

How to omit columns with default values in insert statement in oracle?

0 Answers  

---