Ã
loading..
èµè®¯
å®å
¨
论å
ä¸è½½
读书
ç¨åºå¼å
æ°æ®åº
ç³»ç»
ç½ç»
çµå书
微信å¦é¢
ç«é¿å¦é¢
QQ
ææºè½¯ä»¶
èè¯
é¢éæ ç®
SQL Server|
MySQL|
Oracle|
DB2|
Sybase|
å
¶ä»ç»¼å|
SQLæç¨|
ç»å½æ³¨å
é¦é¡µ > æ°æ®åº > Oracle > æ£æ
è¿æ¥Linuxæå¡å¨æä½Oracleæ°æ®åº
2013-03-20 10:48:47
0个è¯è®º
æ¶è
æè¦æ稿
è¿æ¥Linuxæå¡å¨æä½Oracleæ°æ®åº
ç±äºé¡¹ç®å·²ç»ä¸çº¿ï¼ç°åºçæ°æ®åºæå¡å¨ä¸å
许ç´æ¥ç¨Oracleç客æ·ç«¯plsqldev.exeæ¥è¿æ¥ï¼åªè½éè¿Linuxæå¡å¨çå½ä»¤æ¥æä½ã 以ä¸æ¯ç¨SecureCRT 5.1客æ·ç«¯è¿æ¥Linuxæå¡å¨æ¥æä½Oracleæ°æ®åºï¼
1.è¿æ¥å°Linuxæå¡å¨(è¾å
¥æå¡å¨çipå°å)
ssh 10.199.94.227
è¿æ¥æååä¼æ示è¾å
¥å¯ç ï¼è¾å
¥æåä¼æ示ã
2.åæ¢å°æä½Oracleæ°æ®åº
su - oracle
åæ¢æåä¼æ示ç¸å
³æ°æ®åºçå®ä¾ãä¾å¦ï¼oracle@linux-cg01:~>
3.åæ¢å°sqlplusæä½
sqlplus /nolog
åæ¢æåä¼æ示ç¸å
³çæ示ï¼ä¾å¦ï¼
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 19 11:19:48 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
4.è¾å
¥æ°æ®åºçç¨æ·ååå¯ç
conn personal/personal
5.ä¼æ示Connected.(è¿æ¥æå)ï¼æ¾ç¤º SQL> ï¼
6.以ä¸æ¯ç¸å
³çSQLè¯å¥æä½ï¼
(1) æ¥è¯¢çè¯å¥åé¢è¦ä¸å®è¦å ; ï¼å¦åä¸è½æ§è¡æ¥è¯¢ï¼ç¸å½äºplsqldev.exeå·¥å
·çå½ä»¤çªå£çæä½
select *from newuseraccount ï¼è®°å¾æ¥è¯¢çæ¶åä¸å®è¦å ;ï¼
select email,password from userreg where accountstype=1 and userstate=1;
(2)æå
¥ææ´æ°çè¯å¥è®°å¾è¿è¦å æ交è¯å¥,æè½æ交äºå¡ãç¸å½äºplsqldev.exeå·¥å
·çå½ä»¤çªå£çæä½ã
update newuseraccount set address='address ' where userid=638 ;
commit ;
温馨提示:答案为网友推荐,仅供参考