Oracle

What is consistent reading?Consistent reading refers to a change in the middle that is ignored from the moment of query.Examples ShowFor example, I have two accounts, a, B. A has 1000 pieces and B has 1000 fast. When I query the query speed is

The purpose of the SQL Union All directive is to merge the results of the two SQL statements together. The difference between SQL union All and SQL Union is that SQL Union all lists every qualifying data, regardless of whether the database is

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2011-3-18 today's date is 2011-3-182.select trunc (sysdate, ' mm ') from dual--2011-3-1 returns the first day of the month.3.select

Host IP Address: 10.1.1.x Gateway: 10.1.1.1Virtual Machine node IP address (created on local workstation): 10.1.1.101~253 Gateway: 10.1.1.1Teacher Machine (VNC): 10.1.1.250Teaching Production library ip:10.1.3.3 do not use this virtual device.Shared

About Oracle:1, Oracle database software-Install the OS on the2, the acquisition path of software, business sales strategy.3. Database version: 9i--10%10g--65%11g--25%--new systems are common12c--Latest Version8i--internet9i10g--gird

Iii. Introduction to data dictionaries and dynamic performance views1. Data Dictionary of the database(1) Dba_ data dictionary for all objects of a whole libraryOnly system users have permission queries(2) All_ object created by current user + other

Oracle has to start two services:1.oracleserver***. (' * ' means that the database name is also known as an "instance" and a service represents a database)2.oracleoradb11g_home1tnslistener. (only start this to connect to the database via JDBC)Oracle

Project, use a sequence as a single number, the framework is used by SSH, when the DAO layer to fetch, run times wrong to dual is not mapped,[select *.nextval nextvalue from dual]Later, the inspection found that the way to get the wrong, so change

oracle024 Oracle's storage structurestorage structure-the storage structure of tablesTablespace: Consists of one or more files, and the spatial capacity of the tablespace is the sum of multiple file sizesTables and data files create a middle tier

oracle004Startup and shutdown of Oracle-related programs: off: EM, Isqlplus-->listener--Database Isqlplusctl stop, emctl stop Dbconsole--&G T;lsnrctl stop-to--there are two ways: 1. Dbstop 2. Sqlplus As/sysdb--shutdown immediateOpen:

Can't login em, execute emca-config dbcontrol db do not know always default 1522 port number, helpless, Google some, from the second step below to start execution ... (My monitor is fine)1. Open the net config Assistant in the Oracle Configuration

Scheduled execution of stored procedures in peacetime development often used, years ago when they did a, because the time relationship has not been able to record, is now recorded.First, a complete example is used to implement the stored procedure

Both the Windows environment and the UNIX environment enable automatic database startupIn the Windows environment:The experimental method is relatively simple, by modifying the registry or by using the Oradim command:Oradim-edit -startmode

Records of deposits and generaI. Steps to install a databaseSecond, download the databaseAddress: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlThird, view system resources and environmentInstall the required

In the default, the Oracle database under Linux will not boot, but many times we need to boot the database, so we need to set up the following methods:System Environment: CentOS 6.5Oracle Version: 10.21. Modify the/etc/oratab file #

Look at the contents of the table you are using firstSELECT * from YHB;Desired effectConcatenate strings for the isdropout column of times 1Isdropout TimesYes, no, it's 1.1. Using the Wmsys.wm_concat (EXP1) functionThe SQL statements are as

Oracle11g installation and configuration EM You cannot log on to EM. If you execute emca-config dbcontrol db, you do not know that the default port number is 1522. But google will execute the command in step 2... (My listeners are fine) 1. Open

Oracle Auto-start By default, Oracle databases in Linux do not start on their own, but many times we need to start the Database on their own, so we need to set the settings as follows: System Environment: CentOS 6.5 ORACLE version: 10.2 1.

ORACLE11G manual database creation  Step 1: Directory -- Database file directory $ Cd $ ORACLE_BASE/oradata $ Ls -- View the SID of an existing database PROD $ Pwd -- Check the absolute path. /U01/app/oracle/oradata $ Mkdir HYL $ Ls-l -- Production:

ORACLE10G manual database creation  Step 1: Directory -- Database file directory $ Cd $ ORACLE_BASE/oradata $ Ls -- View the SID of an existing database PROD $ Pwd -- Check the absolute path. /U01/app/oracle/oradata $ Mkdir HYL $ Ls-l -- Production: