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

20. Using a set operator, display the client number of all clients who have never placed an order.

2173

---

What do you understand by a database object?

1042

---

How does Oracle guarantee data integrity of data changes?

2372

---

What are the different pseudo commands? Explain in general?

1061

---

How to add another datafile to a tablespace?

1021

---

Is oracle an open source?

1063

---

Can we commit inside a function in oracle?

946

---

what are actual and formal parameters?

1102

---

Explain the blob datatype?

1059

---

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

2384

---

State the difference between a primary key and foreign key?

923

---

What is the usage of synonyms?

1124

---

Explain the use of record option in exp command.

991

---

What is backup in Oracle?

987

---

What are the database administrators utilities available?

1011

---