Oracle

Because Oracle sets the primary key is not automatically incremented, you must use sequences and triggers to complete the increment of the primary key1. Set up a data sheetCREATE TABLE Test_increase (UserID Number (primary key,/* Establish PRIMARY

SELECT * FROM (select T2.cadastralno parcelid,t1.pkid taxpayerid,t2.taxtype taxtype,t1.booktype Taxpayertype,T2.cadastralno Parcelcadastralno,t2.landuser Parcellanduser,t1.payername TaxpayerpayernameFrom Grid_sysdb.bss_taxpayers

To_date format (in time: 2007-11-02 13:45:25 for example) year:yy two digits two-bit year display value: 07yyy three digits three-bit year Display value: 007yyyy four digits four-digit year display value: 2007month:mm number two-bit month display

This article has looked for an Oracle architecture diagram from the Internet for an overall description of Oracle 's Architecture 1 oracle database mainly has data files Database instance composition. Users are linked to server process

the background of the story is this: a project about 4 projects at the same time development, in my own project need to make a report, but to access another project connected to the DB, of course, the two projects of the DB server is on the same IP,

The original database server uses Rman for a full-library backup, and then restores the exact database on the offsite server1.1Original Server Backup DatabaseThe first step is to view the database instance name and DBIDConnected to target

A problem occurred in the previous period, that is, restarting a RAC node suddenly reported that the recovery area is insufficient, check that there should be no problem, has been modified to 500G, there should be more than 200 g of the remaining

Common commands for Sql*plusConnection command1.conn[ect]USAGE: Conn username/password @ NETWORK SERVICE name [as Sysdba/sysoper] when connecting with a privileged user, you must bring as SYSDBA or as Sysoper2.disc[onnect]Description: This command

1. Cursor ConceptsWhen you execute a SELECT, INSERT, delete, and UPDATE statement in a PL/SQL block, Oracle assigns it a context area, or buffer, in memory. A cursor is a pointer to the area, or a structured data type. It provides a method for

To_dateTo_date (Char[,fmt[nlsparams])Char: the string to convertFMT: FormatNlsparams: Specifying a Date languageFor example: Enquiries about employees who have entered the workforce after 2002 years:SELECT * from emp where hiredate>to_date (' 2002-01

Transferred from: http://database.ctocio.com.cn/tips/286/8104286.shtmlAbout partitioned tables and partitioned indexes (about partitioned Tables and Indexes) are basically divided into several categories for 10GR2: Range (range) partition

1. Check host name/IP, portThe host name/IP and port are recorded in the $oracle_home/install/portlist.ini file at the time of installation.The default is:General User Http://ip:5560/isqlplusDBA User Http://ip:5560/isqlplus/dbaEM Database Control

--Query whether a table has a unique primary keySelect cu.* from User_cons_columns cu, user_constraints au where cu.constraint_name = Au.constraint_name and Au.constraint _type = ' P ' and au.table_name = ' table name '--Query whether a table has a

A simple understanding of Oracle's SCN is its own time function, like the Linux system's own time, and Oracle has its own set of time.When you clean the database shutdown immediate or use ALTER system checkpoint will write the value of the SCN to 4

1. All configurations are the same as the file system . 2. Planning:Added 8 small plates, ASM for experiment using Asmlib Drive (rhel6 no longer supports Asmlib drive), 2 methods for bare devices (Rowdevice and Udev)Three discs using Asmlib, two

1. Locate the Oracle installation directory, and then locate the Tnsnames.ora fileModify the relevant file contents:XE =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.107) (PORT = 1521))(Connect_data =(SERVER = dedicated)(service_name =

Analysis on the storage format of Oracle nested tables Oracle nested tables are rarely used. The following describes how to store them. For example, a user corresponds to a department. SQL> select * from v $ version;BANNER----------------------------

Oracle: view the table space where the user is located; oracle: view the user's location  View the tablespace of the current user [SQL]View plaincopy Select username, default_tablespace from user_users; Modify the user's default

[Oracle] RAC deletes a node Environment: OS: OEL5.6 RAC: 10.2.0.1.0 There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node. 1. Delete the database instance on the rac3 Node [Oracle @ rac1 ~] $

DBA_Oracle LogMiner analyzes redo and archive logs (CASE) (Oracle records any operation logs and how to analyze logs), dba_oraclelogminer 2014-08-19 BaoXinjian I. Summary Oracle LogMiner is a very useful and free analysis tool that allows you to