alter table rename columnname1 to columnname2;(不是很确定,记不太清楚了)
alter table tablename add constraints pk_name primary key (columnName1,columnName2...);
alter table tablename add constraints fk_name foreign key (columnaName1,...) references fktablename (columnName1,...);
alter table tablename add constraints pk_name primary key (columnName1,columnName2...);
alter table tablename add constraints fk_name foreign key (columnaName1,...) references fktablename (columnName1,...);
解决方案 »
- 新人求教
- 在oracle触发器里,dbms_xmlquery.newContext(string)过程对当前更新的数据转化为XML
- 如何将多表关联的数据生成数据表,同时要去掉多余的记录.请指教.
- 有metalink的能帮我下个p3423540_9204_LINUX64.zip补丁吗?
- Oracle的实例到底是什么?和DB2及SQL SERVER的实例概念相比呢?
- 图形界面下不能导入和导出吗??
- oracle问题!着急呀!~~~~~~!!!!!oracle15212错误
- oracle网络访问的问题!
- 问下各位大神在linux32位 下安装oracle 11g时候出现的问题。。。
- 新手sql语句编写
- 大G们,帮帮我啊!
- 请问,怎样登录到服务器oracle的Oracle Management Server
alter table tableName rename col1 to col2;
2 alter table tapp_20041022153215 rename fie1 to fie11;
3 end;
4 /
alter table tapp_20041022153215 rename fie1 to fie11;
*
ERROR 位于第 2 行:
ORA-06550: 第 2 行, 第 2 列:
PLS-00103: 出现符号 "ALTER"在需要下列之一时:
begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe看看我这段修改字段名的语句有什么错误?
2 EXECUTE IMMEDIATE 'alter table tapp_20041022153215 rename fie1 to fie11';
3 end;
4 /
begin
*
ERROR 位于第 1 行:
ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失
ORA-06512: 在line 2
SQL> alter table ab_test rename column aa to bb;Table altered
alter table employees add constraint emp_pk primary key (empno)
alter table employees add constraint emp_pk primary key (empno,deptno)alter table employees
add constraint emp_jobs_fk foreign key (job,deptno)
references jobs (jobid,deptno)
on delete cascade