oracle guid 生成,使用SYS_GUID()每次生成的值为什么都一样？-白红宇

oracle guid 生成,使用SYS_GUID()每次生成的值为什么都一样？

阅读量：6660 次

发布时间：2019-06-25

本文共 2205 字，大约阅读时间需要 7 分钟。

很相似只有一位不一样，这是Linux版本的不好的地方，很难分辨，windwos 版本没有这个问题，如果系统是Linux AS4，安装Oracle 9.2.0.7就容易误导，究竟是Oracle的问题还是操作系所的问题，就不清楚了！

SQL> select sys_guid() from dual connect by rownum <10;

SYS_GUID()

--------------------------------

2DBC6F7989D06E10E040007F0100498F

2DBC6F7989D16E10E040007F0100498F

2DBC6F7989D26E10E040007F0100498F

2DBC6F7989D36E10E040007F0100498F

2DBC6F7989D46E10E040007F0100498F

2DBC6F7989D56E10E040007F0100498F

2DBC6F7989D66E10E040007F0100498F

2DBC6F7989D76E10E040007F0100498F

2DBC6F7989D86E10E040007F0100498F

SQL> select * from database_properties;

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION

------------------------------ -------------------------------------------------------------------------------- --------------------------------------------------------------------------------

DICT.BASE 2 dictionary base tables version #

DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace

DBTIMEZONE -08:00 DB time zone

NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set

GLOBAL_DB_NAME ORA92.US.ORACLE.COM Global database name

EXPORT_VIEWS_VERSION 8 Export views revision #

NLS_LANGUAGE AMERICAN Language

NLS_TERRITORY AMERICA Territory

NLS_CURRENCY $ Local currency

NLS_ISO_CURRENCY AMERICA ISO currency

NLS_NUMERIC_CHARACTERS ., Numeric characters

NLS_CHARACTERSET ZHS16GBK Character set

NLS_CALENDAR GREGORIAN Calendar system

NLS_DATE_FORMAT DD-MON-RR Date format

NLS_DATE_LANGUAGE AMERICAN Date language

NLS_SORT BINARY Linguistic definition

NLS_TIME_FORMAT HH.MI.SSXFF AM Time format

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format

PROPERTY_NAME PROPERTY_VALUE DESCRIPTION

------------------------------ -------------------------------------------------------------------------------- --------------------------------------------------------------------------------

NLS_DUAL_CURRENCY $ Dual currency symbol

NLS_COMP BINARY NLS comparison

NLS_LENGTH_SEMANTICS BYTE NLS length semantics

NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception

NLS_RDBMS_VERSION 9.2.0.7.0 RDBMS version for NLS parameters

25 rows selected

解决的办法正在找！！~~

转载地址：http://putto.baihongyu.com/

你可能感兴趣的文章