| 失效链接处理 |
|
oracle命o大全 PDF 下蝲
本站整理下蝲Q?/strong>
链接Q?a target="_blank">https://pan.baidu.com/s/1t5-Tj5KydWITBAUUgQRr9A
提取码：1go1
相关截图Q?/strong>
主要内容Q?/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;
===============================================================
查看当前用户的系l权限和表权限
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
===============================================================
查看当前用户的缺省表I间
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 密码Q?br />
|
| Java1234官方?5Q?/td> | 
|
| Java1234官方?5Q?/td> | 838462530 |
苏公|安?32061202001004?/p>
