Oracle

============================================= successfully installed the database =======================================================1. If you have two files when installing the database, you need to merge the two files before installingAfter

--(' table ', ' line ', ' ods_xx ') all the tables and users in this case need to be capitalized.If the table name user name is not written, the error is reported: the object "EMP" is of type table, not found in the scheme "Scott"Pro-Test code:Set

Demand:Match the phone number, the first bit can be +, can not +, the back of all if the number, such as:+86135941566586136595585551356856455are legal.+aa156945555aa1359556666Aaddssdfdfsdare not legal.Regular:[SQL]View Plaincopyprint? Sql>

1. View the current system version[Email protected] disk1]$ Sqlplus'/as sysdba'SQL*plus:release10.2.0.1.0-Production on Thu Jan the -: +: + -Copyright (c)1982,2005, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition

Problem:Check out the employee's name, job, and salary, which are higher than the salary of all sales staff.Analysis:Any can represent arbitrary, but this problem requires a higher salary than all salespeople, then use a different keyword all.All is

Four states of tablespace: Online,offline,read Write and ready onlySql> select file#,status,enabled from V$datafile;file# STATUS ENABLED--------  ---------           -------------1 SYSTEM READ WRITE2 ONLINE READ WRITE3 ONLINE READ WRITE4 ONLINE READ

Sql> Select substr (' Liuyuehui ', 3) as first_name from dual;First_Name--------------UyuehuiSql> Select substr (' Liuyuehui ', 1) as first_name from dual;First_Name------------------LiuyuehuiSql> Select substr (' Liuyuehui ', 0) as first_name from

The DML error log is a sql*loader-like error logging feature introduced by ORACLE10GR2. The rationale for this is to transfer any records that might cause the statement to fail and put them in an error log table.The specific use is as follows:1, use

Oracle Database Restore, how to restore a DMP file to the Oralce library  Recently used to restore data from Oracle's DMP file because there is no such information, collected on the Internet, I believe that the following information, we can

 Oracle database, all the data from the logical structure is stored in the table space, of course, the table space is also a section, area, block and other logical structure. An Oracle database can have one or more table spaces, while one table

/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace contract_tempTempfile ' D:\oradata\contract_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* Step 2nd: Create a

Non-original, purely note-takingInstall: Basically follow the default next installation  1) Executable installation file "setup.exe" double-click Install 2): Configure security update, cancel the following "I want to accept security update with my

Test under Archive mode:A. Open state physical Delete data file, shutdown condition Recovery:sql> Create tablespace Test datafile ' +data/mecbs/datafile/test01.dbf ' size 10M;Tablespace created.Sql> Conn Scott/scott;Connected.Sql> Conn/as

Decode function is very useful in the actual development, and the function is more powerful, with other functions, can make a lot of work easier;DECODE ( field , condition 1, result value 1, condition 2, Result Values 2, ... Default Value  ); The

Original: Oracle Base database backup and RecoveryFirst, why need data backupThe main reasons for data loss:1, media failure.2, the user's error operation.3, the server's complete collapse.4, computer viruses.5. Unforeseen factors.The fault types in

Transfer from Http://wenku.baidu.com/link?url=uD_ Egkkh7jtuyjarv8ym6k8clbt6gpjs4ulsy5wkhz46d9bnychtpdgjgd7y6uxytbnhq3ixsgeap0aabtulnqcvwjkgm2lyzpcbx544zrgOracle Database EXP/IMP command details exp/imp commands     EXP/IMP Two commands can be said

Select Case whenTo_char (Last_day (Add_months (Trunc (Sysdate,'y'),1)),'DD')= ' -' Then 'Common year' Else 'Leap Year' End asIsleapyear fromDualThe first step: the date of the beginning of the date; the second step: the beginning

Previously written on how to manually install Oracle's jdk:http://www.cnblogs.com/bcsflilong/p/4196536.htmlIn fact, there is a simple and convenient way to install with Apt-get.First add a software source1 sudo add-apt-repository

The ora-12514tns listener cannot identify the Service requested in the connection Descriptor Today, when you remotely connect to a linux server, this error occurs: tnsnames. ora and listener. ora file configuration is not wrong, but is not connected

Oracle-specific index type resolution2.1 B-tree index (default type)The B-tree index is a common index in Oracle. When creating an index, it is the default index type. The B-tree index can be a (simple) or composite (multiple columns) index. The