1,添加HIBERNATE_SEQUENCE
CREATE SEQUENCE HIBERNATE_SEQUENCE
2,为表添加字段
alter table tname add(name varchar2(30) default ‘无名氏' not null);
3,修改表的字段名
alter table TABLE_NAME rename column FIELD_NAME to NEW_FIELD_NAME;
4,修改字段长度
alter table task modify (CTRL_FILE_ADDR varchar(255));
5,删除字段
alter table test1 drop column name;
6,添加主键
alter table child add constraint pk_child primary key (c_id);
7,删除主键
ALTER TABLE test_subDROP CONSTRAINT main_id_cons;
8,添加外键
alter table CHILD add constraint FK_CHILD_PRIM foreign key (V_ID) references prim (V_ID) ON DELETE CASCADE;
9,删除外键
ALTER TABLE test_subDROP CONSTRAINT main_id_cons;
10,删除表
drop table scott.tableA
11,查看所有表
select table_name from user_tables;
12,查看表结构
desc tablename;
13,查看所有序列
select * from user_sequences;
14,删除序列
DROP sequence name;
15,查看所有触发器
select trigger_name from all_triggers where table_name='XXX';
16,使用navicat连接oracle异常:
ORA-28547: connection to server failed, probable Oracle Net admin error
原因:oci.dll和sqlplus.exe版本不对
解决办法:
1,下载oracle client:http://www.oracle.com/technetwork/topics/winsoft-085727.html
下载instantclient-basic-win32*.zip
instantclient-sqlplus-win32*.zip
2,解压两个压缩文件到当前文件夹
3,找到navicat 工具->选项->oci 和sqlplus.exe
4,选择oci为刚刚下载的oci.dll, sqlplus为刚刚下载的sqlplus.exe
17,以管理员登录
sqlplus /as sysdba
或者
sqlplus
username > sys / as sysdba
sys /nolog
sqlplus sys / as sysdba
sqlplus
username > sys
password > pasd as sysdba