wzwd111的专栏

http://dev.youkuaiyun.com/article/20/20163.shtm

1在oracle的数据库里有个函数 LPAD(String a,int length,String addString).               2作用：把addString添加到a的左边，length 是返回值的长度。                3例子                   A ： SQL> select lpad('test',8,0) from dual;   ...

http://www.cnblogs.com/ldaqiang/articles/1212839.html

http://cindysaj.iteye.com/blog/296635 SELECT col1, col2,        CASE           WHEN col3 > 1 AND col3 <2              THEN '1'           WHEN col3 > 2 AND col3 <3              THEN '2'...

vs_sql := 'select object_value from '|| vs_table      ||' where city_code = :is_citycode'      ||' and service_kind = :in_service_kind'      ||' and object_id = :in_id'      ||' and object_control = 1...

set serveroutput onDECLARE TYPE assoc_array IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30); state_array assoc_array;BEGIN  state_array('Alaska') := 'Juneau';  state_array('California') := 'Sacramento'...

IF vn_count = 0 THEN  NULL;

ORA-01403: 未找到数据

Class.forName( "oracle.jdbc.driver.OracleDriver" ); Connection cn = DriverManager.getConnection( "jdbc:oracle:thin:@yourIp:1521:ORCL", "用户名", "密码" ); Statement stat = cn.createStatement();...

oracle加小写别名依然是大写，如果想要小写别名，必须给别名套双引号

select   *   from   v$nls_parameters 看环境变量里的NLS_LANG配置SIMPLIFIED CHINESE.ZHS16GBK为正确配置 PARAMETER: NLS_LANGUAGEVALUE: SIMPLIFIED CHINESEPARAMETER: NLS_TERRITORYVALUE: CHINAPARAMETER: NLS_CU...

to_date('30-4月 -10','dd-mm"月" -yy')

vn_count;vs_name := "";my_sql:=select count(*) from dual d where d.name=:x EXECUTE IMMEDIATE my_sql INTO vn_count USING IN vs_name; 

http://www.cnblogs.com/ruanbl/archive/2008/02/29/1086398.html SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL; return Current Year SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL; return Current Month...

http://zgqhyh.iteye.com/blog/92794

set serveroutput ondeclare    n number;    sql_stmt varchar2(50);    t varchar2(20);begin    execute immediate 'alter session set nls_date_format=''YYYYMMDD''';    t := 't_' || sysdate;    sql_stmt :=...

DECODE函数的作用：它可以将输入数值与函数中的参数列表相比较，根据输入值返回一个对应值。函数的参数列表是由若干数值及其对应结果值组成的若干序偶形式。当然，如果未能与任何一个实参序偶匹配成功，则函数也有默认的返回值。 　　区别于SQL的其它函数，DECODE函数还能识别和操作空值。 　　语法如下： 　　DECODE(control_value,value1,result1[,value2,res...

语法NVL(eExpression1, eExpression2)参数eExpression1, eExpression2如果 eExpression1 的计算结果为 null 值，则 NVL( ) 返回 eExpression2。如果 eExpression1 的计算结果不是 null 值，则返回 eExpression1。eExpression1 和 eExpression2 可以是任意一种数...

//x也可是表达式sign(x)当X>0则返回1，X<0返回-1，X=0返回0

DELETE FROM BB_USER_PRODUCT_INFO_T a WHERE a.F_USER_ID = in_user_id AND EXISTS( SELECT a.f_item_id FROM bb_product_prechange_t c WHERE c.f_user_id = a.f_user_id AND c.f_item_id = a.f_item_id AND c.act...

http://lirig.iteye.com/blog/265250

一、helloWord1 编写JAVA程序,也是在SQL/PLUS中写,并执行.create or replace and compile java source named hello as public     class   Hello    {         static    public    String Message(String name)    {           ...

http://www.blogjava.net/joessy/articles/1398.html select * from(select a.*,rownum as rn from (select t.city_code as city_code,t2.city_name as city_name,       t.dept_id as dept_id,t.dept_name as d...

oracle fetchOPEN get_gather_info;    LOOP    FETCH  get_gather_info INTO v_gather_id,v_period_id,v_period_type,v_favour_name,v_pay_unit,v_unit;        EXIT WHEN get_gather_info%NOTFOUND;...

select * from(select * from act_activity order by dbms_random.value)    where rownum = 1  junitmavenwindows batjbossjboss work-flowhibernate 1对多 多对1配置uml    CookieStore cooki...