Re: displaying / output / echo / print information from an sql script ?? duh

On 4 Sty, 21:20, "jobs" <j..._at_webdos.com> wrote:
> total noob question I'm sure...
>
> In a plsql procedure I can do the following to output:
>
> dbms_output.put_line('helloworld');
>
> How do you output "helloworld" from an sql script?

I think You want to output line from sql file.

If so just include pl/sql anonymous block eq.

• some sql instructions select 1 from dual;

insert into sth values (1);

begin
dbms_output.put_line('sth');
end;
/

• others sql

select 1 from dual;

If You use sql/plus to run Your scripts you can always use PROMPT command. Received on Fri Jan 05 2007 - 03:28:45 CST