robinpipi的专栏

select commend_date, commender_id, stock_code,stock_name,issue_channelfrom commendstock awhere (a.commend_date, a.commender_id, a.stock_code)in (select commend_date, commender_id, stock_codefrom commendstock group by commend_date, commender_id, stock_code

create table sys_users(id integer primary key,lgoinname varchar2(20), real_name varchar2(20));--人员表 create table sys_Departments(department_id integer primary key, parment_id integer,department_name v

工作中用到了dblink，所以做一下记录，以防以后忘记。 通过资料查询，了解到     创建数据库链接可用如下命令： create [public] database link dblinkname connect to cs  identified by cs using 'ibm';     dblinkname即数据库链接的名称，第一个cs是远端数据库的用户名，第

create table( CCID varchar2(20) not null, CCNAME VARCHAR2(100) not null, fid varchar2(20) constraint PK_T primar

create or replace procedure insertUserNums as icount number; begin select nvl(count(*),0) into icount from userchart where ever

创建一个周日期的存储过程：create or replaceprocedure   tt1  is i int;    begin     i:=0;   while i    insert   into   weekinfos1   values('2013',i+1,to_c

create table test(  tid Number(10,0) not null primary key,  col1 varchar2(10) ,  col2  varchar2(10) ,  col3  varchar2(10) ,  col4  varchar2(

<br />1、ORA-28000: the account is locked。<br />某用户被锁定。<br />解决方法：<br />   conn sys as sysdab; //以dba身份登录<br />   alter  user scott account unlock; //将用户解锁。<br />   conn scott/tiger； //弹出修改密码的框，直接修改密码即可。<br /> <br /> 

<br />写个简单的存储过程：<br />选用scott的emp表。给员工涨工资，大于2000的涨50，大于1000的涨100，其他的涨150：<br />create or replace procedure addsal(employno varchar2) is<br />     increment number;<br />     salary number;<br />     begin<br />       select sal into salary from emp<br />  

create table sys_users(id integer primary key,lgoinname varchar2(20),real_name varchar2(20));--人员表 create table sys_Departments(department_id integer primary key,parment_id integer,department_name var