RE: PL/SQL question
- From: manoj.gurnani@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Sep 2005 18:41:44 +0530
DQoNCg0KDQoNCmxha2ggaXMgMTAwMDAwDQoNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgIA0KICAgICAgICAgICAgICAgICAgICAgICJNZXJjYWRhbnRlLCBUaG9tYXMgRiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAg
ICAgIChMQUJPUikiICAgICAgICAgICAgICAgICAgICAgICAgICAgVG86ICAgICAgPEpvaG4uSGFs
bGFzQGdiLnZvZGFmb25lLmNvLnVrPiwgPGRhdmlkc2hhcnBsZXNAZ21haWwuY29tPiwgICAgICAg
ICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIDxUaG9tYXMuTWVyY2FkYW50ZUBs
YWJvci5zICAgICAgICAgPG1hbm9qLmd1cm5hbmlAcG9sYXJpcy5jby5pbj4gICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAg
ICAgICAgICAgICAgIHRhdGUubnkudXM+ICAgICAgICAgICAgICAgICAgICAgICAgY2M6ICAgICAg
PG9yYWNsZS1sQGZyZWVsaXN0cy5vcmc+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIFNlbnQgYnk6ICAg
ICAgICAgICAgICAgICAgICAgICAgICAgU3ViamVjdDogUkU6IFBML1NRTCBxdWVzdGlvbiAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
ICAgICAgICAgICAgICAgICAgICAgIG9yYWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMuICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIG9y
ZyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIDA5LzI4LzIwMDUgMDY6MDkg
UE0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAg
ICAgICAgICAgICAgICAgIFBsZWFzZSByZXNwb25kIHRvICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIFRob21hcy5N
ZXJjYWRhbnRlICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
IA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIA0KDQoNCg0KDQpJ4oCZdmUgYmVlbiBvbiB0aGlzIGxpc3QgZm9yIHllYXJzIGFu
ZCBkb27igJl0IGtub3cgd2hhdCBhIGxha2ggaXMuICBJcyB0aGlzDQpzb21lIGtpbmQgb2YgZm91
ciBsZWdnZWQgY3JlYXR1cmUgdGhhdCBsaXZlcyBpbiB0aGUgQWxwcz8gIEoNCg0KDQpGcm9tOiBv
cmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZyBbbWFpbHRvOm9yYWNsZS1sLWJvdW5jZUBmcmVl
bGlzdHMub3JnXQ0KT24gQmVoYWxmIE9mIEhhbGxhcywgSm9obiwgVGVjaCBEZXYNClNlbnQ6IFdl
ZG5lc2RheSwgU2VwdGVtYmVyIDI4LCAyMDA1IDc6MzIgQU0NClRvOiBkYXZpZHNoYXJwbGVzQGdt
YWlsLmNvbTsgbWFub2ouZ3VybmFuaUBwb2xhcmlzLmNvLmluDQpDYzogb3JhY2xlLWxAZnJlZWxp
c3RzLm9yZw0KU3ViamVjdDogUkU6IFBML1NRTCBxdWVzdGlvbg0KDQpJZiB5b3UgaGF2ZSBiZWVu
IG9uIHRoaXMgbGlzdCBmb3IgYSB3aGlsZSB5b3Uga25vdyB3aGF0IGEgbGFraCBpcw0KDQoNCkZy
b206IG9yYWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMub3JnIFttYWlsdG86b3JhY2xlLWwtYm91bmNl
QGZyZWVsaXN0cy5vcmddDQpPbiBCZWhhbGYgT2YgRGF2aWQgU2hhcnBsZXMNClNlbnQ6IDI4IFNl
cHRlbWJlciAyMDA1IDEyOjIyDQpUbzogbWFub2ouZ3VybmFuaUBwb2xhcmlzLmNvLmluDQpDYzog
b3JhY2xlLWxAZnJlZWxpc3RzLm9yZw0KU3ViamVjdDogUmU6IFBML1NRTCBxdWVzdGlvbg0KDQpw
b3N0IHlvdXIgY29kZSwgY2FuIHRha2UgYSBsb29rIGF0IGluIHRoZW4gKHAucy4gbm90IG1hbnkg
cGVvcGxlIHdpbGwga25vdw0Kd2hhdCBhIGxha2ggaXMsIGl0IGlzbnQgdXNlZCBhcGFydCBmcm9t
IGluIHRoZSBzdWIgY29udGluZW50IEkgYmVsaWV2ZSkNCk9uIDkvMjgvMDUsIG1hbm9qLmd1cm5h
bmlAcG9sYXJpcy5jby5pbiA8bWFub2ouZ3VybmFuaUBwb2xhcmlzLmNvLmluID4NCndyb3RlOg0K
DQoNCkhpLA0KICAgICBJJ3ZlIGEgY3Vyc29yIHdoaWNoIHJldHJpZXZlcyBhYm91dCAzIGxha2gg
cmVjcyBmcm9tIGEgdGFibGUuKG1hc3RlcikNCmJhc2VkIG9uIGNvbHVtbiB2YWx1ZSByZXRyaWV2
ZWQgZnJvbSBjdXJzb3IgZm9yIGVhY2ggcmVjLHRoZXJlIGFyZSBvdGhlcg0KdGFibGVzIChkZXRh
aWwpIHRvIGJlIHVwZGF0ZWQuDQpUaGUgZGV0YWlsIHRhYmxlcyBoYXZlIGxhcmdlIHZvbHVtZXMg
b2YgZGF0YS4NCnRoZSBxdWVzdGlvbiBpcyBob3cgY2FuIHRoZSBwZXJmb3JtYW5jZSBiZSBpbXBy
b3ZlZCB0byBhY2hpZXZlIHRoZSBkZXNpcmVkDQpyZXN1bHQuDQoNCg0KVGhpcyBlLU1haWwgbWF5
IGNvbnRhaW4gcHJvcHJpZXRhcnkgYW5kIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbiBhbmQgaXMg
c2VudCBmb3IgdGhlIGludGVuZGVkIHJlY2lwaWVudChzKSBvbmx5LiANCklmIGJ5IGFuIGFkZHJl
c3Npbmcgb3IgdHJhbnNtaXNzaW9uIGVycm9yIHRoaXMgbWFpbCBoYXMgYmVlbiBtaXNkaXJlY3Rl
ZCB0byB5b3UsIHlvdSBhcmUgcmVxdWVzdGVkIHRvIGRlbGV0ZSB0aGlzIG1haWwgaW1tZWRpYXRl
bHkuDQpZb3UgYXJlIGFsc28gaGVyZWJ5IG5vdGlmaWVkIHRoYXQgYW55IHVzZSwgYW55IGZvcm0g
b2YgcmVwcm9kdWN0aW9uLCBkaXNzZW1pbmF0aW9uLCBjb3B5aW5nLCBkaXNjbG9zdXJlLCBtb2Rp
ZmljYXRpb24sDQpkaXN0cmlidXRpb24gYW5kL29yIHB1YmxpY2F0aW9uIG9mIHRoaXMgZS1tYWls
IG1lc3NhZ2UsIGNvbnRlbnRzIG9yIGl0cyBhdHRhY2htZW50IG90aGVyIHRoYW4gYnkgaXRzIGlu
dGVuZGVkIHJlY2lwaWVudC9zIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuDQoNClZpc2l0IFVzIGF0
IGh0dHA6Ly93d3cucG9sYXJpcy5jby5pbg0K
--
//www.freelists.org/webpage/oracle-l
Other related posts:
