小袋子的IT部落

select sysdate,add_months(sysdate,12) from dual; --加1年 select sysdate,add_months(sysdate,1) from dual; --加1月 select sysdate,to_char(sysdate+7,'yyyy-mm-dd HH24:MI:SS') from dual; --加1星期 select sy...

[size=medium][b]SQL重复记录查询[/b][/size][b]1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断[/b]select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count(peopl...

1，alter table table_name drop (字段1,字段2,字段3);2，alter table table1 drop column a,b增加一个列：ALTER TABLE 表名 ADD(列名 数据类型);如：ALTER TABLE emp ADD(weight NUMBER(38,0));修改一个列的数据类型(一般限于修改长度，修改为一个...

--备份scott exp--创建表空间 create tablespace xxx datafile 'e:\xxx.ora' size 5m autoextend on;--创建用户 create user xxx identified by xxx default tablespace users quota 10M users; grant create sessi...

connect by 是结构化查询中用到的，其基本语法是：select ... from tablename start with 条件1connect by 条件2where 条件3;例：select * from tablestart with org_id = 'HBHqfWGWPy'connect by prior org_id = parent_id;...

package test; import java.io.BufferedInputStream; import java.io.FileInputStream; import java.io.PrintStream; import java.sql.Connection; import java.sql.DriverManager; imp...