Sql*Plus Execute only one command

From: Theo Klein <theoklein77_at_hotmail.com>
Date: Tue, 26 Mar 2002 15:19:18 +0100
Message-ID: <a7q015$n664p$1@ID-124047.news.dfncis.de>

I have some beginner questions to Oracle 9i:

1)Is there a possibility to execute only one command of a script in Sql*Plus? (When I press the execution symbol or F5 the whole script is marked and then executed.)

2)With "SQL*Plus Worksheet" I can connect succesfull to my database when I type in the following in the starting mask: (Could be that my translation from German to English is not exact but I hope you understand it:)

user name: SYS
password: abcdef
service:
log in as: SYSDBA

When I start "SQL*Plus" I fill the masked as follows:

user name: SYS
password: abcdef
host sign sequence:

But instead of a connect I get this message:

ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper

What is wrong ?

3) What's the difference between "SQL*Plus" and "SQL*Plus Worksheet"?

Theo Klein Received on Tue Mar 26 2002 - 08:19:18 CST