Re: SQL*Plus & #include

an215493_at_anon.penet.fi wrote:
>
> In C if I want to include a file in another file, all I need to do is
>
> #include "file"
>
> at the location I wish to include it. Is there a way to do that in
> SQL*Plus? The reason I ask is that I need to do something like the
> following:
>

The START staement should do the trick:

In myprog.sql

	set heading off
	select 'abc' from dual;
	start include.sql
	select 'def' from dual;

In include.sql

        select '123' from dual;

Output:

        abc

        123

        def

I hope this helps

Yours ever

Eddy Received on Thu May 04 1995 - 00:00:00 CEST