记录点滴.......

1.模糊查询(instr比like效率高) select cust_id from tf_f_sale where instr(title,'供应托盘')>0 select cust_id from tf_f_sale where instr(title,'供应托盘')>0 AND 1 select cust_id from tf_f_sale where inst...

一、Sql Server2000[code="java"]SELECT TableName=D.NAME,TableExplain=CASE WHEN A.COLORDER=1 THEN ISNULL(F.VALUE,' ') ELSE ' ' END, ColumnName=A.NAME,IsIdentity = COLUMNPROPERTY( A.ID,A.NAME,'ISIDEN...

1 列出数据库里所有的用户表名select name from sysobjects where type='U'2 获取表的列名及其属性select * from information_schema.columns where table_name='log4j'

1 创建用户create user zhaozhi3758 identified by 1232 赋予权限grant resource,connect,dba to zhaozhi37583 删除用户drop user zhaozhi3758 cascade

1 oracle[code="java"]select * from ( select row_.*,rownum rownum_ from ( select REPLACE(b.name4,'公路局','') as name4 , b.name0 , sum(a.personcount) as personcount, s...

[code="java"]DELIMITER $$DROP PROCEDURE IF EXISTS `safetyw`.`pre_url`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `pre_url`()begin declare pId bigint(20); declare pUrl varchar(80);...

SYS用户在CMD下以DBA身份登陆：在CMD中打sqlplus /nolog然后再conn / as sysdba注意点：1.如果在PL/SQL 等工具里打开的话，直接修改下面的代码中[斜体加粗部分]执行2.确保路径存在，比如【D:\oracle\oradata\Oracle9i\】也就是你要保存文件的路径存在/*分为四步 *//*第1步：...

1 日期比较hql.append(" and to_date(to_char(planTime,'yyyy-mm'),'yyyy-mm') >= to_date('"+params.get("startDate")+"','yyyy-mm') ");