![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
文章平均质量分 79
chunguangtang
这个作者很懒,什么都没留下…
展开
-
oracle materialized view
物化视图,它是用于预先计算并保存表连接或聚集等耗时较多的操作的结果,这样,在执行查询时,就可以避免进行这些耗时的操作,而从快速的得到结果。物化视图有很多方面和索引很相似:使用物化视图的目的是为了提高查询性能;物化视图对应用透明,增加和删除物化视图不会影响应用程序中SQL 语句的正确性和有效性;物化视图需要占用存储空间;当基表发生变化时,物化视图也应当刷新。 其中物化视图有三种:聚集物化视图、包含连接物化视图、嵌套物化视图。但三种物化视图的快速刷新的限制条件有很大区别,而其他方面则区别不大。创建物化视图时原创 2010-07-19 10:49:00 · 1337 阅读 · 0 评论 -
Oracle通用日志表设计
-- Create sequence create sequence SEQ_COMMON_LOGminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20;-- Create tablecreate table TU_COMMON_LOG( COL_SEQUENCE NUMBER(20) not null, COL_DATE DATE not null,原创 2010-08-30 10:35:00 · 4319 阅读 · 0 评论 -
记一次纠结了我3天的oracle 问题的解决
自己机器上装了oracle,平时写的系统都是连到上面.前天突然连不上去了,jdbc连oracle总是报错,但是我通过pl/sql是可以的.抛一大堆错,懒的贴上来,网上有很多人遇到过这个问题,大都是说java连接oracle的代码写的有问题.然而,我系统用了很久了,一直好好的.而且最近从来没改过,而且我也不会白痴到犯那些低级错误,连jdbc连接oracle的代码也写错.检查了甚至有几十遍之后,还是觉得想不通,甚至重装了oracle,几乎都绝望了,然而还是无解.这几天吃不好,睡不好,反反复复老在想这件事情,因为原创 2010-09-02 18:30:00 · 969 阅读 · 2 评论 -
Datetime Functions
Datetime FunctionsDatetime functions operate on values of the DATE datatype. All datetime functions return a datetime or interval value of DATE datatype, except the MONTHS_BETWEEN function, which returns a number. The datetime functions are:ADD_MONTHSPurpo原创 2010-10-12 13:33:00 · 413 阅读 · 0 评论 -
Miscellaneous Single-Row Functions
Miscellaneous Single-Row FunctionsThe following single-row functions do not fall into any of the other single-row function categories:DECODEPurposeDECODE compares expr to each search value one by one. If expr is equal to a search, then Oracle returns the c原创 2010-10-12 14:48:00 · 637 阅读 · 0 评论 -
Conversion Functions
Conversion FunctionsConversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatypeTOdatatype. The first datatype is the input datatype. The second datatype is the output datatype原创 2010-10-12 14:38:00 · 555 阅读 · 0 评论 -
Basic Elements of Oracle SQL 之 Literals
<br />Literals<br />The terms literal and constant value are synonymous and refer to a fixed data value. For example, 'JACK', 'BLUE ISLAND', and '101' are all character literals; 5001 is a numeric literal. Character literals are enclosed in single quotatio原创 2010-10-14 14:54:00 · 862 阅读 · 0 评论 -
Basic Elements of Oracle SQL 之 Nulls
NullsIf a column in a row has no value, then the column is said to be null, or to contain null. Nulls can appear in columns of any datatype that are not restricted by NOT NULL or PRIMARY KEY integrity constraints. Use a null when the actual value is not原创 2010-10-14 14:58:00 · 581 阅读 · 0 评论 -
Basic Elements of Oracle SQL 之 Pseudocolumns
PseudocolumnsA pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values. This section describes these pseudocolumns:CURRVAL and NEXTVALA sequ原创 2010-10-14 15:59:00 · 637 阅读 · 0 评论 -
Basic Elements of Oracle SQL 之 Comments
<br />Comments<br />You can associate comments with SQL statements and schema objects.<br />Comments Within SQL Statements<br />Comments within SQL statements do not affect the statement execution, but they may make your application easier for you to read原创 2010-10-14 16:03:00 · 796 阅读 · 0 评论 -
Oracle Number Functions
<br />Number Functions<br />Number functions accept numeric input and return numeric values. Most of these functions return values that are accurate to 38 decimal digits. The transcendental functions COS, COSH, EXP, LN, LOG, SIN, SINH, SQRT, TAN, and TANH原创 2010-08-27 14:48:00 · 568 阅读 · 0 评论 -
Oracle Character Functions
<br />Character Functions Returning Character Values<br />Character functions that return character values return values of the same datatype as the input argument.Functions that return CHAR values are limited in length to 2000 bytes. Functions that return原创 2010-08-27 17:15:00 · 960 阅读 · 0 评论 -
Oracle Functions
<br />Functions<br />Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments:<br /原创 2010-08-27 13:23:00 · 1624 阅读 · 0 评论 -
oracle analytic functions
<br />OLAP函数语法的总结<br />ORACLE OLAP 函数<br /> 最近这个东东用得特别多,总结了一下 。 <br />语法: FUNCTION_NAME(,,...) <br /> OVER<br /> ()<br /><br />OLAP函数语法四个部分:<br />1、function本身 用于对窗口中的数据进行操作;<br />2、partitioning clause 用于将结果集分区;<br />3、order by clause 用于对转载 2010-07-23 16:15:00 · 565 阅读 · 0 评论 -
oracle sql loader
1. 首先创建bat文件 my_bat.bat内容格式为sqlldr userid=用户名/密码@数据库 control=控制文件下面参数可以不带,指定log文件log=ld.logbad=ld_bad.logdiscard=ld_dis.log例如sqlldr userid=produsr/prod_123@ffv2dev2 control=my_control.txt2. 控制文件中自带数据my_control.txt内容为:LOAD DATA INFILE * append原创 2010-07-21 11:00:00 · 474 阅读 · 0 评论 -
oracle hierarchical query
<br />Hierarchical Queries<br />If a table contains hierarchical data, then you can select rows in a hierarchical order using the hierarchical query clause:<br />Text description of hierarchical_query_clause:<br />[START WITH condition] CONNECT BY conditio原创 2010-07-21 14:13:00 · 1597 阅读 · 0 评论 -
What Is SQL?
What Is SQL?<br />SQL (pronounced as the letters S-Q-L or as sequel) is an abbreviation for Structured Query Language. SQL is a language designed specifically for communicating with databases.<br />Unlike other languages (spoken languages like English, or原创 2010-06-01 16:27:00 · 605 阅读 · 0 评论 -
Handling PL/SQL Errors
Predefined PL/SQL ExceptionsAn internal exception is raised implicitly whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit. Every Oracle error has a number, but exceptions must be handled by name. So, PL/SQL predefines原创 2010-08-03 17:37:00 · 735 阅读 · 0 评论 -
oracle TIMESTAMP datatype
<br />The TIMESTAMP datatype is an extension of the DATE datatype. It stores the year, month, and day of the DATE datatype, plus hour, minute, and second values. This datatype is useful for storing precise time values. Specify the TIMESTAMP datatype as fol原创 2010-08-02 16:39:00 · 728 阅读 · 0 评论 -
Oracle Operators
<br />An operator manipulates individual data items and returns a result.<br /><br />This chapter contains these sections:About SQL OperatorsArithmetic OperatorsConcatenation OperatorSet OperatorsUser-Defined Operators<br /><br />This chapter discusses non原创 2010-08-18 14:46:00 · 1132 阅读 · 0 评论 -
Oracle Expression Lists
<br />An expression list is a combination of other expressions.<br /> <br />Expression lists can appear in comparison and membership conditions and in GROUPBY clauses of queries and subqueries.<br /><br />Comparison and membership conditions appear in the原创 2010-08-18 16:07:00 · 580 阅读 · 0 评论 -
Oracle Conditions
<br />Conditions<br /><br />A condition specifies a combination of one or more expressions and logical (Boolean) operators and returns a value of TRUE, FALSE, or unknown<br /><br />This chapter contains the following sections:About SQL ConditionsComparison原创 2010-08-24 13:04:00 · 1407 阅读 · 0 评论 -
oracle对大对象类型操作:blob,clob,nclob,bfile
3-4 Lob类型 13.4.1 基本介绍 Oracle和plsql都支持lob(large object) 类型,用来存储大数量数据,如图像文件,声音文件等。Oracle 9i realse2支持存储最大为4g的数据,oracle 10g realse1支持最大8到128万亿字节的数据存储,依赖于你的db的block size。 在plsql中可以申明的lob类型的变量如下:类型 描述BFILE 二进制文件,存储在数据库外的操作系统文件原创 2010-11-02 21:28:00 · 1439 阅读 · 0 评论