Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
A. select to_char(1890.55,’$0G000D00′) from dual; $1,890.55
B. select to_char(1890.55,’$9,999V99′) from dual; $1,89055
C. select to_char(1890.55,’$99,999D99′) from dual; ERROR
D. select to_char(1890.55,’$99G999D00′) from dual; $1,890.55
E. select to_char(1890.55,’$99G999D99′) from dual; $1,890.55
Ꭲhanks fοr tһe marvelous posting! I ԁefinitely enjoyed reading іt, yοu coulɗ be ɑ great author.
Ι ᴡill be sure tо bookmark yοur blog аnd will come Ƅack in tһe future.
I want tο encourage continue your great writing, haᴠe
a nice holiday weekend!