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

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

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

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

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

C.
SELECT TO_CHAR(1890.55,’$99,999D99′) FROM DUAL;

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

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

Show Hint

Leave a Reply 1

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

helion

helion

A,D & E

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

TO_CHAR(18
———-
$1,890.55

SELECT TO_CHAR(1890.55,’$9,999V99′) FROM DUAL;
TO_CHAR(1
———
$1,89055

SELECT TO_CHAR(1890.55,’$99,999D99′) FROM DUAL;
Erro de SQL: ORA-01481: invalid number format model
01481. 00000 – “invalid number format model”

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

TO_CHAR(189
———–
$1,890.55

SELECT TO_CHAR(1890.55,’$99G999D99′) FROM DUAL;
TO_CHAR(189
———–
$1,890.55

Reply