Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SORT ORDER BY elimination
SGVsbG8gRWRnYXIsDQogDQp5b3UgbWlnaHQgKG9yIGJldHRlciBtaWdodCBub3QpIHdhbnQgdG8g
dHJ5IHRoZSBOTF9TSiBoaW50IGluc2lkZSBlYWNoIHN1YnF1ZXJ5LiBUaGlzIHdvcmtzLCBidXQg
aXMgZGVwcmVjYXRlZCBpbiAxMGcgYW5kIGl0J3Mgc2xvdyAoZm9yIHlvdXIgZXhhbXBsZSkgc2lu
Y2UgdGhlIHN1YnF1ZXJpZXMgYXJlIHNjYW5uZWQgZm9yIGVhY2ggc2FsZXMgcmVjb3JkIHBpY2tl
ZCBmcm9tIFNBTEVfUEsgYW5kIHRoZXJlIGlzIG5vIGluZGV4IGZvciB0aGUgc3VicXVlcmllcy4g
DQogDQpOb3Qgc3VyZSBpZiB0aGlzIG1hdGNoZXMgeW91IHJlYWwtbGlmZSBwcm9ibGVtIGJlaGlu
ZCB0aGUgZXhhbXBsZSwgYnV0IGl0IGxvb2tzIGEgbGl0dGxlIGxpa2UgYSByZXBvcnRpbmcgaXNz
dWUgSSBnb3Qgc29tZSB0aW1lIGFnbzoNCiANCldlIHJlcXVpcmVkIGEgZmxleGlibGUgbGlzdCBv
ZiAiZGltZW5zaW9ucyIgdGhhdCBhcmUgbWFudWFsbHkgc2VsZWN0ZWQgYW5kIGNvbm5lY3RlZCB3
aXRoIGxhcmdlIGEgImZhY3QiIHRhYmxlIChvbmx5IERXSCBzcGVhayAtIGl0IGFjdHVhbGx5IHdh
cyBPTFRQKS4gVGhlIHF1ZXJ5IGlzIG5vdCBhbGxvd2VkIHRvIGNoYW5nZSBvciBtaWdodCBiZWNv
bWUgbGFyZ2UgKG5vIGluLWxpc3QpIGFuZCB0aGUgcXVlcnkgcmVzdWx0cyBhcmUgdG9vIGxvbmcg
Zm9yIHNvcnRpbmcsIHdlIHVzZWQgdGVtcG9yYXJ5IHRhYmxlcyBsaWtlIHRoaXMgKGNvbnZlcnRl
ZCBpbnRvIHlvdXIgZXhhbXBsZSk6DQogDQpTUUw+IGNyZWF0ZSBnbG9iYWwgdGVtcG9yYXJ5IHRh
YmxlIHRtcF9zaG9wcyAoU0hPUF9JRCBOVU1CRVIgTk9UIE5VTEwpIG9uIGNvbW1pdCBkZWxldGUg
cm93czsNClRhYmxlIGNyZWF0ZWQuDQpTUUw+IGNyZWF0ZSB1bmlxdWUgaW5kZXggaV90bXBfc2hv
cHMgb24gdG1wX3Nob3BzKHNob3BfaWQpOw0KSW5kZXggY3JlYXRlZC4NClNRTD4NClNRTD4gY3Jl
YXRlIGdsb2JhbCB0ZW1wb3JhcnkgdGFibGUgdG1wX3Byb2RzIChQUk9EVUNUX0lEIE5VTUJFUiBO
T1QgTlVMTCkgb24gY29tbWl0IGRlbGV0ZSByb3dzOw0KVGFibGUgY3JlYXRlZC4NClNRTD4gY3Jl
YXRlIHVuaXF1ZSBpbmRleCBpX3RtcF9wcm9kcyBvbiB0bXBfcHJvZHMocHJvZHVjdF9pZCk7DQpJ
bmRleCBjcmVhdGVkLg0KU1FMPg0KU1FMPiBpbnNlcnQgaW50byB0bXBfc2hvcHMNCiAgMiAgIHNl
bGVjdCA0MCBzaG9wX2lkIGZyb20gZHVhbCB1bmlvbiBhbGwgc2VsZWN0IDIwIHNob3BfaWQgZnJv
bSBkdWFsIHVuaW9uIGFsbCBzZWxlY3QgMzAgc2hvcF9pZCBmcm9tIGR1YWw7DQozIHJvd3MgY3Jl
YXRlZC4NClNRTD4NClNRTD4gaW5zZXJ0IGludG8gdG1wX3Byb2RzDQogIDIgICBzZWxlY3QgMTQw
IHByb2R1Y3RfaWQgZnJvbSBkdWFsIHVuaW9uIGFsbCBzZWxlY3QgNDAgcHJvZHVjdF9pZCBmcm9t
IGR1YWwgdW5pb24gYWxsIHNlbGVjdCA3MCBwcm9kdWN0X2lkIGZyb20gZHVhbA0KdW5pb24gYWxs
IHNlbGVjdCAxMzAgcHJvZHVjdF9pZCBmcm9tIGR1YWw7DQo0IHJvd3MgY3JlYXRlZC4NCg0Kbm93
IHRyeSB0aGlzIChjb3JyZWxhdGVkIHN1YnF1ZXJ5IHdpdGggdW5pcXVlIGluZGV4KToNCiANClNR
TD4gc2V0IGF1dG90cmFjZSBvbiBleHBsYWluDQpTUUw+IHNlbGVjdCB0aW1lLCBzaG9wX2lkLCBw
cm9kdWN0X2lkDQogIDIgIGZyb20gc2FsZXMgc2FsDQogIDMgIHdoZXJlIHRpbWUgYmV0d2VlbiB0
cnVuYyhzeXNkYXRlKSBhbmQgc3lzZGF0ZQ0KICA0ICAgIGFuZCBzaG9wX2lkIGluICggc2VsZWN0
ICogZnJvbSB0bXBfc2hvcHMgcyB3aGVyZSBzYWwuc2hvcF9pZCA9IHMuc2hvcF9pZCkNCiAgNSAg
ICBhbmQgcHJvZHVjdF9pZCBpbiAoIHNlbGVjdCAqIGZyb20gdG1wX3Byb2RzIHAgd2hlcmUgc2Fs
LnByb2R1Y3RfaWQgPSBwLnByb2R1Y3RfaWQpDQogIDYgIG9yZGVyIGJ5IHRpbWUsIHNob3BfaWQs
IHByb2R1Y3RfaWQ7DQpUSU1FICAgICAgICAgU0hPUF9JRCBQUk9EVUNUX0lEDQotLS0tLS0tLS0g
LS0tLS0tLS0tLSAtLS0tLS0tLS0tDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgMTQwDQoy
Mi1PQ1QtMDQgICAgICAgICAzMCAgICAgICAgMTMwDQoyMi1PQ1QtMDQgICAgICAgICAyMCAgICAg
ICAgIDcwDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgIDQwDQoyMi1PQ1QtMDQgICAgICAg
ICA0MCAgICAgICAgMTQwDQoyMi1PQ1QtMDQgICAgICAgICAzMCAgICAgICAgMTMwDQoyMi1PQ1Qt
MDQgICAgICAgICAyMCAgICAgICAgIDcwDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgIDQw
DQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgMTQwDQoyMi1PQ1QtMDQgICAgICAgICAzMCAg
ICAgICAgMTMwDQoyMi1PQ1QtMDQgICAgICAgICAyMCAgICAgICAgIDcwDQoyMi1PQ1QtMDQgICAg
ICAgICA0MCAgICAgICAgIDQwDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgMTQwDQoyMi1P
Q1QtMDQgICAgICAgICAzMCAgICAgICAgMTMwDQoyMi1PQ1QtMDQgICAgICAgICAyMCAgICAgICAg
IDcwDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgIDQwDQoyMi1PQ1QtMDQgICAgICAgICA0
MCAgICAgICAgMTQwDQoyMi1PQ1QtMDQgICAgICAgICAzMCAgICAgICAgMTMwDQoyMi1PQ1QtMDQg
ICAgICAgICAyMCAgICAgICAgIDcwDQoyMi1PQ1QtMDQgICAgICAgICA0MCAgICAgICAgIDQwDQoy
MCByb3dzIHNlbGVjdGVkLg0KDQpFeGVjdXRpb24gUGxhbg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgMCAgICAgIFNFTEVDVCBT
VEFURU1FTlQgT3B0aW1pemVyPUFMTF9ST1dTIChDb3N0PTQgQ2FyZD0zNzIgQnl0ZXM9MTUyNTIp
DQogICAxICAgIDAgICBGSUxURVINCiAgIDIgICAgMSAgICAgTkVTVEVEIExPT1BTIChDb3N0PTQg
Q2FyZD0zNzIgQnl0ZXM9MTUyNTIpDQogICAzICAgIDIgICAgICAgTkVTVEVEIExPT1BTIChDb3N0
PTMgQ2FyZD0xMTQgQnl0ZXM9MzE5MikNCiAgIDQgICAgMyAgICAgICAgIElOREVYIChSQU5HRSBT
Q0FOKSBPRiAnU0FMRVNfUEsnIChVTklRVUUpIChDb3N0PTMgQ2FyZD0zMTQgQnl0ZXM9NDcxMCkN
CiAgIDUgICAgMyAgICAgICAgIElOREVYIChVTklRVUUgU0NBTikgT0YgJ0lfVE1QX1BST0RTJyAo
VU5JUVVFKQ0KICAgNiAgICAyICAgICAgIElOREVYIChVTklRVUUgU0NBTikgT0YgJ0lfVE1QX1NI
T1BTJyAoVU5JUVVFKQ0KIA0KIA0KT2YgY291cnNlIHRoZXJlIGlzIGFuIGVub3Jtb3VzIG92ZXJo
ZWFkIGZvciBmaWxsaW5nIHRoZSB0bXAtdGFibGVzLCBzbyB0aGlzIGFwcHJvYWNoIGlzIG9ubHkg
dmFsaWQgZm9yIHNpdHVhdGlvbnMgd2hlcmUgdGhlIHN1YnF1ZXJ5IHNlbGVjdGlvbnMgbWFudWFs
bHkgdGFrZXMgcGxhY2Ugb25jZSBmb3IgYSBxdWVyeSAob3Igc2V0IG9mIHF1ZXJpZXMpLiANCiAN
ClJlZ2FyZHMgJiBoYXZlIGEgbmljZSB3ZWVrZW5kDQpQZXRlcg0KDQoJDQoJLS0tLS1PcmlnaW5h
bCBNZXNzYWdlLS0tLS0NCglGcm9tOiBvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZyBbbWFp
bHRvOm9yYWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMub3JnXQ0KCU9uIEJlaGFsZiBPZiBFZGdhciBD
aHVwaXQNCglTZW50OiBGcmlkYXksIE9jdG9iZXIgMjIsIDIwMDQgODozOCBBTQ0KCVRvOiBvcmFj
bGUtbEBmcmVlbGlzdHMub3JnDQoJU3ViamVjdDogU09SVCBPUkRFUiBCWSBlbGltaW5hdGlvbg0K
CQ0KCURlYXIgTGlzdCwNCgkNCglJJ2FtIHJlc2VhcmNoaW5nIGRpZmZlcmVudCB0eXBlcyBvZiBT
T1JUIE9SREVSIEJZIHN0ZXAgZWxpbWluYXRpb24uDQoJVGhpcyBwYXJ0aWN1bGFyIHByb2JsZW0g
Ym90aGVycyBtZSBmb3IgYSBmZXcgZGF5cywgYnV0IEkgc3RpbGwgY2FuJ3QNCglmaW5kIGEgY29y
cmVjdCB3YXkgdG8gZWxpbWluYXRlIFNPUlQgT1JERVIgQlkgc3RlcC4NCgkNCglTdXBwb3NlIEkg
aGF2ZSBhIGxhcmdlIHRhYmxlIHRoYXQgaXMgYWx3YXlzIHF1ZXJpZWQgYnkgcHJpbWFyeSBrZXkg
YW5kDQoJSSB3YW50IHRvIHJlY2VpdmUgcmVzdWx0cyBpbiBQSyBvcmRlcnMgZmlyc3QgcXVlcnkg
ZG9lcyBleGFjdGx5IHRoZQ0KCXNhbWUgYXMgc2Vjb25kIHF1ZXJ5LCBidXQgZmlyc3QgcXVlcnkg
aW4gbXkgdGVzdCBkb2VzIDcgTElPcywgYnV0DQoJc2Vjb25kIDE0IExJT3MgKyBzb3J0Lg0KCQ0K
CUlzIHRoZXJlIGEgd2F5IHRvIGVsaW1pbmF0ZSBTT1JUIE9SREVSIEJZIHN0ZXAgZnJvbSB0aGUg
c2Vjb25kIHF1ZXJ5Pw0KCVRoYW5rcyBpbiBhZHZhbmNlLg0KCQ0KCS8qIFFVRVJZICMxICovDQoJ
DQoJc2VsZWN0IHRpbWUsIHNob3BfaWQsIHByb2R1Y3RfaWQNCglmcm9tIHNhbGVzDQoJd2hlcmUg
dGltZSBiZXR3ZWVuIHRydW5jKHN5c2RhdGUpIGFuZCBzeXNkYXRlDQoJIGFuZCBzaG9wX2lkIGlu
ICg0MCwyMCwzMCkNCgkgYW5kIHByb2R1Y3RfaWQgaW4gKDE0MCw0MCw3MCwxMzApDQoJb3JkZXIg
YnkgdGltZSwgc2hvcF9pZCwgcHJvZHVjdF9pZA0KCQ0KCWNhbGwgICAgIGNvdW50ICAgICAgIGNw
dSAgICBlbGFwc2VkICAgICAgIGRpc2sgICAgICBxdWVyeSAgICBjdXJyZW50DQoJcm93cw0KCS0t
LS0tLS0gLS0tLS0tICAtLS0tLS0tLSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0gLS0tLS0tLS0tLSAt
LS0tLS0tLS0tDQoJLS0tLS0tLS0tLQ0KCVBhcnNlICAgICAgICAxICAgICAgMC4wMCAgICAgICAw
LjAwICAgICAgICAgIDAgICAgICAgICAgMCAgICAgICAgICAwDQoJMA0KCUV4ZWN1dGUgICAgICAx
ICAgICAgMC4wMCAgICAgICAwLjAwICAgICAgICAgIDAgICAgICAgICAgMCAgICAgICAgICAwDQoJ
MA0KCUZldGNoICAgICAgICAzICAgICAgMC4wMCAgICAgICAwLjAwICAgICAgICAgIDAgICAgICAg
ICAgNyAgICAgICAgICAwDQoJMTcNCgktLS0tLS0tIC0tLS0tLSAgLS0tLS0tLS0gLS0tLS0tLS0t
LSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0gLS0tLS0tLS0tLQ0KCS0tLS0tLS0tLS0NCgl0b3RhbCAg
ICAgICAgNSAgICAgIDAuMDAgICAgICAgMC4wMCAgICAgICAgICAwICAgICAgICAgIDcgICAgICAg
ICAgMA0KCTE3DQoJDQoJTWlzc2VzIGluIGxpYnJhcnkgY2FjaGUgZHVyaW5nIHBhcnNlOiAwDQoJ
T3B0aW1pemVyIG1vZGU6IEFMTF9ST1dTDQoJUGFyc2luZyB1c2VyIGlkOiA2Mw0KCQ0KCVJvd3Mg
ICAgIFJvdyBTb3VyY2UgT3BlcmF0aW9uDQoJLS0tLS0tLSAgLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJICAgMTcgIEZJTFRFUiAgKGNyPTcgcHI9
MCBwdz0wIHRpbWU9MjU4IHVzKQ0KCSAgIDE3ICAgSU5ERVggUkFOR0UgU0NBTiBTQUxFU19QSyAo
Y3I9NyBwcj0wIHB3PTAgdGltZT0xOTYNCgl1cykob2JqZWN0IGlkIDIyNzMxMykNCgkNCgkvKiBR
VUVSWSAjMiAqLw0KCQ0KCXdpdGggcTEgYXMgKCBzZWxlY3QgNDAgZnJvbSBkdWFsIHVuaW9uIGFs
bCBzZWxlY3QgMjAgZnJvbSBkdWFsIHVuaW9uDQoJYWxsIHNlbGVjdCAzMCBmcm9tIGR1YWwgKSwN
CgkgICBxMiBhcyAoIHNlbGVjdCAxNDAgZnJvbSBkdWFsIHVuaW9uIGFsbCBzZWxlY3QgNDAgZnJv
bSBkdWFsIHVuaW9uDQoJYWxsIHNlbGVjdCA3MCBmcm9tIGR1YWwgdW5pb24gYWxsIHNlbGVjdCAx
MzAgZnJvbSBkdWFsICkNCglzZWxlY3QgdGltZSwgc2hvcF9pZCwgcHJvZHVjdF9pZA0KCWZyb20g
c2FsZXMNCgl3aGVyZSB0aW1lIGJldHdlZW4gdHJ1bmMoc3lzZGF0ZSkgYW5kIHN5c2RhdGUNCgkg
YW5kIHNob3BfaWQgaW4gKCBzZWxlY3QgKiBmcm9tIHExICkNCgkgYW5kIHByb2R1Y3RfaWQgaW4g
KCBzZWxlY3QgKiBmcm9tIHEyICkNCglvcmRlciBieSB0aW1lLCBzaG9wX2lkLCBwcm9kdWN0X2lk
DQoJDQoJY2FsbCAgICAgY291bnQgICAgICAgY3B1ICAgIGVsYXBzZWQgICAgICAgZGlzayAgICAg
IHF1ZXJ5ICAgIGN1cnJlbnQNCglyb3dzDQoJLS0tLS0tLSAtLS0tLS0gIC0tLS0tLS0tIC0tLS0t
LS0tLS0gLS0tLS0tLS0tLSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0NCgktLS0tLS0tLS0tDQoJUGFy
c2UgICAgICAgIDEgICAgICAwLjAwICAgICAgIDAuMDIgICAgICAgICAgMCAgICAgICAgICAwICAg
ICAgICAgIDANCgkwDQoJRXhlY3V0ZSAgICAgIDEgICAgICAwLjAwICAgICAgIDAuMDAgICAgICAg
ICAgMCAgICAgICAgICAwICAgICAgICAgIDANCgkwDQoJRmV0Y2ggICAgICAgIDMgICAgICAwLjAw
ICAgICAgIDAuMDAgICAgICAgICAgMCAgICAgICAgIDE0ICAgICAgICAgIDANCgkxNw0KCS0tLS0t
LS0gLS0tLS0tICAtLS0tLS0tLSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0gLS0tLS0tLS0tLSAtLS0t
LS0tLS0tDQoJLS0tLS0tLS0tLQ0KCXRvdGFsICAgICAgICA1ICAgICAgMC4wMCAgICAgICAwLjAz
ICAgICAgICAgIDAgICAgICAgICAxNCAgICAgICAgICAwDQoJMTcNCgkNCglNaXNzZXMgaW4gbGli
cmFyeSBjYWNoZSBkdXJpbmcgcGFyc2U6IDANCglPcHRpbWl6ZXIgbW9kZTogQUxMX1JPV1MNCglQ
YXJzaW5nIHVzZXIgaWQ6IDYzDQoJDQoJUm93cyAgICAgUm93IFNvdXJjZSBPcGVyYXRpb24NCgkt
LS0tLS0tICAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0NCgkgICAxNyAgU09SVCBPUkRFUiBCWSAoY3I9MTQgcHI9MCBwdz0wIHRpbWU9OTIyMCB1cykN
CgkgICAxNyAgIEhBU0ggSk9JTiBTRU1JIChjcj0xNCBwcj0wIHB3PTAgdGltZT04Nzc5IHVzKQ0K
CSAgIDM5ICAgIE5FU1RFRCBMT09QUyAgKGNyPTE0IHByPTAgcHc9MCB0aW1lPTI4MjUgdXMpDQoJ
ICAgIDMgICAgIFZJRVcgIChjcj0wIHByPTAgcHc9MCB0aW1lPTYzNCB1cykNCgkgICAgMyAgICAg
IFNPUlQgVU5JUVVFIChjcj0wIHByPTAgcHc9MCB0aW1lPTYwOCB1cykNCgkgICAgMyAgICAgICBW
SUVXICAoY3I9MCBwcj0wIHB3PTAgdGltZT05OSB1cykNCgkgICAgMyAgICAgICAgVU5JT04tQUxM
ICAoY3I9MCBwcj0wIHB3PTAgdGltZT04MyB1cykNCgkgICAgMSAgICAgICAgIEZBU1QgRFVBTCAg
KGNyPTAgcHI9MCBwdz0wIHRpbWU9OSB1cykNCgkgICAgMSAgICAgICAgIEZBU1QgRFVBTCAgKGNy
PTAgcHI9MCBwdz0wIHRpbWU9NSB1cykNCgkgICAgMSAgICAgICAgIEZBU1QgRFVBTCAgKGNyPTAg
cHI9MCBwdz0wIHRpbWU9NSB1cykNCgkgICAzOSAgICAgSU5ERVggUkFOR0UgU0NBTiBPQkojKDIy
NzMxMykgKGNyPTE0IHByPTAgcHc9MCB0aW1lPTE4OTcNCgl1cykob2JqZWN0IGlkIDIyNzMxMykN
CgkgICAgNCAgICBWSUVXICAoY3I9MCBwcj0wIHB3PTAgdGltZT0xOTQgdXMpDQoJICAgIDQgICAg
IFZJRVcgIChjcj0wIHByPTAgcHc9MCB0aW1lPTE3OSB1cykNCgkgICAgNCAgICAgIFVOSU9OLUFM
TCAgKGNyPTAgcHI9MCBwdz0wIHRpbWU9MTYzIHVzKQ0KCSAgICAxICAgICAgIEZJTFRFUiAgKGNy
PTAgcHI9MCBwdz0wIHRpbWU9MzMgdXMpDQoJICAgIDEgICAgICAgIEZBU1QgRFVBTCAgKGNyPTAg
cHI9MCBwdz0wIHRpbWU9NiB1cykNCgkgICAgMSAgICAgICBGSUxURVIgIChjcj0wIHByPTAgcHc9
MCB0aW1lPTIzIHVzKQ0KCSAgICAxICAgICAgICBGQVNUIERVQUwgIChjcj0wIHByPTAgcHc9MCB0
aW1lPTYgdXMpDQoJICAgIDEgICAgICAgRklMVEVSICAoY3I9MCBwcj0wIHB3PTAgdGltZT0yMSB1
cykNCgkgICAgMSAgICAgICAgRkFTVCBEVUFMICAoY3I9MCBwcj0wIHB3PTAgdGltZT02IHVzKQ0K
CSAgICAxICAgICAgIEZJTFRFUiAgKGNyPTAgcHI9MCBwdz0wIHRpbWU9MTkgdXMpDQoJICAgIDEg
ICAgICAgIEZBU1QgRFVBTCAgKGNyPTAgcHI9MCBwdz0wIHRpbWU9NCB1cykNCgkNCglIZXJlIGlz
IG15IHRlc3QgY2FzZToNCgkNCgkvKg0KCWRyb3AgdGFibGUgc2FsZXM7DQoJKi8NCgljcmVhdGUg
dGFibGUgc2FsZXMoIHRpbWUgZGF0ZSBub3QgbnVsbCwgcHJvZHVjdF9pZCBudW1iZXIgbm90IG51
bGwsDQoJc2hvcF9pZCBudW1iZXIgbm90IG51bGwsIHNhbGVzIG51bWJlcigqLDMpIG5vdCBudWxs
LA0KCSAgICAgICAgICAgICAgICAgIGNvbnN0cmFpbnQgc2FsZXNfcGsgcHJpbWFyeSBrZXkgKHRp
bWUsc2hvcF9pZCxwcm9kdWN0X2lkKQ0KCSk7DQoJDQoJaW5zZXJ0IGludG8gc2FsZXMNCglzZWxl
Y3Qgc3lzZGF0ZS0oMS8yNC82KSoocm93bnVtLzcpLCBtb2Qocm93bnVtLCAxNTApLCBtb2Qocm93
bnVtLCA1MCksDQoJdHJ1bmMoZGJtc19yYW5kb20udmFsdWUqMTAwMDAsMykNCglmcm9tIGFsbF9v
YmplY3RzDQoJLw0KCQ0KCWluc2VydCBpbnRvIHNhbGVzDQoJc2VsZWN0IHRpbWUtMTAwLHByb2R1
Y3RfaWQsc2hvcF9pZCxzYWxlcyBmcm9tIHNhbGVzDQoJLw0KCQ0KCWJlZ2luDQoJZGJtc19zdGF0
cy5nYXRoZXJfdGFibGVfc3RhdHMob3dubmFtZSA9PiBvcmFfbG9naW5fdXNlciwgdGFibmFtZSA9
Pg0KCSdTQUxFUycsIGVzdGltYXRlX3BlcmNlbnQgPT4gMTAwLCBtZXRob2Rfb3B0ID0+ICdGT1Ig
QUxMIElOREVYRUQNCglDT0xVTU5TIFNJWkUgQVVUTycsIGNhc2NhZGUgPT4gVFJVRSApOw0KCWVu
ZDsNCgkvDQoJDQoJLS0NCglFZGdhcg0KCS0tDQoJaHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL3dl
YnBhZ2Uvb3JhY2xlLWwNCgkNCgktLQ0KCWh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdl
L29yYWNsZS1sDQoJDQoNCg==
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 22 2004 - 13:03:54 CDT