zjutke的专栏

select * from ab21  order by cast(bab021 as int) desc

1. 复制表结构及其数据：create table table_name_new as select * from table_name_old2. 只复制表结构：create table table_name_new as select * from table_name_old where 1=2;或者：create table table_name_n

select t.*,(select count(*) from ab21 j where j.AAB001=t.aab001 and j.BAB214='1' and (j.bab212='0' or j.bab212 is null)) zxrs,(select count(*) from ab21 k where k.aab001=t.aab001 and ( k.bab214 <>'1'

在Windows XP/Server 2003如何彻底删除Oracle 10g/oracle9i图文的http://blog.sina.com.cn/s/blog_3d24e30d01000ba0.html=======================================================================1.停止所有与ORACLE相关的服务。 2

tools－－－prefences－－－User Interface －－－OtherDisplay line numbers  选项打上勾即可。过程，函数，包可是显示行号但是在sql窗口里是展示不出来行号的，即使是用带行号的编辑器（UltraEdit，editplus）也是不行，即便是可以也是极其不方便。右键操作，选中“Gutter”