From oracle-l-bounce@freelists.org Wed Sep 28 08:15:31 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8SDFVSc018627 for ; Wed, 28 Sep 2005 08:15:31 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8SDFR6H018609 for ; Wed, 28 Sep 2005 08:15:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 192CC1EFE99; Wed, 28 Sep 2005 08:15:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25707-03; Wed, 28 Sep 2005 08:15:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 89E1C1EFDAB; Wed, 28 Sep 2005 08:15:21 -0500 (EST) Subject: RE: PL/SQL question Message-ID: From: manoj.gurnani@polaris.co.in Date: Wed, 28 Sep 2005 18:43:13 +0530 To: oracle-l@freelists.org Cc: MIME-Version: 1.0 X-imss-version: 2.029 X-imss-result: Passed X-imss-approveListMatch: *@polaris.co.in X-MIMETrack: Serialize by Router on psldns.polaris.co.in/Polaris(Release 6.5.4FP1|June19, 2005) at 09/28/2005 06:43:17 PM, Itemize by SMTP Server on Trend-Smtp/Orion/IN(Release 6.5.1|January 21, 2004) at 09/28/2005 06:50:53 PM, Serialize by Router on Trend-Smtp/Orion/IN(Release 6.5.1|January 21, 2004) at 09/28/2005 06:50:56 PM, Serialize complete at 09/28/2005 06:50:56 PM Content-Type: text/plain; charset=UTF-8 X-archive-position: 26010 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: manoj.gurnani@polaris.co.in Precedence: normal Reply-To: manoj.gurnani@polaris.co.in X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,NO_REAL_NAME, UPPERCASE_50_75 autolearn=no version=2.63 DQoNCg0KDQoNCmxha2ggaXMgMTAwMDAwDQoNCg0KDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN CiAgICAgICAgICAgICAgICAgICAgICAiRXJpYyBCdWRkZWxtZWlqZXIiICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIDxFcmljLkJ1 ZGRlbG1laWplckAgICAgICAgICBUbzogICAgICA8VGhvbWFzLk1lcmNhZGFudGVAbGFib3Iuc3Rh dGUubnkudXM+LCA8Sm9obi5IYWxsYXNAZ2Iudm9kYWZvbmUuY28udWs+LCAgICAgICAgDQogICAg ICAgICAgICAgICAgICAgICAgZWxlZ2FudC5ubD4gICAgICAgICAgICAgICAgIDxkYXZpZHNoYXJw bGVzQGdtYWlsLmNvbT4sIDxtYW5vai5ndXJuYW5pQHBvbGFyaXMuY28uaW4+ICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBTZW50IGJ5OiAgICAg ICAgICAgICAgICAgICAgY2M6ICAgICAgPG9yYWNsZS1sQGZyZWVsaXN0cy5vcmc+ICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAg ICAgICAgICAgICAgIG9yYWNsZS1sLWJvdW5jZUBmcmUgICAgICAgICBTdWJqZWN0OiBSRTogUEwv U1FMIHF1ZXN0aW9uICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgZWxpc3RzLm9yZyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAg ICAgMDkvMjgvMjAwNSAwNjoyNCBQTSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICANCiAgICAgICAgICAgICAgICAgICAgICBQbGVhc2UgcmVzcG9uZCB0byAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIEVy aWMuQnVkZGVsbWVpamVyICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KDQoN Cg0KDQp3aWtpcGVkaWEgaXMgeW91ciBmcmllbmQ6IGh0dHA6Ly9lbi53aWtpcGVkaWEub3JnL3dp a2kvTGFraA0KICAgICAgSeKAmXZlIGJlZW4gb24gdGhpcyBsaXN0IGZvciB5ZWFycyBhbmQgZG9u 4oCZdCBrbm93IHdoYXQgYSBsYWtoIGlzLiAgSXMNCiAgICAgIHRoaXMgc29tZSBraW5kIG9mIGZv dXIgbGVnZ2VkIGNyZWF0dXJlIHRoYXQgbGl2ZXMgaW4gdGhlIEFscHM/ICBKDQoNCg0KDQpUaGlz IGUtTWFpbCBtYXkgY29udGFpbiBwcm9wcmlldGFyeSBhbmQgY29uZmlkZW50aWFsIGluZm9ybWF0 aW9uIGFuZCBpcyBzZW50IGZvciB0aGUgaW50ZW5kZWQgcmVjaXBpZW50KHMpIG9ubHkuIA0KSWYg YnkgYW4gYWRkcmVzc2luZyBvciB0cmFuc21pc3Npb24gZXJyb3IgdGhpcyBtYWlsIGhhcyBiZWVu IG1pc2RpcmVjdGVkIHRvIHlvdSwgeW91IGFyZSByZXF1ZXN0ZWQgdG8gZGVsZXRlIHRoaXMgbWFp bCBpbW1lZGlhdGVseS4NCllvdSBhcmUgYWxzbyBoZXJlYnkgbm90aWZpZWQgdGhhdCBhbnkgdXNl LCBhbnkgZm9ybSBvZiByZXByb2R1Y3Rpb24sIGRpc3NlbWluYXRpb24sIGNvcHlpbmcsIGRpc2Ns b3N1cmUsIG1vZGlmaWNhdGlvbiwNCmRpc3RyaWJ1dGlvbiBhbmQvb3IgcHVibGljYXRpb24gb2Yg dGhpcyBlLW1haWwgbWVzc2FnZSwgY29udGVudHMgb3IgaXRzIGF0dGFjaG1lbnQgb3RoZXIgdGhh biBieSBpdHMgaW50ZW5kZWQgcmVjaXBpZW50L3MgaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4NCg0K VmlzaXQgVXMgYXQgaHR0cDovL3d3dy5wb2xhcmlzLmNvLmluDQo= -- http://www.freelists.org/webpage/oracle-l