Connect to a Linux server to operate an Oracle database

Connecting to the Linux server to operate the Oracle database is caused by the on-line access of the project. The on-site data warehouse server does not allow you to directly connect to the Oracle client plsqldev.exe. You can only use commands on the Linux server. Use the SecureCRT 5.1 client to connect to the Linux server to operate the Oracle database: 1. After the connection to the Linux Server (enter the IP address of the server) ssh 10.199.94.227 is successful, a message is displayed, indicating that the password is entered. 2. If you switch to the operating Oracle Database su-oracle, the instance of the relevant database will be displayed. Example: oracle @ linux-cg01: ~> 3. if the sqlplus/nolog switchover is successful, a prompt is displayed, for example, SQL * Plus: Release 11.2.0.2.0 Production on Thu Jan 19 11:19:48 2012 Copyright (c) 1982,201 0, Oracle. all rights reserved. 4. enter the database user name and password conn personal/personal 5. connected will be displayed. (connection successful), SQL>: 6. the following are related SQL statement operations: (1) the query statement must be followed; if the query is not executed, select * from newuseraccount is equivalent to the Command window operation of plsqldev.exe (you must add it when you remember to query;) select email, password from userreg where acco Untstype = 1 and userstate = 1; (2) Add the commit statement to insert or update the statement to submit the transaction. Similar to the Command window operation of plsqldev.exe. Update newuseraccount set address = '20-Qinghai-0-Xining city 'where userid = 638; commit; perform the following operations: