Oracle

From:http://soft.doit.com.cn/article/2012/0105/2850851.shtml --Addition --plus 1 yearsSELECT sysdate,add_months (sysdate,12) from DUAL;--Add JanuarySELECT sysdate,add_months (sysdate,1) from DUAL;--plus 1 weeksSELECT Sysdate,to_char (sysdate+7, '

--Exception handlingDeclare Snum number: = 0;Begin Snum: = 5/snum; Dbms_output.put_line (Snum); When others then Dbms_output.put_line (' is error! ');End--Custom exceptionsDeclare Ex_custom_invaild_age exception; --Custom Exception

1. Character types Data type Length Description CHAR (N) Default 1 bytes, maximum n value is 2000 Padding at the end to reach the specified length, exceeding the maximum length error. The default

--取第几天的数据。select* fromtablewheretrunc(sysdate)-trunc(cr)=1; select* fromtablewheretrunc(sysdate)-trunc(cr)=2; select

Concept: Sub-query unwrapping (subquery unnesting) is an optimization of the target SQL that the optimizer handles for the band query, which means that the optimizer no longer treats the target SQL subquery as a separate processing unit to execute

After the Oracle server is restarted, the following error is encountered when using the Toad client to connect to Oracle:Oracle Ora-12514:tns:no ListenerTns:listener does not currently know of SID give in Connect descriptorStep one: Start TNS

1. Switch archive, perform rman full library backup2. On the transmitting server.3. Restore it--create a corresponding directory1. Modify the configuration file, proportionally modify the configuration parametersCreate a corresponding directory

That day to share the download and installation of Oracle process, the need for friends can learn from reference. It would be appreciated if there were any similarities!You can first download Oracle's latest version of Oracle database to Oracle's

Cited:To illustrate this, a score table is created, as shown in:Comparison:1, in SQL, these two functions we can only use case, the code and the results are as follows:Select Name,Case SubjectWhen ' Chinese ' then 1When ' math ' then 2When ' English

Differences and linkages between functions and stored procedures in Oracle "reproduced Bamboo Lek Pinellia"In Oracle, functions and stored procedures are often used, and there are many similarities in their syntax, but they also have their own

Abnormal Oracle Error number Sqlcode value Throw the opportunity Access_into_null ORA-06530 -6530 The program attempts to assign a value to an uninitialized (automatically assigned null) object's

Instance-level monitoring, open and low overhead:To create a base table:create table sys.sesstat_history tablespace eol asselect c.username,        c.osuser,       a.sid,        c.serial#,       c.paddr,        c.process,       c.logon_time,    

The online redo log of the Oracle database contains an operational record of all the data in the database, and we can do a lot of things with redo logs, such as log mining.Sometimes, for a variety of reasons, our online log was mistakenly deleted or

Recently did an export work, in the process of using Xshell, found in their own computer with the CMD command to export the DMP file, in the Xshell tool to export the times wrong.Commands executed on CMD: exp ***/*** @oracle file=d:\tbissamt.dmp

I was installed this evening Oracle, the result in the second step encountered this problem, before and after two hours, Baidu has a lot of solutions, finally solved the problem;Because my computer system is still the Win7 system, the other I have

Oracle large table cleanup truncate... reusestorage Recently, a large table needs to be cleaned up, which requires no impact on performance. In MySQL, we can minimize I/O by using coreutils and hard links. Oracle can also minimize I/O by recycling

[Experiment-video process] oracle control file increase and decreaseControl File The control file is a binary file. The control file records the structure and behavior of the database. When the database is opened during the mount operation, it is

Manual cleaning of Oracle audit records Oracle Database Audit is very powerful, usually including standard audit (including user-level audit and system-level audit) and fine-grained audit. Even so, it is easy to cause performance problems if you are

PL/SQL learning gift 1 Bulk_Collect call method collection, plbulk_collect All examples in this article are derived from Chapter 6 of the ebook "Expert pl SQL Practices. Xiao Chen thinks that it may be used in the future in the process of learning

Input table name learning for stored procedures in Oracle. Input table name in Oracle stored procedure: 1. dynamically clear data from the tableCreate or replace procedure p_deletetable (I _tableName in varchar2) as -- Define the SQL statement