why on m$ platform result of G1 and G2 of select M.G G1, M.G G2 from (select sys_guid() G from
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;
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;
0