Oracle

I. Maintaining the integrity of the dataData integrity is used to ensure that database data complies with certain commercial and logical rules, and in Oracle, data integrity can be implemented using three methods of constraints, triggers,

After Oracle has been running for some time, the system will automatically give some tuning recommendations, placed in the Dba_advisor_actions view, in the main fields of the view, see below:Task_name--Optimize task NameExecution_name--Execution

--a data sheet for storing the re-ratingCREATE TABLE ZZPFapache2(Zz_datetime date,--timeZz_zongfen INTEGER,--TotalZz_shiwanglui INTEGER,--mortalityZz_bingrenid VARCHAR2 (50),--Patient IDZz_h1f1 INTEGER,--1th row 1 pointsZZ_H1M1 VARCHAR2 (40),Zz_h1f2

one, character functionsThe character function is the most commonly used function in Oracle, so let's see what the character functions are:Lower (char):Converts a string to a lowercase format.Upper (char):Converts a string to an uppercase

CREATE TABLE t2 as select * from Dba_objects; Build index:Create index idx_t2 on T2 (object_id);2. Collect statistics for all the columns and all indexes on the table for the T2 table:EXEC dbms_stats.gather_table_stats (ownname=> ' SYS

In the process, especially the tasks performed daily, usually to check that the query's data table exists, if it does not exist and wait for a period of time to execute, the following code implements this function, if the table does not exist, throw

In daily use, this is often the case where the rows of the database need to be converted into columns, such asConverted to this time, we need to use the pivot function after Baidu, reference URL http://www.2cto.com/database/201501/367164.html,

In the project development, sometimes use multi-table query, there are many methods, such as correlation, such as views, but for the query, view query is the fastest, if you have a lot of database field information, the query will have to check the

The most basic Oracle database connection code (for oracle11g only):1, right-click Project, build path, configuration build path, select the third item "Library", then click "Add External Jar" and select "D:\Oracle\app\oracle\product\11.2.0\server

First, prefaceToday, in the program's log, this error occurred, searching the web to find that Oracle's object name is up to 30 characters, not more than 30, and my error SQL is:"Select*fromwhere to_date ('2016-05-28 09:51:58 'yyyy-mm-dd HH24:mi:ss'

Syntax delete from AA truncate TABLE AA distinguishes 1.delete from back can write conditions, truncate not available. 2.delete from records are deleted, each row of records will go into the log, and truncate delete the entire page at once, so the

Display information for all partitioned tables in the database: Dba_part_tablesDisplays all partition table information that the current user can access: all_part_tablesDisplays information about all partitioned tables for the current user:

The data structure is similar to sql> select * from T;B E N----------------- ----------------- --------------------20150106 01:00:02 20150106 01:00:42 A20150106 01:00:02 20150106 01:00:12 B20150106 02:01:02 20150106 01:10:03 C20150106 02:01:07 201501

The definition and functions of Rman:1) Recovery Manager Tool2) Build backup and recovery server process with Oracle-provided packages for backup and recovery on Oracle server3) Rman Backup database, tablespace, datafile, Controlfile, SPFile,

Oracle error highlights: ORA-00119 & ORA-00132 Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is very strange, and no

Oracle remove tablespace data file ora-00604ora-01426Zookeeper Project Background: Database Management in the previous development environment is messy. When the tablespace is insufficient, only data files are added. After the test, the data has

Clear the Isolated Data Pump job in DBA_DATAPUMP_JOBS, dba_datapump_jobs Today, when restructuring the database (transferring tables and indexes in the tablespace to other tablespaces), we found two strange objects: SYS_EXPORT_FULL_01 and SYS_EXPORT_

Impact of DDL statements on transactions in OracleZookeeper 1. Impact of DDL statements on transactions in OracleIn Oracle, when executing DDL statements (such as Create Table and Create View), a Commit command is automatically issued before

Oracle sets the User Password usage time How do I set a password to force a regular password change?Assume that the password must be modified after 10 days, and the grace period is 2 days: Call the computer time back for ten days, and then log

Oracle startup service details After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle