-
Connect Linux Server Operations Oracle database because the project is online, the site's database server is not allowed to connect directly with Oracle's client Plsqldev.exe, and can only be manipulated by commands from the Linux server. The following is a SECURECRT 5.1 client connection to the Linux server to operate the Oracle database: 1. Connect to a Linux server (enter the IP address of the server) ssh 10.199.94.227 Prompt for password after successful connection, input success will prompt. 2. Switching to Operations Oracle database su-oracle switchover successfully prompts an instance of the relevant database. For example:[email protected]:~> 3. Switch to Sqlplus operation sqlplus/nolog Toggle success prompts for hints related to: for example: sql*plus:release 11.2.0.2.0 Production on Thu Jan 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. will prompt for connected. (Connection succeeded), display sql>: 6. The following are the related SQL statement operations: (1) The statement after the query must be added; , otherwise you cannot execute the query, equivalent to the Plsqldev.exe Tool Command window Operation select *from Newuseraccount (remember to add;) select email, Password from Userreg where accountstype=1 and userstate=1; (2) inserted or updated statements remember to add a commit statement to commit the transaction. Corresponds to the operation of the Command window for the Plsqldev.exe tool. update NewUserAccount set address= ' 20-Qinghai -0-xining City ' where userid=638; commit; related operations are as follows:
Connect to Linux Server operations Oracle database
