difference between SQl*plus and Sql*plus worksheet !?

[Inki]

Hello,

A Q from a newbee on oracle here.
I do have access to the tool SQL*plus today, the disadvantage there is that
I only have one pane/window where my
Questions and Answers are seen, I have seen a tool that you have two panes /
one upper and one lower - the questions are raised in the upper and answers
given in the lower. What tool is that ?
If I do want to create procedures, which tool should I use ?

Best regards, i

[Inki]

Following Q:
Do I use SQL*Plus to write my procedures and functions ?

regards, i
"Inki" <inkimar_1968@hotmail.com> skrev i meddelandet
news:LJyDc.293$vH5.121@amstwist00... Hello, A Q from a newbee on oracle here. I do have access to the tool SQL*plus today, the disadvantage there is
that I only have one pane/window where my Questions and Answers are seen, I have seen a tool that you have two panes
/ one upper and one lower - the questions are raised in the upper and
answers given in the lower. What tool is that ? If I do want to create procedures, which tool should I use ? Best regards, i

[Daniel Morgan]

Inki wrote:
Hello, A Q from a newbee on oracle here. I do have access to the tool SQL*plus today, the disadvantage there is that I only have one pane/window where my Questions and Answers are seen, I have seen a tool that you have two panes / one upper and one lower - the questions are raised in the upper and answers given in the lower. What tool is that ? If I do want to create procedures, which tool should I use ? Best regards, i

There are many tools like that. One that is free is iSQL*Plus which
is distributed by Oracle with version 9i and above. Most of the
others are expensive.

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Daniel Morgan]

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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Inki]

Thanks daniel.

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@x.washington.edu> skrev i meddelandet
news:1088344149.419110@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@x.washington.edu (replace 'x' with a 'u' to reply)

[Daniel Morgan]

Inki wrote:
Thanks daniel. 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

SQL> set serveroutput on

SQL> begin dbms_output.put_line('hello');

Nothing more is required.

Write in notepad and execute at the SQL*Plus command line if the point
is to learn what you are doing. Painful at first I will grant you but
far more valuable long-term. There are no GUI tools on Solaris, HP/UX,
AIX, etc. for debugging PL/SQL.

And if you make an error such as:

CREATE OR REPLACE PROCEDURE oops IS

BEGIN
INSERT INTO mytble;;
END oops;
/

Just type:

SQL> show err

--
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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Open Wound]

"Inki" <inkimar_1968@hotmail.com> wrote in message news:<LJyDc.293$vH5.121@amstwist00>... Hello, A Q from a newbee on oracle here. I do have access to the tool SQL*plus today, the disadvantage there is that I only have one pane/window where my Questions and Answers are seen, I have seen a tool that you have two panes / one upper and one lower - the questions are raised in the upper and answers given in the lower. What tool is that ?

There are several such tools. SQL*Plus Worksheet is one. (Underneath the
covers SQL*Plus Worksheet actually runs SQL*Plus.) Another is Oracle
Enterprise Manager Java Console. Right-click on a database node and choose
the "SQL Scratchpad" command. This tool has the ability to show execution
plans graphically, if you are trying to tune SQL.

You can also try free third-party tools such as Toad and SQLpal. See
http://www.toadsoft.com/ for Toad and http://www.sqlpal.com for SQLpal.
If I do want to create procedures, which tool should I use ? Best regards, i

You can edit stored procedures in Oracle Enterprise Manager,
Oracle JDeveloper, Toad, or SQLpal.

[Open Wound]

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1088344149.419110@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.

That's crappy advice. There is no need to use Notepad when you
could be using a more productive such as Toad (free third-party tool)
or Oracle JDeveloper.

[Open Wound]

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1088369505.825767@yasure>... Inki wrote: Thanks daniel. 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 SQL> set serveroutput on SQL> begin dbms_output.put_line('hello'); Nothing more is required. Write in notepad and execute at the SQL*Plus command line if the point is to learn what you are doing. Painful at first I will grant you but far more valuable long-term. There are no GUI tools on Solaris, HP/UX, AIX, etc. for debugging PL/SQL.

Some "experts" give poor advice to newcomers because they don't want more
people entering their field and competing for their jobs. I am assuming this
isn't true in your case - you are probably just ignorant.

Back to the subject. JDeveloper is a fine tool for editing and debugging
PL/SQL. It works on Windows, Linux, Solaris and HP-UX.
http://otn.oracle.com/software/products/jdev/index.html