Connect to Linux Server operations Oracle database

1. Connect to a Linux server (enter the IP address of the server)

SSH 10.199.94.227

When the connection is successful, you will be prompted to enter the password.

2. Switch to Operation Oracle database

Su-oracle

A successful switchover prompts an instance of the relevant database. For example: [Email protected]:~>

3. Switch to Sqlplus operation

Sqlplus/nolog

A successful switch prompts you for a hint: for example:

Sql*plus:release 11.2.0.2.0 Production on Thu Jan 19 11:19:48 2012

Copyright (c) 1982, Oracle. All rights reserved.

4. Enter the user name and password for the database

Conn Personal/personal

5. You will be prompted connected. (Successful connection), display sql>:

6. The following are the related SQL statement operations:

(1) After the statement of the query must be added; , you cannot execute the query, which is equivalent to the operation of the Command window of the Plsqldev.exe tool

Select *from Newuseraccount (be sure to add when you are inquiring)

Select Email,password from Userreg where accountstype=1 and userstate=1;

(2) The inserted or updated statement remembers that the commit statement must be added before the transaction can be committed. Corresponds to the operation of the Command window for the Plsqldev.exe tool.

Update Newuseraccount set address= ' 20-Xining, Qinghai -0-' where userid=638;

commit;

Connect to Linux Server operations Oracle database