Oracle

Today needs to be in the station all the spatial data to do the storage processing, therefore installs the Oracle on the server, needs to connect to it in the local, has looked up the related information on the net, organizes as follows:Remote

1 GrammarGreatest (Expr_1, expr_2, ... expr_n) 2 DescriptionGreatest (expr_1, expr_2, ... expr_n) function from an expression (column, constant, computed value) expr_1, expr_2, ... expr_n and so on to find the largest number to return. When

After upgrading the DB cluster to 10.2.0.5, the two-node server restarts continuously, querying the Oracle OPROCD process log for the following information:Jul 03 08:16:34.702 | INF | Monitoring started with timeout (+), margin ($), Skewtimeout (03)

Select To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss '), To_char (Trunc (sysdate), ' Yyyy-mm-dd Hh24:mi:ss ') from dual T;--sy Sdate and Trunc (sysdate) are not the same sysdate at zero of the day 0 minutes 0 seconds equals trunc (sysdate) Select Trunc (

A database is a shared resource used by multiple users. When multiple users access data concurrently, the database generates multiple transactions with simultaneous access to the data. If the concurrency operation is not controlled, it is possible

SELECT level, To_char (to_date,'J'),'Jsp' ) from dual to level1000 The results of the operation are as follows:DescriptionTo_char (adate, ' JSP ') refers to the date adate the first day of the Julian date, the number of days 4712-01-01BC,

Current Month Day SELECT trunc (sysdate), trunc (sysdate,'dd') from dualThe first day of the year SELECT trunc (sysdate,'yyyy') from dualFirst day of the month SELECT trunc (sysdate,'mm') from dualWhen the first day of the week SELECT

Problem These two days have just configured plsql with Oracle , but when inserting data in plsql , there is a problem The table in Plsql cannot be displayed in Chinese, Chinese cannot be saved, cannot be exported, Chinese displays a question mark

In versions prior to Oracle 9i, it was extremely inefficient to restore the user's operational errors if the user had committed the delete or update by mistake.To this end, Oracle provides a flashback feature that allows us to recover the correct

Code:SELECT A.first_load_time, A.sql_text, S.sid, s.serial#, S.program--,, a.*--Ut L_inaddr.get_host_address (s.terminal) Ip from V$sqlarea A, v$session s WHERE s.sql_address (+) = A.address and Upper (A.S Ql_text) like '%delete

select sysdate from dual t;--system date Select To_char (sysdate, ' yyyy/mm/dd HH24:MI:SS ') From dual t;--formatted date Select To_date (' 20140630 18:28:20 ', ' yyyy/mm/dd HH24:MI:SS ') from dual t;--formatted date Select

1. Error descriptionJava.sql.sqlexception:ora-0064:error occurred at recursive SQL level 1.ora-06153:unable to extend table SYS. aud$ by 8192 in Tablespace SYSTEM. Ora-02002:error while writing to audit trail. Ora-00604:error occurred at recursive

 Oracle 10g RAC Start-Stop archive modeIf the Oracle database is running in archive mode, you may need to pause the archive of the database when you perform database maintenance, and then restart the archive mode after maintenance is complete.You

Oracle query optimization using exists can be more speed than using in, of course, this can only be in the case of only one in, generally there are multiple in the case, can not be all in the exists, I am not clear, I just based on the actual

-- Query Date language typeSelect * from v$nls_parameters; Select * fromnls_session_parameters --to_date (NULL) the usage (insert NULL Field ?? )Select 1, to_date (null) from dual; -- actual Time 2012-12-04 18:22 The test results are as

Recently, because the project rushed to the line, has not had time to continue to write a blog, today finally empty time. Fame: I am not a professional art, so interface problems, I hope you do not shoot bricks. The login interface is as follows:in

For advanced usage of INSERT statements in Oracle, the Insert all statement describes:1. Insert all inserts unconditionallyCREATE TABLE T1 (product_id number, product_name VARCHAR2, MONTH number), insert into T1 VALUES (111, ' Apple ', 1); INSERT

Problem: In the SQL Server database, the attribute of the auto-incrementing column is convenient to use. But Oracle does not have this function. How can this function be implemented? A: Although there is no auto-increment column in Oracle, it can be

Download the patch package p8202632_10205_linux-x86-64.zip from the cluster environment 10.2.0.5 or above this day. decompress the package and install the package. An error is reported during the process: I/O ERROR cannt reading or opening file

Stealing: http://www.blogjava.net/hello-yun/archive/2011/04/08/347890.html Table TESTA, TESTB, and TESTC have two columns, A and B: TESTA (A, B) | TESTB (A, B) | TESTC (A, B) 001 10A | 001 10B | 001 10C 002 20A | 003 30B | 004 30C   There are two