Examine the structure of the transactions table: 
You want to display the date, time, and transaction amount of transactions that where done before
12 noon. The value zero should be displayed for transactions where the transaction amount has
not been entered.
Which query gives the required result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
Yes, B
B is it.
B is correct.
select to_char(sysdate, ‘dd-mon-yyy hh24:mi:ss’),
nvl(to_char(10000, ‘$99999999D99’),0),
nvl(to_char(”, ‘$99999999D99’),0),
to_char(sysdate, ‘hh24’)
from dual;