ORACLE 常用sql备忘

[b]查找表名：[/b]

select * from tabs t where lower(t.table_name) like '%service%'

[img]http://dl.iteye.com/upload/attachment/423376/4f16622f-08e7-354f-831c-f042a78aa0d7.png[/img]

select a.TABLE_NAME,b.COMMENTS,a.NUM_ROWS,a.TABLESPACE_NAME
from user_tables a,user_tab_comments b
WHERE a.TABLE_NAME=b.TABLE_NAME
order by TABLE_NAME 

[img]http://dl2.iteye.com/upload/attachment/0099/6186/09aa101e-64f3-32b1-b973-ead2fd461eba.jpg[/img]

[b] nvl(PARENT_ID, -1) as PARENT_ID[/b]

select ID, nvl(PARENT_ID,-1) as PARENT_ID from user_service where account_id=? order by id desc

[b]某个字段不不包含"-"的记录[/b]

select * from c_resource r where instr(r.url,'_')=0 order by r.url desc

[img]http://dl.iteye.com/upload/attachment/0067/9058/a8a1c6b2-46d9-37c6-b83e-11f7baff8b43.png[/img]