Re: Beginning

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 30 Oct 2002 20:33:47 GMT
Message-ID: <3DC04228.AD1A114D@exesolutions.com>

tou wrote:

> Hi,
>
> I'm new to ORACLE and I have two questions:
>
> 1 - I used TOAD for exporting some rows with fields separated by ; very
> easy... Now I woul perform an automatic exporta of o table but I can't find
> information about how to do it with SQL Plus console...
>
> I know that with spool command I can 'export' to file, but how can I export
> with fields separated by :, or tab or anything else ?
>
> 2 - Can I call external programs with triggers ? In fact I want to export a
> table each time a change is made on it...
>
> TIA

SELECT field1 || ':' field2 FROM table
Yes. But have you really thought through the implications of what this would do to performance and scalability?

Daniel Morgan Received on Wed Oct 30 2002 - 14:33:47 CST