ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-206

047-206

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:57:33 0 删除 编辑
206. View the Exhibit and examine the details of the PRODUCT_INFORMATION
table.Evaluate the following SQL statement:
SELECT TO_CHAR(list_price,'$9,999') FROM product_information;
Which two statements would be true regarding the output for this SQL statement?
(Choose two.)
A. The LIST_PRICE column having value 1123.90 would be displayed as $1,124.
B. The LIST_PRICE column having value 1123.90 would be displayed as $1,123.
C. The LIST_PRICE column having value 11235.90 would be displayed as $1,123.
D. The LIST_PRICE column having value 11235.90 would be displayed as #######.
Answer: AD
Eg:create table test(a int,b number(8,2))
insert into test values(1,1123.90);
insert into test values(2,11235.90);
SELECT TO_CHAR(b,'$9,999') FROM test where a=1;
$1,124
SELECT TO_CHAR(b,'$9,999') FROM test where a=2;
#######

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718982/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-203
下一篇: 047-207
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203398