Database Administration (MOSC)

MOSC Banner

why on m$ platform result of G1 and G2 of select M.G G1, M.G G2 from (select sys_guid() G from

edited Dec 2, 2012 8:57PM in Database Administration (MOSC) 1 commentAnswered ✓
10:44:51 win10.2.0.5> select  M.G G1, M.G G2   from (select sys_guid() G from dual) M10:46:12   2  ;

G1                              |G2
--------------------------------|--------------------------------
B1E14A9493B7426A83378EA06F7F467F|D6FFEEF6E98C4F65A536C7166448284F

??????.?????: 00:00:07.63

???? ??????????
----------------------------------------------------------
Plan hash value: 1388734953

-----------------------------------------------------------------
| Id  | Operation        | Name | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL       |      |     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------


BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

why on ms guid's are different ?


10:44:29 11.2.0.3ubuntu> select  M.G G1, M.G G2   from (select sys_guid() G from dual) M;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center