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

State all possible different index configurations a table can possibly have?

1104

---

How to empty your oracle recycle bin?

1077

---

What is null value in oracle?

1160

---

Explain the difference between sap and oracle?

1087

---

What is a user account in oracle?

1173

---

What is the difference between a primary key & a unique key?

1141

---

How to specify default values in insert statement using oracle?

1155

---

material view and view disadvantages?

1127

---

What is concurrency in oracle?

1059

---

What are oracle functions?

1090

---

How to connect to the server with user account: sys?

1063

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1064

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2085

---

Can a parameter be passed to a cursor?

1182

---

What is a subquery?

1192

---