047-206

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718982/