虽然在AV-TEST最新杀软评测中，卡巴斯基得到了满分成为第一，但美国依然不允许它出现在政府采购名录中，而这个封杀的事态还在加剧。
据外媒CNET报道称，除了美国的政府机构外，FBI也在悄悄暗示那些私营机构停止使用卡巴斯基，情况十分严重。
报道中提到，能源行业以及使用工业控制系统等企业，都在被警告的名单中，而按照美国的意思，就是先让该国企业尽可能快的从其系统中移除卡巴斯基。
虽然卡巴严正否认自己进行涉嫌收集不法信息的“间谍”活动，甚至可以交出软件源代码，但目前的情况是，这丝毫没有打动当局控制者，而消息中还透露，俄罗斯也正努力移除美国科技公司如微软的操作系统。
对于微软来说，这件事他们暗地里非常开心，因为这样可以让更多的用户来换用Windows Defender，尤其是随着创意者更新全面升级的“新安全中心”。
来自：驱动之家
转自:https://www.oschina.net/news/87919/kaspersky-banned-by-american-government
Here you will find list of Oracle Number Format elements:
| Format element | Description |
|---|---|
| , | Returns a comma in the specified position it is possible to specify multiple commas. |
| . | Returns a period in the specified position. |
| $ | Returns a leading dollar sign. |
| 0 | Returns leading or trailing zeros (0). |
| 9 | Returns value with the specified number of digits with a leading space if positive or with a leading minus if negative. |
| B | Returns blanks for the integer part of a fixed point number when the integer part is zero. |
| C | Returns in the specified position the ISO currency symbol. Defoult currency value is set in the NLS_ISO_CURRENCY parameter. |
| D | Returns in the specified position the decimal character, which is the current value of the NLS_NUMERIC_CHARACTER parameter. The default is a period. |
| EEEE | Returns a value in scientific notation. |
| FM | Returns a value without blanks (leading and trailing). |
| G | Returns in the specified position the group separator. The defoult value is set in the NLS_NUMERIC_CHARACTER parameter. You can specify multiple group separators in a number format model. |
| L | Returns in the specified position the local currency symbol. Defoult currency value is set in the NLS_CURRENCY parameter. |
| MI | Returns negative value with a trailing minus (-) sign.
Returns positive value with a trailing blank. |
| PR | Returns negative value in <>.
Returns positive value with a leading and trailing blank. |
| RN | Returns a value as Roman numerals in uppercase.
Allowed value is an integer between 1 and 3999. |
| rn | Returns a value as Roman numerals in lowercase.
Allowed value is an integer between 1 and 3999. |
| S | Returns value with a leading or trailing minus (-) or plus (+) sign. |
| TM | The text minimum number format model returns the smallest number of characters possible. This element is case insensitive. |
| U | Returns in the specified position the defoult currency symbol. The current value of the NLS_DUAL_CURRENCY parameter. |
| V | Returns a value multiplied by 10n and if necessary, round it up. |
| X | Returns the hexadecimal value of the specified number of digits. If the specified number is not an integer, Oracle Database will round it to an integer. |
In examples below are shown conversions from number to char with different numbers and format elements.
SELECT TO_CHAR(number, 'format_element') FROM dual;
| number | ‘format_element’ | results |
|---|---|---|
-55555 |
55555S |
'55555-' |
0 |
99.99 |
' .00' |
+0.5 |
99.99 |
' .50' |
-0.5 |
99.99 |
' -.50' |
+0.55 |
90.99 |
' 0.55' |
-0.5 |
90.99 |
' -0.50' |
0 |
9999 |
' 0' |
+222.55 |
999.99 |
' 222.55' |
-222.55 |
999.99 |
'-222.55' |
+222.55 |
FM999.09 |
'222.55' |
+555.0 |
FM999.009 |
'555.00' |
+55.55 |
L99.99 |
' $55.55' |
+55.5 |
FML99.9 |
'$55.5' |
SQL Performance Tuning