Oracle

1. The statement to be rewritten is as followsUpdatetable1 FSetF.ljjine1=(SelectNvlsum(NVL (B.jine1,0)),0) fromTable1 bwhereB.kjqjF.kjqj andB.gs=F.gs andB.bm=F.bm andB.yw=F.yw andB.currency=F.currency andSUBSTR (B.KJQJ,1,4)=SUBSTR (F.KJQJ,1,4)),

A new error message was found recently when monitoring the system log, which is strange, not before. As follows:ORA-24777: The use of non-portable database links is not allowed.The tracker went in. It was discovered that a remote library table was

Test upgrade centos6.6 kernel to Oracle Uek kernelReference:http://www.tuicool.com/articles/IRbU3e[[Email protected] ~]# curl -o https://linux.oracle.com/switch/centos2ol.sh[[email  protected] ~]# sh centos2ol.sh[[email protected] ~]# yum upgradeoh  

Scene:Wrote a stored procedure with a return parameter, which is normal on a different developer's machine. Other machines reported title errors. The depressing thing is that all callers are clients, there is no issue of version inconsistency that

Compiler Warnings Compiler WarningOracle 10g allows-enable compile-time warnings that is useful to identify potential run-time problems in your prog Rams. These warnings is not serious enough to raise a exception at compile time and may cause

Process function ProgrammingPractical purpose(1) Master the basic function of stored procedure and storage function advanced database object.(2) Master the creation, modification, viewing and deletion of stored procedures and stored

This article transferred from: http://blog.csdn.net/gyb2013/article/details/6929697One, what is the lock:The lock mechanism of Oracle is a lightweight locking mechanism that does not lock the data by building a lock list, but instead directly stores

Source: http://blog.csdn.net/itmyhome1990/article/details/16338637 Oracle is a relational database management system that organizes data in tables, and the data in some tables shows a tree-structured connection. For example, there are the following

Problem DescriptionIf Oracle stores number (20,2) data, 0 is 0.00 in the database, 2.1 is 2.10 in the database, 3.88 is stored as 3.88,If the corresponding display is taken directly from the database:0 2.1 3.88 the reserved two decimal places will

In the Oracle database, all the data from the logical structure is stored in the table space, of course, the table space is also a section, area, block and other logical structure. From the physical structure is placed in the data file. A table

The data tables are connected with:1. Inner Connection (natural connection): only two rows that match a table to appear in the result set  2. External connection: including(1) Left outer connection (the table on the left is unrestricted)(2) Right

Remote machine:Installing Oracle's computer;Local machine:A computer that accesses an Oracle database on a remote machine.First, the problem descriptionInstall the Oracle database on the remote computer.On the local machine, after configuring

1.Oracle, the operation of returning the next primary key when MySQL is insertedXML codeOracle:SELECT Seq_role. Nextval as ID from DUALInsert into ROLE (ID, NAME, CREATE, MODIFY) VALUES (#{id}, #{name}, Sysdate, sysdate)Note: the "id" in the

Get a list of dates:SELECT To_char (to_date (' 2014-10-01 ', ' yyyy-mm-dd ') + ROWNUM-1, ' yyyyMMdd ') as Daylist from dualconnect by ROWNUM Get the Month list:SELECT To_char (add_months (to_date (' 2014-10 ', ' yyyy-mm '), ROWNUM-1),

Recently in the use of Oracle, often to import export data, commands are simple, but often forget, so write down.Drop UserYfplssCascade;--log on to the system user to delete the existing user name and everything under that user is deleted.--CREATE

Today we used the partition of Oracle table, and by the way I wrote a few examples to say the partition of this table:First, create a partitioned table1. Range PartitioningPartitioning based on the range of data table field valuesFor example,

1. Change the database character set to GBKSHUTDOWN IMMEDIATE;STARTUP MOUNT EXCLUSIVE;ALTER SYSTEM ENABLE RESTRICTED SESSION;ALTER SYSTEM SET job_queue_processes=0;ALTER SYSTEM SET aq_tm_processes=0;ALTER DATABASE OPEN;ALTER DATABASE National

NULL refers to a null value, or an illegal value.1, NVL (expr1, expr2) functionEXPR1 is null, returns EXPR2, is not NULL, returns EXPR1. Note that the two types should be consistentEg:select NVL (column,0) from DUAL--column value is null, it is

substr (string, intercept start position, intercept length) //Returns the truncated string (containing the start position)Select substr (' HelloWorld ', 0,3) value from dual; --The returned result is Helselect substr (' HelloWorld ', 1,3) value

Solution to integrity conflict when updating primary key values restricted by foreign keys in Oracle stored procedures1. Background Although we do not advocate modifying the primary key in database operations, there is indeed such a business demand