Re: Text file from store procedure

iten by Crocodile Descartes > and Tim Bunce (ISBN:1-56592-699-4) > > > > On 2003.08.20 22:04, Richard Ji wrote: > > You can also use Java Stored Procedures. > > > > > > -Original Message- > > From: Steve McClure [mailto:[EMAIL PROTECTED] >

Re: Text file from store procedure

4 PM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: Text file from store procedure You can spool output to the location of your choice in sqlplus. Forms allows you to use a utl_file like procedure called 'text_io' I believe. In 6i the output is written to the client machine,

RE: Text file from store procedure

ocks. -Original Message- Hamid Alavi Sent: Wednesday, August 20, 2003 4:19 PM To: Multiple recipients of list ORACLE-L List of guru, Is any body know how can I create a text file from store procedure without using utl_file , I want to create & write a text file from result of a select

RE: Text file from store procedure

You can also use Java Stored Procedures. -Original Message- From: Steve McClure [mailto:[EMAIL PROTECTED] Sent: Wed 8/20/2003 8:44 PM To: Multiple recipients of list ORACLE-L Cc: Subject:RE: Text file from store procedure You can spool output to the location of your

RE: Text file from store procedure

It is designed to create and write text files from PL/SQL blocks. -Original Message- Hamid Alavi Sent: Wednesday, August 20, 2003 4:19 PM To: Multiple recipients of list ORACLE-L List of guru, Is any body know how can I create a text file from store procedure without using utl_file , I

Text file from store procedure

List of guru, Is any body know how can I create a text file from store procedure without using utl_file , I want to create & write a text file from result of a select statement and write the result as a text file in a define directory. Thanks for your help. Hamid Alavi Office :

How to test whether a text file exists in Dev6i on client machine

Hi Gurus   I need to test whether a text file 'a.txt' exists in the default oracle reports directory on client machine and print at the end of the report? I can use text_io but I don't seem to see a test for file existence.   Appreciate any help. Have a great weekend.    

RE: TEXT FILE

A somewhat messy way to do this, if you are on Unix, is a shell script something like: snip --- #!/usr/bin/ksh export ORACLE_SID=BUBBA export ORALCE_HOME=/dir/dir/product/9.2.0 export PATH=$ORACLE_HOME/bin:${PATH:-/usr/bin:/usr/sbin:/whatever/else} ... anything else I f

RE: TEXT FILE

Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Seema Singh [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 4:35 PM > To: Multiple recipients of list ORACLE-L > Subject: TEXT FILE > > > Hi, > Is there any other packages thru whic

RE: TEXT FILE

Sure, write your own pro C++ to text converter. Otherwise nothing I know about. Allan -Original Message- Sent: Thursday, June 19, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Hi, Is there any other packages thru which we can generate text file except UTL_FILE? I want to

TEXT FILE

Hi, Is there any other packages thru which we can generate text file except UTL_FILE? I want to generate text file dump into another server ,that server will indexes and processing that data and improve search. How to do that? Thanks -Seema

Re: clob to text file

y 12 November 2002 15:58, Sergei wrote: > Hello everyone, > > I am trying to offload data from multiple tables into one text file. > The problem is couple of the fields are clobs. Any advices how to deal > with clobs? > > Sergei -- Please see the official ORACLE-L FAQ: http:

clob to text file

Hello everyone, I am trying to offload data from multiple tables into one text file. The problem is couple of the fields are clobs. Any advices how to deal with clobs? Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat

RE: How to load text file into database table

by some rule. Again, not to discount your suggestion, there are many ways, I just thought passing my idea. Cheers, Viral. >From: DENNIS WILLIAMS <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Ho

Re: How to load text file into database table

David, I don't know sqlldr that well, but a possible quick and dirty solution - is to load the text file into a one column oracle table, and then in a subsequent step, use SQL to move the data to the proper columns of the proper Oracle table. The ctl file from the first step would be some

RE: How to load text file into database table

] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How to load text file into database table >Date: Fri, 20 Sep 2002 08:53:34 -0800 > >David - If the file is in just the format you show, my first impulse would >be to use the perl script language to get

RE: How to load text file into database table

NIS WILLIAMS <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How to load text file into database table >Date: Fri, 20 Sep 2002 08:53:34 -0800 > >David - If the file is in just the format you sh

RE: How to load text file into database table

nt: Friday, September 20, 2002 10:54 AM To: Multiple recipients of list ORACLE-L I have a text file and need to load it into database table using sqlldr utility. Is there a way to load a text file? I know how to load csv file but not text file. *** Below is text file format. Date: Wed Aug 29 10

How to load text file into database table

I have a text file and need to load it into database table using sqlldr utility. Is there a way to load a text file? I know how to load csv file but not text file. *** Below is text file format. Date: Wed Aug 29 10:43:53 CDT 2001 Name: Paris By Night Email: [EMAIL PROTECTED] Phone: 202-333

test - text file attachment / Re: ORACLE-L Digest -- Volume 2002, Number 123

what - you changing careers - trying out for Denis Miller's show? > TEST TEXT FILE ATTACHMENT FOR ORACLE-L ANTI-VIRUS SPAMMERS

Re: Insert from text file [NT client - Unix host]

01, Number 276 > > -- > > From: "Aldi Barco" <[EMAIL PROTECTED]> > Date: Wed, 03 Oct 2001 04:10:28 +0700 > Subject: Insert from text file ... > I want to insert a text file in my client machine (Win NT) into emp > (empno,ename, sala

RE: Insert from text file

ite a simple program to format your text file into DML statements, then just run these in SQL*Plus. Alternatively, it would be simple in Perl or Java to write a program that parsed the text file and fired off INSERT statements to Oracle in one go, this would be easier if you need to do this a lot. O

RE: Insert from text file

insert a text file in my client machine (Win NT) into emp (empno,ename, salary) table in unix machine from my client. I don't have sqlloader in my machine (client). How to do that ? Can we used utl_file package ? If yes , please give an example because I'm new for utl_file package. T

Insert from text file

Hi listers, I want to insert a text file in my client machine (Win NT) into emp (empno,ename, salary) table in unix machine from my client. I don't have sqlloader in my machine (client). How to do that ? Can we used utl_file package ? If yes , please give an example because I'

RE: sql query read from text file

How about this simple script: # Script to check processing the_pids=`cat a.txt | awk '{printf("%s,",$1)}' | sed 's/,$//'` sqlplus /

Re: sql query read from text file

On Jun 19, 2001 at 11:15:46PM, Vladimir Begun wrote: > On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote: > > Hi > > If i have one file a.txt and I want to put that content in where clause of > > sql statement then how can I do it. > > Example : > > a.txt content > > 98989 > > 67676 > > 898989 > >

Re: sql query read from text file

On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote: > Hi > If i have one file a.txt and I want to put that content in where clause of > sql statement then how can I do it. > Example : > a.txt content > 98989 > 67676 > 898989 > Select x,y,z from abc > where x in (98989,67676,898989) > / create file

sql query read from text file

Hi If i have one file a.txt and I want to put that content in where clause of sql statement then how can I do it. Example : a.txt content 98989 67676 898989 Select x,y,z from abc where x in (98989,67676,898989) / Actuall I want to do it in unix.I want to know the first 2 or 3 high CPU using proc

Re: Help for Unix text file processing

Hi Jared, You are a kinder DBA than I. It's good to see that constulting attitude developing :) Dave Jared wrote . > But if I want to conserve the carriage return > Then change the script from '\n' to '\r\n' Jared -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 2

Re: Help for Unix text file processing

12:36 > À : Multiple recipients of list ORACLE-L > Objet : Re: Help for Unix text file processing > > > > Do it with Perl. If you don't know it, it's > time to learn. > > This script will do it: > > #!/usr/bin/perl -pw > > chomp; > next if

RE: Help for Unix text file processing

But if I want to conserve the carriage return -Message d'origine- De : Jared Still [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 juin 2001 12:36 À : Multiple recipients of list ORACLE-L Objet : Re: Help for Unix text file processing Do it with Perl. If you don't know it, it

Re: Help for Unix text file processing

gt; > > > I am looking for some commands like ( grep, egrep, sed etc) to do the > > following on a Unix box. > > > > 1. Command to take out all the blank line from a text file. The blank > > line may include tabs and whitespaces. > > 2. Command to take out the

Re: Help for Unix text file processing

st ORACLE-L <[EMAIL PROTECTED]> Fax to: Sent by: Subject: Help for Unix text file processing

RE: Help for Unix text file processing

; > 1. Command to take out all the blank line from a text file. The blank line > may include tabs and whitespaces. > 2. Command to take out the trailing and starting blanks and tabs from the > each line of the text file. > 3. Command for the above two tasks combined. > > Than

Help for Unix text file processing

> Hey all, > > I am looking for some commands like ( grep, egrep, sed etc) to do the > following on a Unix box. > > 1. Command to take out all the blank line from a text file. The blank line > may include tabs and whitespaces. > 2. Command to take out the trailing and

RE: Import comma-delimited text file into Oracle

Or you can write a program in (C, Perl, Java, etc) to parse the file and do inserts. Richard -Original Message- Daiminger Sent: Tuesday, March 27, 2001 10:36 PM To: Multiple recipients of list ORACLE-L Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file

RE: Import comma-delimited text file into Oracle

Helmut, I believe that SQL*Loader is the quickest way to load your data. You could write a procedure that uses UTL_FILE also. And there is another choice, but truly brute force - you could edit your file into INSERT statements and load it through SQL*PLUS. :-( Ron Morton Union Switch & Signal

Import comma-delimited text file into Oracle

Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: help: import text file to databse from an ASP web client

sql loader runs at server . but tetxt files which are mentioned in my previous mail are at client side. -Original Message- Sharma Sent: Thursday, February 15, 2001 10:31 AM To: Multiple recipients of list ORACLE-L do u want to insert it into table? if this is normal text file with

Re: help: import text file to databse from an ASP web client

do u want to insert it into table? if this is normal text file with .txt extension, you can do it thru sql * loader utility. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, February 15, 2001 1:15 PM > hello , > i have

help: import text file to databse from an ASP web client

hello , i have a quesition . could you help me and give some idea. i need to import some text files into database from a web client that is written with ASP. how can i solve this quesiton . what kind of technich should i use. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -