王秋云的博客

oracle用法：//dao层代码@Query(value = "SELECT * FROM TABLENAME WHERE USER_NAME LIKE '%'||?1||'%'", nativeQuery = true)List<Map<String, Object>> queryUserInfoByName(String userName);mysq...

 2019年2月21日 苏州BIIP的数据库名为  BIIPORCL    所用用户默认的密码为 root（初始化设置的）用户为 biipuser  密码为 rootCREATE USER biipuser IDENTIFIED BY root;grant create functions to biipuser;grant create procedure to biipuser;...

转自（https://blog.youkuaiyun.com/zxh2075/article/details/78488141）create table dectuser(         userid integer primary key,  /*主键*/         name varchar2(20),         sex varchar2(2)         );       ...

alter table student add(classid number(2));select *from student for updatedesc student alter table student modify (name varchar2(300));Insert into student (name,gender,classid) select name,gen...

1、将oracle表结构导出来SELECT T1.COLUMN_ID, T1.COLUMN_NAME, T2.COMMENTS, DECODE(T1.DATA_SCALE, NULL, T1.DATA_TYPE || '(' || T1.DATA_LENGTH || ')', ...

-- select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'yyyy') from dual ;--返回当年第一天 2018/1/1select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'mm') from dual ; --返回当月第一...

package com.atest.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class JDBCUti...

package com.bos.nsc.simulator;<?xml version="1.0" encoding="UTF-8"?><handlers> <!--handlers that are added named sql--> <!-- handler-namedsql.xml class：the class ...

–查网点号select zjhm,wdh from APPLICABLELIST where zjhm in();select zjhm,slwd from Applyinfo where zjhm in();select yhwdh from comcode2branchno where sqwdh in (select sqslwddm from accounta...