Oracle

First, export(1) Export dataGo to PL/SQL, "Tools"----> "Export Tables ...", then select the table to export in the popup dialog and click "Export"(2) Export table structureGo to PL/SQL, "Tools"----> "Export User Objects ...", then select the table

IamlaosongAfter the Oracle database server IP changes, the listening process fails to start and the corresponding configuration file needs to be modified:1, the server side $oracle_home/network/admin/listener.ora modify the address of the host can.

Execution of the UPDATE statement was found to be unsuccessful for half a dayUpdate Main_order Set order_source = ' 2 ', order_status = ' 2 'Query which objects are lockedSelect object_name , Machine , s.sid, s.serial#from

Plsql Developer or Toad do not install Oracle Client connection databaseTo simplify Oracle's use of personal computers, avoid consuming unnecessary resources, and you can not install Oracle clients. By using Oracle Instantclient to connect to the

How to modify user passwords in OracleIn the Oracle database, use ALTER user to modify the user password.GrammarALTER USER user_name identified by New_password;Parameter description:USER_NAME: The Oracle database user who wants to modify the

In Oracle development, the client sends SQL statements to the server, the server compiles and executes the SQL statements, and returns the results of the execution to the client.The Oracle SQL statement consists of the following commands: Data

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

About the resolution of the Ora 01219 problemBefore learning Oracle to practice to create a table space, built a lot of manually deleted, and then use the user name you created to log into the database will cause the databaseORA-01031:ORACLE

Start of Oracle database stoppedLog in as an Oracle user and enter the following command:oracle-> sqlplus/nologsql*plus:release 9.2.0.1.0-production on Monday April 26 09:42:00 2004Copyright (c) 1982, 2002>>, Oracle Corporation. All rights

Select Tp.technic_product_code,Tp.technic_product_name,Mp.marketproduct_code,Mp.marketproduct_nameFrom Marketproduct_info MP, Technic_product_info TPwhere Mp.id_technic_product_info = Tp.id_technic_product_info (+)1) + written on that table,

One, through the PLS block to call the stored procedure;DeclareP_dzno VARCHAR2 (50);P_vchtype VARCHAR2 (50);P_productclass VARCHAR2 (50);P_dptcode VARCHAR2 (50);Beginp_vchtype:= ' MP ';p_productclass:= ' 03 ';p_dptcode:= ' 206

To create a stored procedure:Syntax: Create [or replace] PROCEDURE procedure name (parameter list)AsPlsql Sub-program body;How to call stored procedures in two ways1. Execute (EXEC)------exec function name ()2. BeginFunction name ()End-------begin

When we operate with Oracle, we often delete a table, and when we delete the error, we want to be able to recover the table, and sometimes we want to free up the table space immediately after the table is deleted. The following describes the

Oracle Client Installation + PL/SQL Tools installation Configuration Download the Oracle client and install it locally. 11g is:Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html10g

Recommended Value for setting the ORACLE database server SWAP1. Role of swap Both system management and DBA know that there is a SWAP partition on both Linux and UNIX systems, which is similar to the virtual memory on Windows systems. When the

Roles of different OraclePatchset files In the Patchset of Oracle 10g version, only one file Disk1. the size of the Patchset in Oracle 11.2.0.2 and 11.2.0.3 is greatly increased. The Patchset of 11.2.0.2 and 11.2.0.3 is 5 GB. These 5 GB files are

Oracle Database for database Field Data TypeModify the Data Type of Oracle Data Columns Method 1: // Create the same temporary table Create table T_BUSINESS_MODEL_TEMP as select * from T_BUSINESS_MODEL where 1 = 2;// Change the data type of the

Use connect by prior in oracle to implement recursive query !, Oracleprior Note: This article to reference other people's articles, links: http://blog.csdn.net/apicescn/article/details/1510922, I recorded just to facilitate viewing Original article:

Oracle11gR2 + CentOS6.3 Database Installation1. install necessary OS installation packagesWe recommend that you install the operating system to the maximum extent, because the impact of current hardware on the maximum installation on the database

How does one determine whether the SQL statements are actually sorted in Oracle? In Oracle, sometimes when you see the sort keyword in the execution plan, some people think that the sorting is actually not necessarily. You can experiment with the