Oracle

First, the simplest loop loop. Loop.sqlCREATE OR REPLACE PROCEDURE loop_demo AUTHID current_useris l_date date;    BEGIN l_date: = sysdate;        LOOP EXIT when l_date > sysdate + 10;        L_date: = l_date + 1; Dbms_output.    Put_Line

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

Original: http://blog.sina.com.cn/s/blog_614b6f210100t80r.htmlObjective:1, do not experience the wind and rain, how can see the rainbow.2, make full use of Baidu, Google and other search engines to find data and integrate analysis!3, nothing is

/*Note: If you already have the appropriate user and table space, you will need to delete the appropriate user and tablespace before re-establishing all*/--Delete UserDrop UserUSERNAMECascade;--Delete Table SpaceDropTablespace data_temp including

from:http://oracle-base.com/articles/10g/utl_dbws-10g.phpIn a previous article I presented a method for consuming Web Services using a basic SOAP implementation. This article provides similar functionality, but this time using UTL_DBWS the package,

Exp and IMP are a logical backup tool provided by Oracle. Logical backup creates a logical copy of the database object and stores it in a binary dump file. This logical backup needs to be used in the case of a database startup, whose export is

Install Oracle 12c Tutorial under the original WindowsDisclaimer: This article originally JMQThis article brings you an installation tutorial for Oracle 12C.1. Prepare for 1.1 download Oracle 12c InstallerRefer to: http://www.wxzzz.com/1231.html

In this paper, the import and export of Oracle data IMP, exp Two commands are introduced, and its corresponding parameters are described, and then through a number of demonstration examples to drill, deepen understanding.At the end of this paper, we

To_date ("String to convert", "converted format") The format of the two parameters must match, otherwise it will be an error. That is, the first argument is interpreted in the format of the second parameter.To_char (date, "convert format") converts

http://blog.csdn.net/xdweleven/article/details/38319351(1) des cryptographic functionsCreate or Replace functionEncrypt_des (P_text varchar2, P_key varchar2) return varchar2 isV_text varchar2 (4000);V_ENC varchar2 (4000);Raw_input RAW

Compare full and incomplete restores:A. Full recovery: Restores the database to its current state, including all committed data changes until the request is resumedSecond, incomplete recovery: Restore the database to the last point of time specified

The idea is to write a function to query the data conditionally, if the query to the data is updated, if no query to the data is inserted:Create or Replace function Fn_merge_index (statdate in date, cpid in VARCHAR2, Indextypecode in number, Inde

Sqlplus is a very concise management tool developed by Oracle, and Sqlplus is the best and most core Oracle management tool. Sqlplus is simple and efficient, giving up flashy, anti-basics. Using Sqlplus, go to Sqlplus and do a simple operation to

Operating system: windows2008Database: oracle11gProblem occurs: A set of normal run a year of application system, suddenly unable to connect to the database, but another application can be normal link, data storage normal.Database server-side

Use Cloning to install Oracle 11g, then use CADB to build the library error:ora-12547:tns:lost ContactFor such a not obvious mistake, it is very difficult to locate the problem of confirmation, the Internet gave a lot of advice:1, lack of bags,

Physical memory requirements: Minimum 1G, minimum 2G on windows7,windows8,windows8.1.Virtual memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2GB and 16GB Equal to the

Oracle RAC has both ha (high availiablity) and lb (loadbalance). And the basis of its highly available Failover (fail over)  It means that the failure of any node in the cluster will not affect the user's use, the user connected to the failed node

Oracle study--rman enable block change tracking errorSystem environment:Operating system: RedHat EL6Oracle:oracle 11g R2Target Db:prodCatalog DB:ORCLAfter making an incremental backup using Rman Backup, a ORA-600 error occurred while starting "Block

Oracle BASICS (1): Use the oracle instance and SQL * plus commandI. Three-tier structure of oracle Database1. Client: used to access databases. Such as sqlplus and pl/SQL dev. 2. database Server-oracle dbms (database management system). This is what

Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~)Oracle Core Technology jump to: navigation, search DirectoryStart 12redo and undo3. Transactions and consistency4. locks and latches5 cache and