| 澶辨晥閾炬帴澶勭悊 |
|
oracle鍛戒護澶у叏 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1t5-Tj5KydWITBAUUgQRr9A
鎻愬彇鐮侊細1go1
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
1.oracle 鍐呭鍖呮嫭涓夊ぇ欏?
2.SQLServer 鍩烘湰鎿嶄綔璇彞
3.鍚勭鏁版嵁搴撹繛鎺ユ柟娉?nbsp;
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
&&&&&&&&&&&&&&&&&
**************************************************oracle 鍩烘湰鎿嶄綔璇彞
********************************************************
鎵撳紑鏈嶅姟鍣?nbsp;
net start oracleservicebinbo
鎵撳紑鐩戝惉鍣?nbsp;
lsnrctl start
鍏抽棴鏈嶅姟鍣?nbsp;
net stop oracleservicebinbo
鍏抽棴鐩戝惉鍣?nbsp;
lsnrctl stop
===============================================================
娓呭睆
clear screen
****************************************************************
鏁版嵁瀛楀吀 ===========desc user_views(鍏抽敭璇?
****************************************************************
===============================================================
鏌ョ湅褰撳墠鐢ㄦ埛鐨勮鑹?nbsp;
SQL>select * from user_role_privs;
===============================================================
鏌ョ湅褰撳墠鐢ㄦ埛鐨勭郴緇熸潈闄愬拰琛ㄧ駭鏉冮檺
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
===============================================================
鏌ョ湅褰撳墠鐢ㄦ埛鐨勭己鐪佽〃絀洪棿
SQL>select username,default_tablespace from user_users;
===============================================================
鎹㈢敤鎴?nbsp;
conn as sysdba
sys
tsinghua
sqlplus "sys/tsinghua as sysdba"
conn sys/zl as sysdba
===============================================================
淇敼琛ㄧ粨鏋?nbsp;
alter table test modify(name not null);
alter table test add(name varchar2(20));
alter table test drop column sex;
alter table test set unused column sex;
alter table test drop unused columns;
===============================================================
鏇存敼鐢ㄦ埛瀵嗙爜
sql>alter user 綆＄悊鍛?identified by 瀵嗙爜錛?br />
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
