u011004598的专栏

oracle创建表空间和用户授权文章分类:数据库 SYS用户在CMD下以DBA身份登陆：在CMD中打sqlplus /nolog然后再conn / as sysdba//创建临时表空间 create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle...

查询某个表里的所有字段名和字段类型：select COLUMN_NAME,DATA_TYPE from USER_TAB_COLS where TABLE_NAME='M_MALL3_FOCUS_ITEMS';alter table t_stu add constraint fk_kc_id foreign key (kc_id) references t_kc(kcid)...

[url]http://www.oschina.net/project/tag/83/db-model[/url][url]http://www.2cto.com/database/201502/377077.html[/url][url]https://www.baidu.com/s?ie=utf-8&f=8&rsv_bp=1&rsv_idx=1&tn=baidu&wd=my...