Answer Posted / mohammad islam

The format is to_char('10','0,999.99')
or to_char(10,'0,999.99')
What is the meaning of it? It means 10 has to be 4 digit
long number with comma after the first digit and 2 digit
decimal places
like 0,010.00

But for to_char('10','0999.99'), the result would be
0010.00 because 4 digit before the decimal place with no
comma and 2 digit after the decimal place

And for TO_CHAR(1230,'00,999.99'), the result is
01,230.00(as you see 5 digit before decimal and 2 digit
after decimal and comma after 2 digit.

I hope it will clear everything

Thanks,
Mohammad Islam

What is oracle datasource?

993

---

How to empty your oracle recycle bin?

1026

---

How to create lov dynamically at runtime & attach to text field?

1208

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1082

---

How to rollback the current transaction in oracle?

1056

---

Explain an exception and its types?

1081

---

What is Undo Management Advisor in Oracle?

1102

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2400

---

How to use "for" statements in oracle?

1076

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2328

---

Explain mutating triggers.

1034

---

What happens if recursive calls get out of control?

1084

---

How to define a data field as not null?

1116

---

What happens if the imported table already exists?

1035

---

What is the sql query to concatenate column values from multiple rows in oracle?

1063

---