RE: sql o/p to Excel

2001-06-22 Thread pierre . olaru
Hi Ravindra, Bein in the same situation like you a few months ago I manage to figure out 2 solutions at your problem: 1. There is a nice Excel add-in called SecondWind which is able to perform export operations from Oracle to Excel in a very nice manner and formatted in the way which you

RE: ip restriction

2001-06-08 Thread pierre . olaru
Bulent, You can perform this task also from Oracle, protocol.ora which is well documented in Oracle documentation. Regards, Pierre Bulent selam hocam,Murat ben,burada varsovada yan odadan Pierre gelip METU nedir diye sorunca eski bir ODTU terk olarak atladim hemen.Pierre le birlikte bir

SQL loader query

2001-05-17 Thread pierre . olaru
Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle

RE: restrict login with known IP address

2001-05-08 Thread pierre . olaru
Yes, it is possible thorugh protocol.ora. Practically, you must configure the excluded IP addresses using excluded nodes option. Regards, Pierre -Original Message- From: LeydenJ [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 7:26 PM To: ORACLE-L Cc: LeydenJ Subject:

Oracle repository

2001-04-09 Thread pierre . olaru
I would be grateful if you can advise me if there are other products than Oracle Designer 6i which is able to build automatically a version control baseline and track the changes at the packages and stored procedure level. My goal is to have in place a control version program which could be

RE: Excel to oracle

2001-03-29 Thread pierre . olaru
Ravindra, Besides the conventional way of exporting into a CSV and then use SQLLoader, please be informed that there are 2 product which are able to handle your requirement. One is SecondWind and the second is Oraxcel. Regards, Pierre -Original Message- From: ravindra [SMTP:[EMAIL