The PRODUCT INFORMATION table has a UNIT_PRICE column of data type NUMBER(8,2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION; Which two statements are true about the output?

发布于 2021-02-23 19:25:38
【多选题】
A A row whose UNIT PRICE column contains the value 1023.99 will be displayed as $1,024.
B A row whose UNIT PRICE column contains the value 1023.99 will be displayed as $1,023.
C A row whose UNIT PRICE column contains the value 10235.99 will be displayed as $1,0236.
D A row whose UNIT PRICE column contains the value 10235.99 will be displayed as $1,023.
E A row whose UNIT PRICE column contains the value 10235.99 will be displayed as ######.

查看更多

关注者
0
被浏览
159
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服