Oracle
文章平均质量分 54
我是谁_Gary
这个作者很懒,什么都没留下…
展开
-
Oracle XMLType Store as CLOB
create table T(id number,val1 int,val2 int,val3 int generated always as (val1 + val2) virtual,resume xmltype,info xmltype,test sys.xmltype)xmltype column resumestore as clobxmltype原创 2014-12-02 15:34:23 · 839 阅读 · 0 评论 -
Insert binary data into Oracle database
1. how to insert binary files into oracle databasegrant dba to demo identified by demo;CREATE DIRECTORY image_files AS '/Data/Files';GRANT READ ON DIRECTORY image_files TO demo;create table demo.image...原创 2018-05-31 14:33:02 · 240 阅读 · 0 评论 -
一个简单的PL/SQL程序
declareu number;beginselect user# into u from sys.user$ where name='TEST1' and type#=1;DBMS_OUTPUT.PUT_LINE(u);select user# into u from sys.user$ where name='TEST2' and type#=1;DBMS_OUTPUT原创 2015-08-18 13:37:02 · 560 阅读 · 0 评论 -
EXISTS的简单程序
SELECT COUNT(*) FROM SYS.OBJ$ O, SYS.USER$ U WHERE U.NAME = 'DEMO2' AND U.USER# = O.OWNER# AND O.NAME = 'TEST1' AND O.TYPE# = 2 AND EXISTS(SELECT 1 FROM SYS.USER$原创 2015-08-19 11:04:19 · 360 阅读 · 0 评论 -
compatible parameter
What Is Oracle Database Compatibility?Databases from different releases of Oracle Database software are compatible if they support the same features and those features perform the same way. When you原创 2015-05-08 15:55:42 · 500 阅读 · 0 评论 -
Oracle List Partition Table
CREATE TABLE T722 ( ID NUMBER, COL1 CHAR(30) , COL2 VARCHAR2(30) ) PARTITION BY LIST (COL2) ( PARTITION P1 VALUES ('CHINA', 'THAILAND'), PARTITION P2 VALUES ('GERMANY',转载 2014-12-02 15:41:04 · 1036 阅读 · 0 评论 -
SQL语句执行过程详解
第一步:编译阶段1)查询高速缓存(library cache)服务器进程在接到客户端传送过来的SQL语句时,不会直接去数据库查询。服务器进程把这个SQL语句的字符转化为ASCII等效数字码,接着这个ASCII码被传递给一个HASH函数,并返回一个hash值,然后服务器进程将到shared pool中的library cache(高速缓存)中去查找是否存在相同的hash值。如果存在,服务器进转载 2014-12-25 16:29:50 · 1084 阅读 · 0 评论 -
Using DBMS_ASSERT
If the condition which determines the property asserted in a function is not met then a value error is raised. Otherwise the input value is returned via return value. Most functions return the value u转载 2014-12-24 11:10:22 · 1207 阅读 · 0 评论 -
sys.col$ and sys.coltype$
create table T ( ID number, COL1 SYS.XMLTYPE )XMLType COLUMN COL1 STORE AS CLOB;select obj#,col#,intcol#,name,type# from sys.col$ where obj#='98134' OBJ# COL# INTCOL# NAME转载 2014-12-22 13:16:45 · 595 阅读 · 0 评论 -
Mybatis auto generated keys
1. Support AUTO_INCREMENT columnsWe can use the useGeneratedKeys and keyProperty attributes to let the database generate the auto_increment column value and set that generated value into one of the i...原创 2018-12-26 11:35:19 · 1004 阅读 · 0 评论