![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
文章平均质量分 52
robin嘟嘟
蜗牛爬爬~~
展开
-
删除重复记录
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原创 2011-03-04 16:18:00 · 528 阅读 · 0 评论 -
oracle字符串拼接函数
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原创 2012-04-16 17:54:48 · 3346 阅读 · 0 评论 -
oracle dblink的使用方法
工作中用到了dblink,所以做一下记录,以防以后忘记。通过资料查询,了解到 创建数据库链接可用如下命令:create [public] database link dblinknameconnect to cs identified by csusing 'ibm'; dblinkname即数据库链接的名称,第一个cs是远端数据库的用户名,第原创 2012-04-16 17:49:16 · 3151 阅读 · 0 评论 -
oracle 部门层级查询
create table(CCID varchar2(20) not null, CCNAME VARCHAR2(100) not null, fid varchar2(20) constraint PK_T primar原创 2012-03-07 12:48:22 · 2445 阅读 · 0 评论 -
存储过程自动执行
create or replaceprocedure insertUserNums as icount number; begin select nvl(count(*),0) into icount from userchart where ever原创 2011-07-13 15:35:02 · 816 阅读 · 0 评论 -
创建存储 过程
创建一个周日期的存储过程:create or replaceprocedure tt1 is i int; begin i:=0; while i insert into weekinfos1 values('2013',i+1,to_c原创 2011-07-13 15:28:15 · 649 阅读 · 0 评论 -
oracle 语句联系
create table test( tid Number(10,0) not null primary key, col1 varchar2(10) , col2 varchar2(10) , col3 varchar2(10) , col4 varchar2(原创 2011-07-13 15:38:26 · 767 阅读 · 0 评论 -
oracle 错误码
<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 />原创 2011-02-18 15:56:00 · 530 阅读 · 0 评论 -
oracle存储过程入门
<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 />原创 2011-02-18 16:04:00 · 454 阅读 · 0 评论 -
oracle 字符串拼接函数
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原创 2012-04-16 17:49:57 · 7884 阅读 · 0 评论