Oracle

I. Oracle ArchitectureOracle 's architecture is the composition of the database, the work process, and the organization and management of data in the database, to understand The architecture of the Oracle database, you must understand the Oracle

Look at a topic: Query the EMP table information, display the first 5 rows of data, this time we need to use the concept of Pseudo-column (rownum).RowNum in the data table is not a real column, in fact, each row should have a line number, this

1. USERENV (OPTION)Returns the current session information.Option= ' Isdba ' is true if it is currently a DBA role, otherwise false.option= ' LANGUAGE ' returns the character set of the database.Option= ' SESSIONID ' is the current session

[Email protected] rac1>select Group#,member,status from V$logfile order by 2;group# MEMBER STATUS---------- --------------------------------------------------------------------------- -----------1 +data/racdb/onlinelog/group_1.261.9423395811

Flash back version query, with additional logsFlashback transaction Queryhttp://blog.csdn.net/laoshangxyc/article/details/12405459 the backup and recovery of this blog can be consulted###################################http://blog.itpub.net/18922393/

Oracle's default account and password are listed in the following three ways: User name: sys password: change_on_install User name: System Password: Manager User name: Scott Password: Tiger Start->cmdRun the following command:

1. Because Oracle is installed on a virtual machine, opening the VMware virtual machine sometimes has the following error:Workaround: Run-->services.msc--> to open the VMware service because the virtual machine service is not open2.ora-01034:oracle

[Email protected] rac1>select group#,thread#,members,status,bytes/1024/1024 as size_m from V$log;group# thread# members STATUS size_m---------------------- ------------------ -------------- ----------------- ----------1 1 1 current2 1 1 inact3 2 1

1. Insert Full LineFormat: INSERT INTO table (XXX_ID,Xxx_name,......xxx_address)Valus (' XXXxxx ',' XXXxxx ',......' xxxxxx ');Example:INSERT INTO Custnew

View current control file number and location, name[email protected] rac1>show parameter control_files;NAME TYPE VALUE--------------------------------------------  ------------  ----------------------------------------------------Control_files

The Oracle 11g Times Error "Ora-12541:tns: No Listener" is connected with PL/SQL developer, as shown in. Xiamen can be installed to resolve the steps.Open "Oracle Net configuration Assistance" from the Start menu, select "Listener Configuration", as

1. What tables are derived from the foreign keys in the view table in OracleSelect Cl.table_name from user_cons_columns Cl left joins user_constraints c on cl.constraint_name = C.r_ Constraint_name where c.constraint_type = ' R ' and

Package JDBC;Import java.sql.Connection;Import Java.sql.DriverManager;Import java.sql.SQLException;Import java.sql.PreparedStatement;Import Java.sql.ResultSet;public class Testoracle {public static void Main (string[] args) {1. Load DriverConnection

When we use with, Oracle may convert the results in with into a temporary table. This is only possible, as the CBO will infer.Inline is not converted to a temporary table. Materialize is forced into a temporary table.Manufacturing datadrop table

The primary role of SPM (SQL Plan Management) is to improve and stabilize system performance by managing SQL execution plans.Application: Database upgrade, uninterrupted system data change, new module development of business systemSystem

First, when we need to process SQL statements in XML format, we often use symbols such as ,>= and so on, but it is very easy to cause errors in XML format, which causes the background to convert the XML string to the XML document times error, which

Summary of rownum usage in ORACLE!For Oracle's rownum problem, a lot of data are said to not support >,>=,=,between...and, only with the above symbols (,& Gt;=,=,between. and will prompt SQL syntax error, but often do not find a record, but also

First,Operating System Installation, install Linux under VMware (OEL5.6) for the database server1. Open VMware and select "Create a new virtual machine"2. Select a Custom installation3. Select virtual machine hardware compatibility (default setting)

1, follow Oracle2, CREATE DATABASE footstepsDROP TABLE person; DROP SEQUENCE myseq ; //Set the self-increment sequence. CREATE SEQUENCE myseq; The CREATE TABLE person ( ID INT PRIMARY KEY is not null, name VARCHAR () is

Oracle 11g Installation1, modifying the Linuxshell parameterVi/etc/security/limits.confOracle Soft Nofile 65536Oracle Hard Nofile 65536Oracle Soft Nproc 16384Oracle Hard Nproc 16384modifying kernel parametersVi/etc/sysctl.confKernel.shmmax = 40464711