Re: difference between SQl*plus and Sql*plus worksheet !?
Date: Sun, 27 Jun 2004 16:26:21 +0200
Message-ID: <iOADc.312$vH5.139_at_amstwist00>
[Quoted] Thanks daniel.
[Quoted] I have Windows at the moment, trying out Toad.
If I use notepad, do you mean that I should compile my procedure from the
command line ?
If I do write a block in notepad, let say the following:
begin
dbms_output.put_line('hello');
end;
How do I execute this block ?
seen in my help -> Contact your Oracle DBA to make sure the DBMS_OUTPUT
package is enabled on your database.
Should I add this somewhere from the 'Oracle enterprise manager' ?
regards, i
ps.
Did install oracle 10g. I do not see sql*plus worksheet anywhere. must one
download and install that tool on its own ?
ds
"Daniel Morgan" <damorgan_at_x.washington.edu> skrev i meddelandet
news:1088344149.419110_at_yasure...
> Inki wrote:
>
> > Following Q:
> > Do I use SQL*Plus to write my procedures and functions ?
>
> I wouldn't. If you are on UNIX use vi or emacs. If on Windows
> use Notepad or any other editor.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Sun Jun 27 2004 - 16:26:21 CEST