Oracle SQl
文章平均质量分 73
frankeyf
这个作者很懒,什么都没留下…
展开
-
Oracle procedure return DataSet used in JDBC
Sql代码 --1.建包 1. CREATE OR REPLACE PACKAGE my_pak AS 2. TYPE my_cus IS REF CURSOR ; 3. END my_pak; --2.写存储返回过程 1. CREATE OR REPLACE PROCEDURE sp_add_emp3( 2. v_empno emp.empno%TYPE, 3.原创 2010-10-26 15:40:00 · 758 阅读 · 0 评论 -
Oracle 常用表
☆dba_开头..... dba_users 数据库用户信息 dba_segments 表段信息 dba_extents 数据区信息 dba_objects 数据库对象信息 dba_tablespaces 数据库表空间信息 dba_data_files 数据文件设置信息 dba_temp_files 临时数据文件信息 dba_rollback_segs 回滚段信息 dba_ts_quotas 用户表空间配额信息 dba_free_space 数据库空闲空间信息 dba_profile转载 2010-11-04 11:30:00 · 200 阅读 · 0 评论 -
funciton/procedure calling each other
Using packages:define function in packagescreate or replace PACKAGE FUNCTION_PAK AS FUNCTION GET_F_S_C( p_tname in varchar2,-- parent table name p_cname in varchar2,-- parent foreign key column name tname in varchar2, -- referenced table name cnam原创 2011-03-28 11:53:00 · 302 阅读 · 0 评论 -
Exception list
<br /> Error<br /> Named Exception<br /> ORA-00001<br /> DUP_VAL_ON_INDEX<br /> ORA-00051 <br /> TIMEOUT_ON_RESOURCE<br /> ORA-01001 <br /> INVALID_CURSOR<br /> ORA-01012 <br /> NOT_LOGGED_ON<br /> ORA-01017 <br /> LOGIN_DENIED<br /> ORA-01403转载 2011-04-13 10:27:00 · 458 阅读 · 0 评论 -
Execute immediate 语法
The EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block. The syntax转载 2011-07-13 13:48:41 · 1038 阅读 · 0 评论 -
ORA-12899 – Value too large for column string
有空再翻译吧 If we need to recover a scheme which default LANG is WE8ISO8859P1 and our database is AL32UTF8, the import process crash because the special characters during the conversion pass from one b转载 2013-04-18 14:27:13 · 2010 阅读 · 0 评论