Re: Sql*Plus Execute only one command

Hi Theo,

> 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.)

AFAIK, there is no way. You only can put a -- in front of the statement or a /* ... */ around the statements which you don't want to be 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 ?

In SQL*Plus you didn't enter the connection string 'sys/abcdef as sysdba'. SQL*Plus tries to connect you to the database as user sys but w/o the wish to be a sysdba. 9i wants sys to connect as sysdba that's why you get the error. Try entering 'sys/abcdef as sysdba' in the user name field.

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

The workshit is a simple GUI for SQL*Plus. It also has a history of your commands and some gimmicks which I don't remember because I don't use it.

Viele Gruesse,

Knut

-- 
Dipl.-Inform. Knut Talman                       Fon +49.30.72 62 01 411
myToys.de GmbH                                  Fax +49.30.72 62 01 222
Schoenhauser Allee 36-39                        Mobil +49.173.671 65 65
D-10435 Berlin