周益龙的专栏

DECLARE tempid VARCHAR2(50); nums numeric; tempnums varchar2(50); begin nums:=1; for tableInfo in (select FI_ID from FILEINFO) loop if nums10 then tempnums:=CONCAT('00',nums);

事例SQL语句select level,sys_connect_by_path(code,'/') path,t.* from classify t WHERE 1=1 start with id='' connect by PID= prior ID 上述语句中，level表示当前数据所在的层级，sys_connect_by_path函数展示出当前数据的所在路径，start with是树节点开

exp user/pwd@sid file=filepath

对于oracle 10g 1. 先登陆sql plus 2. 输入默认用户名 sys 3. 输入密码 xxx 4. 输入标识orcl as sysdba创建用户 create user zhouyilong identified by zhouyilong; 给用户一些基本的权限 grant connect,resource to zhouyilong; 连接上当前的用户

查询锁表记录：select a.sid, a.sql_exec_start, p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username, b.os_user_name from v$process p, v$session a

SELECT decode(y.memo, null, null, extractvalue(XMLType.CreateXML(y.memo), '/TrackBankCardTranOutInfo/MerchantNum')) s,

Tomcat服务器环境配置1.将jdk和jre放到一个特定路径C:\Program Files\Java\jdk1.8.0_144 C:\Program Files\Java\jre1.8.0_1442.添加环境变量JAVA_HOMEJAVA_HOME C:\Program Files\Java\jdk1.8.0_1443.添加环境变量CLASSPATH（包含tomcat的api）CLASSPA

–查看当前用户下面有多少job执行 select job,what,failures,broken from user_jobs 启动job (命令窗口) exec dbms_job.run(job#); 停用job（命令窗口） EXEC DBMS_JOB.BROKEN(job#,TRUE); ...