Oracle

This involves the physical and logical structure of the database.First, you need to understand that the physical structure of the database is determined by the operating system files of the database, each Oracle database consists of three types of

has been using Oracle, recently studied the next MySQL, first listed MySQL strange features1. The time of millisecond accuracy cannot be stored.2. If there is a varchar, char will automatically become Varhar.3. Timestamp time range is smaller than

Because the Data Warehouse ETL process, the execution time of a mapping more than one hours, Select event,count(*) fromv$session_wait Groupbyorder Bycount (*) descFind that log switching takes a lot of time to try to increase the size of the redo

From:http://www.cnblogs.com/yjmyzz/archive/2013/11/01/3400999.html"Odp.net Managed" has been released for some time, recently there is a new project, want to try to use, refer to the Garden article: ". NET Oracle Developer Gospel--odp.net Managed

Before using Oracle, you have to install his bloated client, although the Internet also provides direct-to-Oracle driver, but also to charge, recently Oracle finally enlightened, provide the official full-managed drive.This is the Oracle all-managed

Although the ORM mapping is used in the project, the optimization of the Oracle system is valuable, which summarizes the commonly used statements from the perspective of SQL statements.1. Optimizations in the From field:Oracle Yasuteru Load table

Http://zhidao.baidu.com/link?url=wY9qYTQHX7YksWmE9LtF4UIOkJgCDi8mXS7XkWi9u0GcD9dh0Evr7OHVzSsPDZAH6F258S4b3KAdkKvKLoPVOqhttp://blog.csdn.net/thinkscape/article/details/7411012:+++++++++++++++++++++++++++++Steps:--Create tableCREATE TABLE

Sysdate 2009-6-16 15:25:10 　 TRUNC (Sysdate) 2009-6-16 　 To_char (sysdate, ' YYYYMMDD ') 20090616 to Japan To_char (sysdate, ' YYYYMMDD HH24:MI:SS ') 20090616 15:25:10

--upper-------Convert characters to uppercaseSELECT Upper (' ABCDE ') from dual;--lower -----Convert characters to lowercaseSELECT Lower (' ABCDE ') from dual;--initcap----- Returns the first letter of all words in uppercase, other lowercase

--Take the date of the first day of the one months before the current date select Last_day (Add_months (Sysdate,-2)) + 1  from dual;--take the date of the last day one months before the current date select Last_day (add _months (Sysdate,-1)) from

PackageCom.hanqi;Importjava.io.IOException;Importjava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.*;Importjavax.servlet.ServletException;ImportJavax.servlet.http.HttpServlet;Importjavax.servlet.http.HttpServletRequest;ImportJavax.servl

ORACLE Installation of Automatic Installation Software Package for the first time1. Configure the yum repository definition package.txt package list file in advance for the required software package for automatic installation: Take the official

SQL * LOADER error summary, sqlloader Summary When using SQL * LOADER to load data, there will always be various small problems due to the diversity of flat files and data formats, the following are some errors that may occur during the process of

Preliminary understanding of oracle architecture (1)When I first started learning oracle, I recorded my study notes. If you have any mistakes, I hope you can give me more advice. First, go to an important figure in the oracle architecture, as shown

Oracle architecture (1)Database and instance database: a collection of physical operating system files or disks. When Oracle's ASM (Automatic Storage Management) is used or RAW partitions are used, the database may not be used as a separate file in

Oracle architecture (2)Dedicated servers and shared servers 1. when I log on to a dedicated server, Oracle will always create a new process for me to connect to the Oracle server. The configured server is called the dedicated Oracle Server, this

Oracle rman catalog backup and recovery1. the loss control file starts the database to the nomount status: restore controlfile from autobackup/restore controlfile from '+ data/backup/contrlbak /... '-> alter database mount-> open; 2. accidentally

Oracle SQL BASICS (3)-index/trigger/view operations1. index. create index idx_name on fdh_client_info (name); -- create unique index uni_idx_id on fdh_client (id); -- create index union_idx_name_addr on fdh_client (name, address); -- Union index B.

Obtain the first day of the month, the last day, and the first day of the year based on the accounting period. DECLARE V_PERIOD_BEGIN_DATE DATE; V_PERIOD_END_DATE DATE; 1_date; V_PERIOD_NAME VARCHAR2 (20): = '2017-11'; begin select TO_DATE

Obtain the first day of the month, the last day of the year, and the last day of the month based on the accounting period. Simply record it to avoid forgetting: DECLARE V_PERIOD_BEGIN_DATE DATE; V_PERIOD_END_DATE DATE; 1_date; V_PERIOD_NAME