create table "ONLINE4"."CHANNEL_INFO"(
"ID" NUMBER not null,
"CODE" VARCHAR2(6) ,
"NAME" VARCHAR2(30) not null,
"PARENT_ID" number,
constraint "CHANNEL_INFO_ID" primary key ("ID")
); comment on table "ONLINE1"."CHANNEL_INFO" is '渠道信息表';
comment on column "ONLINE1"."CHANNEL_INFO"."CODE" is '渠道ID,保存6个数字';
comment on column "ONLINE1"."CHANNEL_INFO"."NAME" is '渠道名称';
comment on column "ONLINE1"."CHANNEL_INFO"."PARENT_ID" is '父类渠道ID';求sql删除表中没有子渠道的一级渠道记录
"ID" NUMBER not null,
"CODE" VARCHAR2(6) ,
"NAME" VARCHAR2(30) not null,
"PARENT_ID" number,
constraint "CHANNEL_INFO_ID" primary key ("ID")
); comment on table "ONLINE1"."CHANNEL_INFO" is '渠道信息表';
comment on column "ONLINE1"."CHANNEL_INFO"."CODE" is '渠道ID,保存6个数字';
comment on column "ONLINE1"."CHANNEL_INFO"."NAME" is '渠道名称';
comment on column "ONLINE1"."CHANNEL_INFO"."PARENT_ID" is '父类渠道ID';求sql删除表中没有子渠道的一级渠道记录
解决方案 »
- where子句
- 索引的重建问题
- 帮看看这个存储过程错在哪里?谢谢!
- oracle 10g 连接mysql数据库
- 如何使用帮定数组变量从数据库中取得数据。
- 求征SQL语句
- 9i中创建数据库不成功,报错:ORA-01503: CREATE CONTROLFILE failed,忽略后还有很多其他错误,怎么解决?
- 请问如何使用ORACLE帮助
- 请问如下问题如何解决:ORA-12560: TNS: 协议适配器错误!!?谢谢!
- select a,count(*) as b from c group by a后怎样再得到总count(*)
- 只是简单的数据库链接,预编译成的C语言代码,有个地方不明白。
- oracle表连接问题
delete from CHANNEL_INFO a
where a.code not in (
select distinct b.PARENT_ID from CHANNEL_INFO b)
delete from CHANNEL_INFO t
where not exists(select 1 from CHANNEL_INFO s where s.PARENT_ID=t.CODE);