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;

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

---

Explain the use of Merge statement in oracle 11g

0 Answers   Infosys,

---

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers   Oracle,

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---

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

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 Answers  

---

What is the parameter mode that can be passed to a procedure?

0 Answers  

---

How to convert csv to table in oracle?

0 Answers  

---

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

0 Answers  

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---