select * from bmdmb
where (bmmc = '计算机总支') or
(bmmc = '计算机团委') or
(bmmc = '计算机班委') or
(bmmc = '计算机系办') or
(bmmc = '电信系总支') or
(bmmc = '电信系团委') or
(bmmc = '电信系系办') or
(bmmc = '艺术系总支') or
(bmmc = '艺术系团委') or
(bmmc = '艺术系系办') or
(substr(bmmc,1,3) = '数理系')
where (bmmc = '计算机总支') or
(bmmc = '计算机团委') or
(bmmc = '计算机班委') or
(bmmc = '计算机系办') or
(bmmc = '电信系总支') or
(bmmc = '电信系团委') or
(bmmc = '电信系系办') or
(bmmc = '艺术系总支') or
(bmmc = '艺术系团委') or
(bmmc = '艺术系系办') or
(substr(bmmc,1,3) = '数理系')
解决方案 »
- oracle监听文件中ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521什么意思?
- 一道数据库题,高手请帮忙,给分
- 求助:ora-922错误,缺少或无效选项,与NOCOMPRESS有关
- 急急急!请教:远程数据库连接问题
- 帮我把下面的Sql Server触发器转换为oracle的,表名一样的!
- 检索的问题,在线等,紧急
- 新手问题:把表A的数据导入到表B中,如何建作业?
- 请大家帮我看看,数据迁移的工作,有详细步骤,欢迎进来讨论。
- oracle数据库实战问题
- dmp文件导入oracle数据库时导入到一半时就停了,然后报这些错误,新手不太懂这个
- 怎能样才能登陆SQL Plus???
- 在带有参数的游标中使用动态sql问题,急需解决!!
select bmmc from bmdmb order by yjbmdm;
这样不行啊!
start with sybmdm=0
connect by sybmdm = prior id;
缩进用lpad加空格的方式。自己加吧。
对connect by 不了解的话,看
http://blog.csdn.net/snowy_howe/archive/2004/12/13/215207.aspx
且:我数据库中的内容还有很多,不只有这几条内容。我的部门信息有很多
但是还有谢谢您!
select decode(bmjc,1,bmmc,2,' '||bmmc,3,' '||bmmc) from bmdmb
where substr(substr(bmmc,1,3)= '计算机')
union
select decode(bmjc,1,bmmc,2,' '||bmmc,3,' '||bmmc) from bmdmb
where substr(substr(bmmc,1,3)= '电信系')
union
select decode(bmjc,1,bmmc,2,' '||bmmc,3,' '||bmmc) from bmdmb
where substr(substr(bmmc,1,3)= '艺术系')
union
select decode(bmjc,1,bmmc,2,' '||bmmc,3,' '||bmmc) from bmdmb
where substr(substr(bmmc,1,3)= '数理系')
from bmdmb
order by bmdm;
我用您的方法,select bmmc from bmdmb
start with sybmdm=0
connect by sybmdm = prior bmdm;
出现“SYBMDM”:invalid indetifier
--start with sybmdm=0
connect by sybmdm = prior id
order by bmmc;
--start with sybmdm=0
connect by prior sybmdm = id
order by bmmc
BMMC1
--------------------------------------------------------------------------------
art
art_tw
art_xb
art_zz
com_bw
com_tw
com_xb
com_zz
computer
math
tel
tel_tw
tel_xb
tel_zz
14 rows selected
select bmmc from bmdmb
start with sjbmdm=0
connect by sjbmdm = prior bmdm;
---------------------------
art
art_tw
art_xb
art_zz
com_bw
com_tw
com_xb
com_zz
computer
math
tel
tel_tw
tel_xb
tel_zz
14 rows selected
---------------------------
art
art_tw
art_xb
art_zz
com_bw
com_tw
com_xb
com_zz
computer
math
tel
tel_tw
tel_xb
tel_zz
14 rows selected
from bmdmb
order by bmdm
已写入文件 afiedt.buf 1 select lpad(' ',bmjc-1)||bmmc bmmc,bmdm,sybmdm,yjbmdm,bmjc
2 from bmdmb
3* order by bmdm
SQL817> /BMMC BMDM SYBMDM YJB BMJC
--------------- --------- ------ --- ----------
计算机系 001 0 001 1
计算机总支 001001 001 001 2
计算机团委 001002 001 001 2
计算机系班委 001002001 001002 001 3
计算机系办 001003 001 001 2
电信系 002 0 002 1
电信系总支 002001 002 002 2
电信系团委 002002 002 002 2
电信系系办 002003 002 002 2
艺术系 003 0 003 1
艺术系总支 003001 003 003 2
艺术系团委 003002 003 003 2
艺术系系办 003003 003 003 2
数理系 004 0 004 1已选择14行。