Oracle

Oracle Basic Grammar Collection1. Table CREATE TABLE test (names VARCHAR2 (12),Dates date,Num INT,Dou double); 2. View Create or replace view vi_test asSELECT * from Test; 3. Synonyms

Create a temporary table spaceCREATE Temporary tablespace test_tempTempfile 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'SIZE 32MAutoextend onNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL; Create a user table spaceCREATE tablespace

Recently the company used Oracle, installed in the UBUNTU64 bit, encountered some problems, on the Internet to find some answers, here as notes recorded.1. First download Oracle and unzip no more.2. Installing dependent Packagessudo apt-get install

1.ASCII returns the decimal number corresponding to the specified character;Sql>select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;2.CHR gives an integer that returns the corresponding character;Sql>select chr (55203)

At the time of development, I encountered the need to change the field type of the data table from number to varchar, but the field has a value.Use ALTER TABLE t-name modify CNAME newType;Words, at that time on the internet did not find the right

Table Space :Oracle allows different types of data to be stored separately, and Tablespace is a logical division of the database.Data Files :A tablespace consists of one or more files on the same disk, which are called data files.Example :is the

Oracle 10g no graphical interface installationThis document is installed when the Oracle environment variable has been configured and is not missing a dependent package;Unzip the Oracle installation package,First VI

--Build table statementsCREATE TABLE Student (ID number (9), name VARCHAR2 (+), age number (5));CREATE TABLE Class (ID number (9), name VARCHAR2, Teacherid number (9), StudentID number (9));CREATE TABLE Teacher (ID number (9), name VARCHAR2 (+), age

First, the phenomenonWhen you delete a primary KEY constraint in oracle10g, you still report a "ORA-00001" error when inserting duplicate data.Second, the reasonOracle has adjusted the intrinsic function "Atbdui" in the 10g release, causing the user-

Tag:localhost   private    database connection    oracle    public class dbcon {//  database Driven Object public static final string driver =   "Oracle.jdbc.driver.OracleDriver";//  database connection address (database name)

Usually to build a large number of Oracle test environment, repeat more and feel the trouble, simply the entire script to create a number of environment variables before the installation of Oracle and other related configuration, improve the

Check the statements of Oracle dead transactions SQL> SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */ 2 KTUXESTA Status, KTUXECFL Flags ,KTUXESIZ 3 FROM x$ktuxe 4 WHERE ktuxesta!='INACTIVE'; KTUXEUSN KTUXESLT KTUXESQN

The difference between rownum and rowid in the Oracle query statement: rownumrowid This article mainly introduces the differences between rownum and rowid in Oracle queries in the form of examples, and takes the assumption as an example, the query

[Translated from mos] In the 11gR2rac environment, the file system usage is tight, and lsof shows many oraagent_oracle.l10 (deleted) In 11gR2 rac environment, the file system usage is tight, and lsof shows many oraagent_oracle.l10

Conversion between ORACLE milliseconds and dates Convert millisecond to date 1 2 3 SELECT TO_CHAR (1406538765000/(1000*60*60*24) + TO_DATE ('1970-01-01 08:00:00 ', 'yyyy-MM-DD HH: MI: ss'), 'yyyy-MM-DD HH24: MI: ss') AS CDATE

In Linux, Oracle11GRAC reports an error: An Example of filenotfound was reported when oracle software was installed. In Linux, Oracle11G RAC reports an error: file notfound is reported when oracle software is installed.1. symptom Everything has been

Oracle initialization parameter files pfile and spfileDifferences between pfile and spfile Pfile: Before Oracle 9i, ORACLE used PFILE to store initialization parameters. This file is a text file and can be modified at the operating system level.

How to permanently delete an Oracle database to create a database with the same instance name I chose the OMF method when creating the database today. The result file name is automatically named in Oracle. I cannot understand it, so I decided to

Batch Data insertion in oracle Once a function was developed, tens of thousands of pieces of data provided by others need to be imported, There are about 80 thousand pieces of data in a *. SQL file. Insert into testtable (id, name) values (1, '1')

Oracle removes line breaks from data to avoid reading problems. After a lot of data is stored in the database, you may need to extract the entire data and separate it with special symbols. The entire data must be in one row.When the line breaks,