Database
关注
分享
扫一扫
iteye_21104
这个作者很懒，什么都没留下…
展开
-
oracle 存储过程建表
[code="sql"]create or replace procedure pro_scmcbs_mapping_table is icnt number := 0;begin select count(*) into icnt from user_tables where table_name = 'TEMP_SCMCBS_MAPPING'; ...原创 2014-07-31 18:38:29 · 149 阅读 · 0 评论 -
Oracle Net Manager 配置监听程序
[img]http://dl.iteye.com/upload/picture/pic/123643/c1f8d28d-8dbc-340a-a102-a08487947718.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123645/af094fe1-35b8-3792-b4ad-542f6fda7658.jpg[/img]...原创 2013-02-28 13:24:43 · 913 阅读 · 0 评论 -
oracle 11g 卸载
[img]http://dl.iteye.com/upload/picture/pic/123613/7e93f097-9746-39df-993e-691b847ac6d4.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123615/57cadc49-7320-39a2-b656-295af531764e.jpg[/img]...原创 2013-02-27 16:56:36 · 94 阅读 · 0 评论 -
Oracle 伪表与伪列
[img]http://dl.iteye.com/upload/picture/pic/123591/6ff1ef06-1130-3637-b720-64ba0e351dca.jpg[/img]ROWID:记录每条记录在硬盘上位置的唯一标识[img]http://dl.iteye.com/upload/picture/pic/123593/69a14531-d0da-31ac-82...原创 2013-02-27 13:57:45 · 127 阅读 · 0 评论 -
Oracle 表空间管理
创建表空间[img]http://dl.iteye.com/upload/picture/pic/123575/5675ae68-5144-3caf-a160-b6bd8e007a1b.jpg[/img]更改表空间[img]http://dl.iteye.com/upload/picture/pic/123577/e54eb8c6-b10d-3ac2-8ca7-499f25...原创 2013-02-27 12:58:44 · 86 阅读 · 0 评论 -
oracle 11g 服务
[img]http://dl.iteye.com/upload/picture/pic/123567/0a2492be-2f9a-3e5a-b3f5-50972a958e3c.jpg[/img]OracleTNSLinstener:Oracle数据库的监听程序OracleService:Oracle数据库例程OracleDBconsole:Oracle企业管理器OEM[co...原创 2013-02-27 09:24:09 · 82 阅读 · 0 评论 -
数据控制语言DCL 授权与撤销
[img]http://dl.iteye.com/upload/picture/pic/123565/ac34ba79-618e-3518-b1a5-c0db603b1045.jpg[/img]原创 2013-02-26 14:03:21 · 264 阅读 · 0 评论 -
数据库中四种连接的区别
内连接(inner join)：连接两个表只要数据存在不匹配就都不显示。外连接(outer join)：连接两个表存在空匹配的记录将都显示处理。左连接(left join)：连接两个表以左表为显示表，显示左表匹配的NULL字段。右连接(right join)：连接两个表以右表为显示表，显示右表匹配的NULL字段。...原创 2013-02-26 13:45:21 · 2958 阅读 · 0 评论 -
oracle SQL/PLUS 日期类型DATE
[img]http://dl.iteye.com/upload/picture/pic/123559/3fa34994-d2e7-39d6-83fb-f02df3b1440b.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123561/16e127a7-198a-39b4-b498-ee4e65afa30b.jpg[/img]...原创 2013-02-26 13:28:08 · 824 阅读 · 0 评论 -
oracle SQL/PLUS 创建用户并授权
[img]http://dl.iteye.com/upload/picture/pic/123553/90221a7b-4ab0-31cb-94bf-de56cee8c8e6.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123555/97416e15-5ea1-36ce-8c17-c90a43809d20.jpg[/img]...原创 2013-02-26 12:45:36 · 429 阅读 · 0 评论 -
oracle 11g 企业管理器
win64_11gR2_database_1of2[img]http://dl.iteye.com/upload/picture/pic/123541/33415980-46bd-3d38-9031-a150b1cc614a.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123543/b30f2092-2517-34b8-...原创 2013-02-26 10:28:39 · 208 阅读 · 0 评论 -
解决SQLServer中表结构不能修改的问题
[img]http://dl.iteye.com/upload/picture/pic/122528/1afde82a-e576-321d-82e4-dcf8a03493df.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/122530/5c68586b-1e01-3b9c-9f40-5ae01eb448e2.jpg[/img]原创 2013-01-09 14:22:21 · 455 阅读 · 0 评论 -
Oracle salplus 导出导入数据
[img]http://dl.iteye.com/upload/picture/pic/129704/7c0c6c8a-09fa-38e5-9be1-3e183f61558d.png[/img][img]http://dl.iteye.com/upload/picture/pic/129706/aaf70ce8-1316-3af5-b120-5845a0327bde.png[/img]...原创 2014-03-12 16:00:54 · 137 阅读 · 0 评论 -
Oracle 事务控制语言 TCL
[img]http://dl.iteye.com/upload/picture/pic/123665/16a806d7-cd62-3be6-8bad-3926ff099031.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123667/505d7fce-255a-3dce-80da-a21ec81c83e3.jpg[/img]原创 2013-02-28 17:28:06 · 206 阅读 · 0 评论 -
SQL中的查询符号
[img]http://dl.iteye.com/upload/picture/pic/123675/893ce410-fca3-32cd-97de-029d2c25a29e.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123677/184c7ff6-fb64-3786-a181-9bdad504c155.jpg[/img]...原创 2013-02-28 19:22:50 · 860 阅读 · 0 评论 -
Oracle 集合运算
[img]http://dl.iteye.com/upload/picture/pic/123721/9b4617c0-6a8b-344e-9fae-503c7c0609ab.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123723/d9b8a393-975b-3da4-88d8-7810101c53cb.jpg[/img]...原创 2013-03-01 13:27:55 · 84 阅读 · 0 评论 -
Oracle plsql 参考文档
Oracle plsql 参考文档原创 2014-07-09 21:01:46 · 205 阅读 · 0 评论 -
Oracle创建表 create
drop table stu;drop table class;create table class(id number(4) primary key);insert into class (id) values (1000);create table stu(id number(6),name varchar2(20) constraint stu_name_nn not nul...原创 2014-07-08 20:53:11 · 141 阅读 · 0 评论 -
Oracle select 语句 案例大全
select * from emp;select * from dept;select * from salgrade;select ename || sal from emp;select distinct deptno from emp;select distinct deptno, job from emp;select * from emp where deptno = 10;sele...原创 2014-07-08 20:39:06 · 104 阅读 · 0 评论 -
数据源
[code="java"]package com.demo.dao.utils;import java.beans.PropertyVetoException;import java.sql.SQLException;import javax.sql.DataSource;import org.springframework.beans.factory.annotati...原创 2017-04-08 15:08:52 · 177 阅读 · 0 评论 -
Oracle 存储过程与函数
[code="sql"]CREATE OR REPLACE PROCEDURE pro_scmcbs_i6bill_filldata(group_code org_group.code%type, stockorg_code org_stockorg.code%type) AS...原创 2013-03-05 11:06:47 · 101 阅读 · 0 评论 -
Oracle 游标
[img]http://dl.iteye.com/upload/picture/pic/123823/a31e0c58-0109-3356-b746-777a56be7abb.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123825/187e94b2-d351-326b-9f46-2fae1071f27c.jpg[/img]...原创 2013-03-03 19:57:11 · 114 阅读 · 0 评论 -
PL/SQL语句
[img]http://dl.iteye.com/upload/picture/pic/123777/03f585ec-53fe-3d2c-9513-933ab5b4d0cf.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123779/48e5c341-b42f-3705-abbf-cf4f74926113.jpg[/img]...原创 2013-03-02 18:08:18 · 112 阅读 · 0 评论 -
Oracle 视图
[img]http://dl.iteye.com/upload/picture/pic/123765/bccfa25c-d667-3d1f-a2e3-d170579fb731.jpg[/img]如果视图失效 使用以下命令[img]http://dl.iteye.com/upload/picture/pic/123767/83076fc9-7682-3f69-a9db-b4462df...原创 2013-03-02 10:28:15 · 62 阅读 · 0 评论 -
Oracle 序列
[img]http://dl.iteye.com/upload/picture/pic/123757/1621e448-bb84-3ca0-a9db-dc48d12c8bbd.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123759/0edd56c7-35c8-322d-86b5-44a8cedd229d.jpg[/img]...原创 2013-03-01 15:54:28 · 92 阅读 · 0 评论 -
Oracle 同义词
[img]http://dl.iteye.com/upload/picture/pic/123745/fb5fcc19-f576-3eb6-ba6e-6571f6e81d6f.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123747/7b1e029b-264f-3233-8d65-e1fd6f829ee5.jpg[/img]...原创 2013-03-01 15:23:29 · 76 阅读 · 0 评论 -
Oracle 权限
GRANT SELECT ON A.table TO B;GRANT INSERT ON A.table TO B;GRANT UPDATE ON A.table TO B;GRANT DELETE ON A.table TO B;原创 2013-03-01 14:40:44 · 99 阅读 · 0 评论 -
Oracle 分析函数
[img]http://dl.iteye.com/upload/picture/pic/123733/94f195f5-dffc-367c-93cf-0716fbab850c.jpg[/img][img]http://dl.iteye.com/upload/picture/pic/123735/80f4e73b-de7f-31a9-bdaf-8775e49bb0ee.jpg[/img]...原创 2013-03-01 13:32:13 · 77 阅读 · 0 评论 -
Oracle select 语句
select * from emp;select * from dept;select * from salgrade;select ename || sal from emp;select distinct deptno from emp;select distinct deptno, job from emp;select * from emp where deptno = 10;sele...原创 2014-03-12 14:59:50 · 139 阅读 · 0 评论 -
MySQL系统时间
select current_date,now(),sysdate()原创 2016-06-24 16:20:52 · 152 阅读 · 0 评论 -
Cent OS 7 Linux下5.6.31 MySQL Community Server (GPL)添加用户
[root@localhost xiongjiajia]# vim /etc/my.cnf#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES sql_mode=NO_ENGINE_SUBSTITUTION[root@localhost xiongjiajia]# service mysqld restart Redirecting ...原创 2016-06-06 09:30:34 · 347 阅读 · 0 评论 -
ORA-01045
[code="java"]用sys登入Oracle DB后,下grant create session to UserName;(UserName是登录出错的用户名)[/code]原创 2012-05-03 10:02:16 · 217 阅读 · 0 评论 -
SQL脚本
MySQL版[code="sql"]/*Navicat MySQL Data TransferSource Server : localMySQLSource Server Version : 50151Source Host : localhost:3306Source Database : bookshop...原创 2013-05-08 15:02:12 · 150 阅读 · 0 评论 -
HSQLDB 开源 数据库
[url]http://hsqldb.org/[/url][img]http://dl.iteye.com/upload/picture/pic/116453/be520975-a4d9-329a-8c5e-dca3cd336d4b.png[/img][code="java"]java -cp ../lib/hsqldb.jar org.hsqldb.server.Server -...原创 2012-08-04 07:51:35 · 129 阅读 · 0 评论 -
Oracle常用SQL命令[转载]
//创建表空间CREATE TABLESPACE AITE datafile 'D:\temp\aite.dbf' size 100m autoextendON NEXT 32m maxsize 2048m DROP TABLESPACE aite INCLUDING CONTENTS AND DATAFILES;--删除表空间//创建用户C...原创 2012-03-27 12:02:14 · 73 阅读 · 0 评论 -
调用Oracle存储过程
1.单个传入传出参数[code="sql"]create or replace procedure procedure_in_name_out_email( i_name in o_user.username%type, o_email out o_user.email%type) is cursor getEmail(na va...2011-12-02 11:05:58 · 90 阅读 · 0 评论 -
JDBC Driver 连接Mysql Oracle 11g与SQL Server 2008
简单查询 打印结果[code="java"]import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class TextMysql { /** * @param ar...2011-12-02 10:09:54 · 94 阅读 · 0 评论 -
PL/SQL游标
[code="sql"]--------------------------------------------------------declare cursor c is select * from emp; v_emp emp%rowtype;begin open c; fetch c into v_emp; while (c%fou...2011-12-01 11:24:53 · 88 阅读 · 0 评论 -
PL/SQL基本流程控制语句语法
[code="SQL"]----------------------------------------------------------------------DECLARE conVerson constant VARCHAR2(20) := '1.0.01';BEGIN DBMS_OUTPUT.put_line(conVerson);END;--------...2011-12-01 11:18:11 · 147 阅读 · 0 评论 -
PL/SQL复合类型 Oracle存储过程返回结果集
[color=gray]PL/SQL是 Procedure Language & Structured Query Language（过程化SQL语言） 的缩写 PL/SQL是对SQL语言存储过程语言的扩展[/color]记录类型 ：记录类型是把逻辑相关的数据作为一个单元存储起来定义记录类型语法如下：[code="sql"]TYPE record_type IS RECOR...2011-12-01 09:59:57 · 345 阅读 · 0 评论