Re: result of a sql query without Linefeed ?

In article <A3F66.1110$m52.77891_at_nreader2.kpnqwest.net>,   "b powolny" <b.powolny_at_mobilkom.at> wrote:
> Is there a possibility with SQL plus (or something else for a oracle
 db) to
> spool out a result (more than one record) of a query without CR/LF.
>
> best regards
> B.Powolny
>
>

By definition, the SQLPlus puts out cr/lf at the end of the line. Its output is always that way.

Now if you are using utl_file or dbms_output packages, you have the oppurtunity to use end of lines or not.

utl_file writes like fprintf to a file to the server only. There is a restriction via a parameter in the init<SID>.ora file. The size of the file is limited to the physical file size on the server.

dbms_output is local to the client process. There are some setup needed -- like set serveroutput on and dbms_output.enable( <size> ). The dbms_output is limited to 1,000,000 bytes.

Both of these can be executed with in SQLPlus -- within anonymous PL/SQL blocks eg:

declare
...
begin
...
dbms_output.enable(10000);
..
dbms_output.put('this is a string');
dbms_output.put('this string is concatated to the previous string'); ..

end;

I think there is also io_file ??? which allows writing to the client.

Check out the manuals!!!!!

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/