Answer / dharmendra

select to_char(sysdate,'DD/MON/YYYY') from dual;

Answer / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

Answer / panchi

dd/mm/yyyy

Answer / bhanu

select to_char(sysdate,'DD/MON/YYYY') from dual;

Answer / nazim

select convert(char(12),getdate(),106)

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,

---

what is grid in Oracle 10g...

1 Answers  

---

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  

---

How to count duplicated values in a column in oracle?

0 Answers  

---

What are named parameters?

0 Answers  

---

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What are triggers?Where are they used?

3 Answers  

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  

---

What types of joins are used in writing subqueries?

0 Answers  

---