Re: sql question

--{56703FBA-6707-4823-B54F-C1F79FFDC9D6} Content-Type: text/plain; charset="UTF-8"

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--{56703FBA-6707-4823-B54F-C1F79FFDC9D6} Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64

DQoNCg0KDQpIaSBEYXZpZCwNCg0KRG9lcyB0aGUgZmlyc3QgcXVlcnkgInJ1biB0byBjb21wbGV0 aW9uIiBpbiAxIHNlY29uZCwgb3IgImJlZ2lucyByZXR1cm5pbmcNCnJlc3VsdHMiIGluIDEgc2Vj b25kPz8/DQoNCklFOiBIYXZlIHlvdSBydW4gdGhlIHF1ZXJ5IGluIFNRTCpQbHVzIGFuZCB3YWl0 ZWQgZm9yIHRoZSBwcm9tcHQgdG8gcmV0dXJuPw0KSSBzdXNwZWN0IGl0IHdpbGwgc3Bvb2wgZm9y IGEgd2hpbGUuDQoNClNvbWUgcHJvZ3JhbXMgKGxpa2UgVE9BRCBmb3IgZXhhbXBsZSkgYXBwZWFy IHRvIGhhdmUgZmluaXNoZWQgdGhlIHF1ZXJ5IGFzDQpzb29uIGFzIHRoZSBmaXJzdCBwYWdlIG9m IHJlc3VsdHMgYXJlIGluLCBidXQgd2hlbiB5b3Ugc2Nyb2xsIGRvd24gaXQNCnJlcXVlc3RzIG1v cmUgcmVjb3JkcyBmcm9tIHRoZSBkYXRhYmFzZS4gIFNlbGVjdGluZyBDT1VOVCgqKSBjYW5ub3Qg cmV0dXJuDQp1bnRpbCB0aGUgZW50aXJlIHNlYXJjaCBpcyBjb21wbGV0ZSBiZWNhdXNlIGl0IG5l ZWRzIHRoZSB0b3RhbCBudW1iZXIuDQoNCklmIHRoZSBmaXJzdCBxdWVyeSBnZW51aW5lbHkgcnVu cyB0byBjb21wbGV0aW9uIGluIDEgc2Vjb25kIHRob3VnaCwgdGhlbg0KcG9zdCB0aGUgZXhwbGFp biBwbGFucyBhcyBzdWdnZXN0ZWQgYnkgRGVubmlzLiAgSSBzdXNwZWN0IHRob3VnaCB0aGF0IHlv dQ0KYXJlIHNpbXBseSBtaXN1bmRlcnN0YW5kaW5nIHRoZSAxIHNlY29uZCByZXN1bHQuDQoNCklN UE9SVEFOVCBTSURFIElTU1VFOg0KQWxzbywgbG9va2luZyBhdCB5b3VyIHF1ZXJ5IEkgc3VzcGVj dCB5b3Ugd2lsbCBnZXQgYSBjYXJ0ZXNpYW4gam9pbiBpbiB0aGUNCmZpcnN0IHBhcnQgb2YgeW91 ciB3aGVyZSBjbGF1c2UgLSBGb3IgZWFjaCByZWNvcmQgaW4gInMiIHdoZXJlIGF3YXJkX251bWJl cg0KPSAnQUxMJyB5b3Ugd2lsbCBnZXQgZXZlcnkgcm93IGZyb20gImIiIC0gYSBtYXNzaXZlIHJl c3VsdCBzZXQgdGhhdA0KcHJvYmFibHkgZXhwbGFpbnMgeW91ciBsb25nIHJ1bm5pbmcgcXVlcnku ICBTb21lb25lIGVsc2UgbWlnaHQgd2FudCB0bw0KY29uZmlybSBteSBzdXNwaWNpb24/ICBUaGUg ZXhwbGFpbiBwbGFuIG1pZ2h0IGV2ZW4gaW5kaWNhdGUgdGhhdCBhDQpjYXJ0ZXNpYW4gam9pbiBp cyBvY2N1cmluZywgYnV0IEknbSBub3Qgc3VyZSBiZWNhdXNlIG9mIHRoZSBvdGhlciBjbGF1c2Vz Lg0KDQpSZWdhcmRzLA0KICAgICAgTWFyay4NCg0KDQoNCg0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN CiAgICAgICAgICAgICAgICAgICAgICAiRGF2aWQgQm95ZCIgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgPGRhdmlkYjE1OEBo b3RtYWkgICAgICAgIFRvOiAgICAgICBNdWx0aXBsZSByZWNpcGllbnRzIG9mIGxpc3QgT1JBQ0xF LUwgPE9SQUNMRS1MQGZhdGNpdHkuY29tPiAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAg ICAgICAgICAgIGwuY29tPiAgICAgICAgICAgICAgICAgICBjYzogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBTZW50IGJ5OiAgICAgICAgICAgICAgICAg U3ViamVjdDogIHNxbCBxdWVzdGlvbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgbWwt ZXJyb3JzQGZhdGNpdHkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAg ICAgICAgICAgICAgICAgICAgIC5jb20gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIA0KICAgICAgICAgICAgICAgICAgICAgIDEzLzAxLzIwMDQgMDY6MTQgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBQbGVhc2Ug cmVzcG9uZCB0byAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAg ICAgICAgICAgICAgICAgT1JBQ0xFLUwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQoNCg0KDQoNCkhpIExpc3QsDQoNCkkgaGF2ZSBmb2xsb3dpbmcgc3FsIHRoYXQgcnVucyBpbiAx IHNlYzoNCg0KU0VMRUNUIGIuKiBGUk9NIFJGX0JBTEFOQ0VfVCBiLCByZl9zZWN1cml0eV9ieV9k Y2VpZCBzDQpXSEVSRQ0KKHMuYXdhcmRfbnVtYmVyID0gJ0FMTCcpDQpPUiAoYi5hd2FyZF9udW1i ZXIgPSBzLmF3YXJkX251bWJlciBBTkQgcy5wcm9qZWN0X251bWJlciA9ICdBTEwnKQ0KT1IgKGIu YXdhcmRfbnVtYmVyID0gcy5hd2FyZF9udW1iZXIgQU5EIGIucHJvamVjdF9udW1iZXI9DQpzLnBy b2plY3RfbnVtYmVyIEFORCBzLnRhc2tfbnVtYmVyID0gJ0FMTCcpDQpPUiAoYi5hd2FyZF9udW1i ZXIgPSBzLmF3YXJkX251bWJlciBBTkQgYi5wcm9qZWN0X251bWJlcj0NCnMucHJvamVjdF9udW1i ZXIgQU5EIGIudGFza19udW1iZXIgPSBzLnRhc2tfbnVtYmVyKQ0KDQpIb3dldmVyLCB3aGVuIEkg dHJ5IHRvIGNvdW50IGFib3ZlIHF1ZXJ5IGFzIGZvbGxvd2luZywgaXQgaGFuZ3MuICBEb2VzDQpz b21lb25lIGhhdmUgYW55IGlkZWFzPw0KDQpTRUxFQ1QgY291bnQoYi5hd2FyZF9udW1iZXIpIEZS T00gUkZfQkFMQU5DRV9UIGIsIHJmX3NlY3VyaXR5X2J5X2RjZWlkIHMNCldIRVJFDQoocy5hd2Fy ZF9udW1iZXIgPSAnQUxMJykNCk9SIChiLmF3YXJkX251bWJlciA9IHMuYXdhcmRfbnVtYmVyIEFO RCBzLnByb2plY3RfbnVtYmVyID0gJ0FMTCcpDQpPUiAoYi5hd2FyZF9udW1iZXIgPSBzLmF3YXJk X251bWJlciBBTkQgYi5wcm9qZWN0X251bWJlcj0NCnMucHJvamVjdF9udW1iZXIgQU5EIHMudGFz a19udW1iZXIgPSAnQUxMJykNCk9SIChiLmF3YXJkX251bWJlciA9IHMuYXdhcmRfbnVtYmVyIEFO RCBiLnByb2plY3RfbnVtYmVyPQ0Kcy5wcm9qZWN0X251bWJlciBBTkQgYi50YXNrX251bWJlciA9 IHMudGFza19udW1iZXIpDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fDQpIaWdoLXNwZWVkIHVzZXJz4oCUYmUgbW9yZSBl ZmZpY2llbnQgb25saW5lIHdpdGggdGhlIG5ldyBNU04gUHJlbWl1bSBJbnRlcm5ldA0KDQpTb2Z0 d2FyZS4gaHR0cDovL2pvaW4ubXNuLmNvbS8/cGdtYXJrZXQ9ZW4tdXMmcGFnZT1ieW9hL3ByZW0m U1Q9MQ0KDQotLQ0KUGxlYXNlIHNlZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8v d3d3Lm9yYWZhcS5uZXQNCi0tDQpBdXRob3I6IERhdmlkIEJveWQNCiAgSU5FVDogZGF2aWRiMTU4 QGhvdG1haWwuY29tDQoNCkZhdCBDaXR5IE5ldHdvcmsgU2VydmljZXMgICAgLS0gODU4LTUzOC01 MDUxIGh0dHA6Ly93d3cuZmF0Y2l0eS5jb20NClNhbiBEaWVnbywgQ2FsaWZvcm5pYSAgICAgICAg LS0gTWFpbGluZyBsaXN0IGFuZCB3ZWIgaG9zdGluZyBzZXJ2aWNlcw0KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpU byBSRU1PVkUgeW91cnNlbGYgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBhbiBFLU1haWwg bWVzc2FnZQ0KdG86IExpc3RHdXJ1QGZhdGNpdHkuY29tIChub3RlIEVYQUNUIHNwZWxsaW5nIG9m ICdMaXN0R3VydScpIGFuZCBpbg0KdGhlIG1lc3NhZ2UgQk9EWSwgaW5jbHVkZSBhIGxpbmUgY29u dGFpbmluZzogVU5TVUIgT1JBQ0xFLUwNCihvciB0aGUgbmFtZSBvZiBtYWlsaW5nIGxpc3QgeW91 IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4gIFlvdSBtYXkNCmFsc28gc2VuZCB0aGUgSEVMUCBj b21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZykuDQoNCg==

--{56703FBA-6707-4823-B54F-C1F79FFDC9D6}--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  INET: mrichard_at_transurban.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).