Which three SQL statements would display the value 1890.55 as $1,890.55?

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

A.
SELECT TO_CHAR(1890.55,’$99G999D00′)
FROM DUAL;

B.
SELECT TO_CHAR(1890.55,’$9,999V99′)
FROM DUAL;

C.
SELECT TO_CHAR(1890.55,’$0G000D00′)
FROM DUAL;

D.
SELECT TO_CHAR(1890.55,’$99G999D99′)
FROM DUAL;

E.
SELECT TO_CHAR(1890.55,’$9,999D99′)
FROM DUAL;



Leave a Reply 4

Your email address will not be published. Required fields are marked *


freddy

freddy

same repeated question as #74

bina

bina

Freddy, there are few repeat questions.

daroldrudolph

daroldrudolph

Is the comma the problem with B and E?