Oracle SYS_GUID Yeteri Kadar Eşsiz mi?

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrU2fraiiizmAJfzqypi4XN-r2ExZVJyN_3u6OlwBADDjuwbtd1X2YW6yEvvOtLy1ZJwR4OR5F2kmgjYXlGiLSzt3PJ0AqFw07xlSJFrBpscsSw1Is9nUTSHR25vKvQA1JuNFszUL5YSFg/s1600/asdsad.PNG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em; text-align: justify;"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrU2fraiiizmAJfzqypi4XN-r2ExZVJyN_3u6OlwBADDjuwbtd1X2YW6yEvvOtLy1ZJwR4OR5F2kmgjYXlGiLSzt3PJ0AqFw07xlSJFrBpscsSw1Is9nUTSHR25vKvQA1JuNFszUL5YSFg/s200/asdsad.PNG" width="200" /></a></div><div class="MsoNormal" style="text-align: justify;">GUID (<b><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;">Globally Unique Identifier) </span></b>leri eşsiz ID ler yaratmak için sıkça kullanırız. GUID lerinde SEQUENCE’lardan farkı bizim için sıralı olmayan ve tahmin edilmesi çok zor olan karakter kümesi üretmesidir. Bu eşsiz ID leri de güvenlik amaçlı olarak yaygın olarak kullanılır.</div><div class="MsoNormal"><o:p></o:p></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Ben sizlere Oracle da GUID üretmek için kullanılan SYS_GUID() fonksiyonundan biraz bahsedeceğim.</div><ul><li style="text-align: left;"><span style="text-indent: -0.25in;">SYS_GUID() fonksiyonu da oracle’ın pek çok “build-in” fonksiyonu gibi SYS.STANDARD paketindedir.</span></li><li style="text-align: left;"><span style="text-indent: -0.25in;">SYS_GUID() fonksiyonu çağrıldığında bize RAW tipinde 32 karakterlik rakam ve büyük harflerden oluşan eşsiz bir karakter kümesi döner.</span></li><li style="text-align: left;"><span style="text-indent: -0.25in;">SYS_GUID()’yi Oracle daki ROWID ile karıştırmamak gerekir. ROWID farklı bir konudur.</span><span style="font-family: Symbol; text-indent: -0.25in;"><span style="font-family: 'Times New Roman'; font-size: 7pt;">  </span></span><span style="text-indent: -0.25in;">Oracle dökümantasyonundaki açıklaması (1) :</span></li></ul><div class="MsoListParagraphCxSpLast" style="text-align: justify;"><blockquote class="tr_bq"><span style="color: #cc0000;"><code><b><span style="font-size: 10pt; line-height: 115%;">SYS_GUID</span></b></code><span class="apple-converted-space"><span style="font-size: 13.5pt; line-height: 115%;"> </span></span><span style="line-height: 115%;">generates and returns a globally unique identifier (</span><code><span style="font-size: 8pt; line-height: 115%;">RAW</span></code><span class="apple-converted-space"><span style="line-height: 115%;"> </span></span><span style="line-height: 115%;">value) made up of 16 bytes. On most platforms, the generated identifier consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.</span></span></blockquote></div><div class="MsoListParagraphCxSpLast" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Aşağıdaki görüldüğü gibi SYS_GUID sorgulandığında her zaman bize eşsiz bir ID  getirmektedir.<o:p></o:p></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><h4><span style="font-family: 'Courier New';">SQL> SELECT E.EMPLOYEE_ID, ROWID, SYS_GUID(), SYS_GUID() FROM EMPLOYEES E ORDER BY 1;</span></h4></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">EMPLOYEE_ID ROWID              SYS_GUID()                       SYS_GUID()<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">----------- ------------------ -------------------------------- --------------------------------<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        100 AAAEAUAAEAAAADNAAA 2821F6A306944EC5B8197B46F7249204 65CF4539C76F4F049689A9650025A551<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        101 AAAEAUAAEAAAADNAAB 01B97056FFEE45D08728E97D4AB3FB9A F8EE170E33924477B8195F233870AFDF<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        102 AAAEAUAAEAAAADNAAC 94D432B4F6B84F94B55C7DE56EB618C5 ACA81875CEDE42D8904354E7E61D88F2<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        103 AAAEAUAAEAAAADNAAD 7768CE4398DF41DEB84D575ABEEA46C3 7433523FEF2B48F48F30E623FD9AAB1F<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        104 AAAEAUAAEAAAADNAAE 5F82E5E74A984CBEB145ED939E0E26D9 2D95F0E83C774E3C9894BF0C5727A4CC<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        105 AAAEAUAAEAAAADNAAF D1071E58C1A0424586EB639FA871807B 33238197CA324C739D4D5704EEFFA221<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        106 AAAEAUAAEAAAADNAAG 743F776BF8E446DE8E9B9229637C92A2 3C3067CDBBC6425AAEF9A8AC6A93292D<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        107 AAAEAUAAEAAAADNAAH 8DAFDA3416D34573A2E54217DE45B05E 6B864D7293C445DA83FE444D59228506<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        108 AAAEAUAAEAAAADNAAI F2F19214E8F34AF98DA25CE49BC5BB65 A4611A06A3CC491F8F5DEA2CA53930E3<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        109 AAAEAUAAEAAAADNAAJ 81AC784FCEA647ADB5B111C836892D0B F9E5F6E97F7E448F96AAD2B10F021757<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        110 AAAEAUAAEAAAADNAAK 22FA296EB1274D25B46610DF4B4FA834 1DA3A9C193AE4F849CC14B0989E866EE<o:p></o:p></span></span></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Sorguyu çalıştırdığım platform bilgileri :</div><div class="MsoNoSpacing" style="text-align: justify;"><h4><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">SQL> select * from v$version order by 1;</span></h4></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">BANNER<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">--------------------------------------------------------------------------------<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE    11.2.0.2.0      Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 11.2.0.2.0 - Beta<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for 32-bit Windows</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">: Version 11.2.0.2.0 - Beta<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;"><o:p><br /></o:p></div><div class="MsoNormal" style="text-align: justify;">Şimdi gelelim SYS_GUID() kullanımındaki <b>probleme</b>; Ne hikmetse Bu SYS_GUID() bazı platformlarda beklendiği gibi çalışmamaktadır. Yukarıdaki sorguyu farklı bir platformda çalıştırdığımızda;<o:p></o:p></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><h4><span style="font-family: 'Courier New';">SQL> SELECT E.EMPLOYEE_ID, ROWID, SYS_GUID(), SYS_GUID() FROM egitim1.EMPLOYEES E ORDER BY 1;</span></h4></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">EMPLOYEE_ID ROWID              SYS_GUID()                       SYS_GUID()<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">----------- ------------------ -------------------------------- --------------------------------<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">                                          *                                *               <o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        100 AACWsZAAJAAAZJ/AAA E4D372D7CF5<span style="background: yellow; mso-highlight: yellow;">A</span>0092E0430AC9E8CF0092 E4D372D7CF5<span style="background: yellow; mso-highlight: yellow;">B</span>0092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        101 AACWsZAAJAAAZJ/AAB E4D372D7CF5C0092E0430AC9E8CF0092 E4D372D7CF5D0092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        102 AACWsZAAJAAAZJ/AAC E4D372D7CF5E0092E0430AC9E8CF0092 E4D372D7CF5F0092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        103 AACWsZAAJAAAZJ/AAD E4D372D7CF600092E0430AC9E8CF0092 E4D372D7CF610092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        104 AACWsZAAJAAAZJ/AAE E4D372D7CF620092E0430AC9E8CF0092 E4D372D7CF630092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        105 AACWsZAAJAAAZJ/AAF E4D372D7CF640092E0430AC9E8CF0092 E4D372D7CF650092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        106 AACWsZAAJAAAZJ/AAG E4D372D7CF660092E0430AC9E8CF0092 E4D372D7CF670092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        107 AACWsZAAJAAAZJ/AAH E4D372D7CF680092E0430AC9E8CF0092 E4D372D7CF690092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        108 AACWsZAAJAAAZJ/AAI E4D372D7CF6A0092E0430AC9E8CF0092 E4D372D7CF6B0092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">        109 AACWsZAAJAAAZJ/AAJ E4D372D7CF6C0092E0430AC9E8CF0092 E4D372D7CF6D0092E0430AC9E8CF0092<o:p></o:p></span></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: 'Courier New';"><span style="font-size: xx-small;">                                          *                                *               <o:p></o:p></span></span></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Sorguyu çalıştırdığım platformun bilgileri :<o:p></o:p></div><div class="MsoNoSpacing" style="text-align: justify;"><h4><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">SQL> SELECT * FROM V$VERSION ORDER BY 1;</span></h4></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">BANNER<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">--------------------------------------------------------------------------------<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE    11.2.0.2.0      Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for IBM/AIX RISC System/6000</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">: Version 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Dikkat ederseniz sadece yıldızlı sıradaki harfler farklı. Aslında Oracle yalan söylemiyor. Bize her çağrıldığında farklı bir ID üretiyor ama aslında bu tam olarak GUID den beklediğimiz şekilde bir ID değil.  İncelemelerime göre bu durum Oracle’ın çalıştığı OS’e bağlı. <b>Linux</b>makinalarında bu tip bir durum gözlemledim (Aşağıda test yaptığım makina versiyonlarını görebilirsiniz). (Bu sorunu (2) Steven yıllar önce tespit edip bir makale hazırlamış aslında) SYS_GUID()’yi kullanacağınız Oracle platformunda öncelike bunu test edip daha sonra kullanmakta fayda var.</div><div class="MsoNormal" style="text-align: justify;"><o:p></o:p></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;"><h3><b>ALTERNATİF ÇÖZÜM</b></h3></div><div class="MsoNormal" style="text-align: justify;">Bu durumla karşı karşıya kaldıysanız benim tavsiyem Oracle’ın <b>DBMS_RANDOM  </b>paketini (3)  kullanmak.  SYS_GUID()’ye benzer bir içerik üretmek için “<b>DBMS_RANDOM.STRING('X',32)”</b> fonksiyonunu kullanabilirsiniz. Bu fonksiyon size RAW tipinde değil VARCHAR2 tipinde bir değer dönecektir ama zaten GUID leri genellikle string amaçlı kullanıyoruz. İhtiyaç halinde çevirmeler yapılabilir.<o:p></o:p></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">Örnek;<o:p></o:p></div><div class="MsoNoSpacing" style="text-align: justify;"><h4><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">SQL> SELECT SYS_GUID(), DBMS_RANDOM.STRING('X',32) AS rnd  FROM egitim1.EMPLOYEES E WHERE ROWNUM < 11;</span></h4></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">SYS_GUID()                        RND<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">--------------------------------  --------------------------------<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0BB0092E0430AC9E8CF0092  TYW14HQDWSJ2260LG0Y4E2JVOE16SJ3X<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0BC0092E0430AC9E8CF0092  J4T9J59O3XJ7DJJ6GMT9ZOUIDY7W1UAG<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0BD0092E0430AC9E8CF0092  WDCLBAAKYICRL3140VFR8XFW205KZK5Z<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0BE0092E0430AC9E8CF0092  BVTPTUQE461KRVMEUMNARQDZEH6AVFJ9<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0BF0092E0430AC9E8CF0092  D5HFXSJ52GBZT2BWNSVQBIYPDZ0OAANI<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0C00092E0430AC9E8CF0092  CIZPO6JW2YAKSOV1A116XIYR5H4736NE<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0C10092E0430AC9E8CF0092  YBPH8VTQR5B36URN11V7TM9IZ3WRD7A1<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0C20092E0430AC9E8CF0092  AZ21KOS26DA4DQE7JZFWTWWYFL9M24S2<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0C30092E0430AC9E8CF0092  4E5RJJP8F5C6COPI3CO637ZPLCNNSK4B<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">E4D372D7D0C40092E0430AC9E8CF0092  SFVWA4FY4R25KLGIXXS6BRRPRSEC4TJ7<o:p></o:p></span></div><div class="MsoNormal" style="text-align: justify;"><br /></div><div class="MsoNormal" style="text-align: justify;">GUIID’yi <b>beklediğimiz gibi üretmeyen </b>diğer ortam bilgilerine örnekler;</div><div class="MsoNormal" style="text-align: justify;"><o:p></o:p></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;"><br /></span><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE   10.2.0.5.0   Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 10.2.0.5.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 10.2.0.5.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for IBM/AIX RISC System/6000</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">: Version 10.2.0.5.0 – Productio<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE   10.2.0.4.0   Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 10.2.0.4.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 10.2.0.4.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for IBM/AIX RISC System/6000</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">: Version 10.2.0.4.0 – Productio<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE   10.2.0.5.0   Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 10.2.0.5.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 10.2.0.5.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for Solaris:</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;"> Version 10.2.0.5.0 – Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><br /></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">CORE   11.2.0.2.0   Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">NLSRTL Version 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">PL/SQL Release 11.2.0.2.0 - Production<o:p></o:p></span></div><div class="MsoNoSpacing" style="text-align: justify;"><b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;">TNS for Linux:</span></b><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;"> Version 11.2.0.2.0 – Production</span><br /><span style="font-family: "Courier New"; font-size: 8.0pt; mso-bidi-font-size: 11.0pt;"><br /></span></div><div class="MsoNormal" style="text-align: justify;"><h3>REFERANSLAR</h3><ol><li><a href="http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions153.htm">http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions153.htm</a></li><li><a href="http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html">http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html</a></li><li><a href="http://psoug.org/reference/dbms_random.html">http://psoug.org/reference/dbms_random.html</a></li></ol></div>

Oracle SYS_GUID Yeteri Kadar Eşsiz mi?

GUID ( Globally Unique Identifier) leri eşsiz ID ler yaratmak için sıkça kullanırız. GUID lerinde SEQUENCE’lardan farkı bizim için sıralı ol...

Read more »