bingo

1、第一查看本机ip，进入cmd命令行窗口，输入ipconfig，查看本地ip地址2、属性3、找到listenter.ora和tnsnames.ora4、修改listenter.ora5、修改tnsnames.ora6、重启Oracle服务...

1、插入（1）第一种方式：利用<foreach>标签，将入<insert id="insertBatchLaTContactRecord" parameterType="java.util.Map"> <selectKey resultType="java.lang.Long" keyProperty="dto.id" order="BEFORE">...

删除表中多余的重复记录（多个字段），只留有rowid最小的记录delete from 表 a where (a.Id,a.seq) in (select Id,seq from 表 group by Id,seq having count(*) > 1) and rowid not in (select min(rowid) from 表 group by Id,seq having c...

创建表空间create tablespace zhdj datafile 'F:\installed\devinstall\oracle11\oradata\orcl\zhdj.DBF' size 1024M autoextend on next 10M maxsize unlimited;创建临时表空间create temporary tablespace zhdj_TMP...

将一个表的数据备份到另一个表中：create table tableB as select * from tableA；表存在：insert into tableB（【字段名】） select 字段名 from tableA；将A表的字段更新的B表中：update t1 set school = (select school from t2 where na...