zhangyou1010的专栏

1 上午 11:31:383 2641 2010-10-11 上午 11:25:294 2921 2010-8-27 下午 04:00:335 2921 2010-8-27 下午 03:19:106 2721 2010-7-30 下午 04:36:087 2721 2010-7-30 下午 04:35:538 2821

_usage t set portfolionumber = (select ta.pnum from (select sum(pnum) pnum, pomuid from ((select count(om.userid) pnum, om.userid p

左值和右值，现在在plsql里又遇到这种称呼了。in模式的值是左值，read-only的。out模式的值是右值的write-only.in out模式则是两种的融合了。写个例子[code="sql"]create or replace procedure ModeTest( inParameter in number, outParameter out number , inOutParameter in out number)

, tt.deptno, tt.empnum, tt.avgsal, e.ename from scott.dept dd, (select e.deptno deptno, count(e.empno) empnum, avg(e.sal) avgsal, min(sal) minsal from scott.emp e group

v_string2 varchar2(50) := '--This message brought to you by PL/SQL !'; v_outputStr varchar2(50); begin insert into temp_table values(v_num1,v_string1); insert into temp_table values(v_num2,v_string2); select CHAR_COL into v_ou

rop table 和 truncate table 就不是很明白了。自己做了个小实验，创建一个简单的table：[code="sql"]create table students(first_name varchar2(20),last_name varchar2(20));insert into students values ('zhang','san');drop table students; truncate table students;

'2009-06-03 12:56:30','yyyy-MM-dd HH24:MI:SS') nowtime from dual ;注意 HH24:MI:SS分钟是MI,不是MM.