Oracle

configuration file ( Oracle ): BULK Insert temporary table -INSERT into Ce_tempphone_info (phone)(Select #{item,jdbctype=varchar} from dual)Insert intoce_tempphone_info (phone) (select XXX from dual union select yyy from dual ...);

Test preparation Analyze and experiment 1 Processing of fractional parts 2 maximum value that can be saved 3 minimum value that can be saved Summarize The Number data type for Oracle represents decimal

I. Sql_trace description1.1. In the global enable specified in the parameter file (pfile/spfile): Sql_trace =true 1.2. At the current session level, enable tracing for the current session: Alter session set Sql_trace =true; End Trace: Alter

Test environment: Win7 64-bit flagship +JDK7 (64-bit)Installed software: Oracle 11g R2 64-bitFollow the online general tutorial installation completed database, found a bunch of problems, close up this note.1, using SQL Developer login,

1. Log in to SYSDBA database2. Querying snapshots based on point-in-timeSELECT * from source$ as of TIMESTAMP to_timestamp (' 2014-02-24 05:10:32 ', ' yyyy-mm-dd HH24:MI:SS ') where source like '%CP _eas_costbreakdown_info% ';

Connecting to the Oracle Database helper class is to encapsulate the method that connects the Oracle database, just call it on the other page and do not need to repeat the write.Import Java.sql.connection;import Java.sql.drivermanager;import

1. Generate Test tables and data:CREATE TABLE MyTest(ID int PRIMARY KEY,NodeName varchar (20),PID int);Insert into mytest (id,nodename,pid) VALUES (1, ' A ', 0);Insert into mytest (id,nodename,pid) VALUES (2, ' B ', 1);Insert into mytest

Tricks One:1. View the locked table:2. Select P.spid,c.object_name,b.session_id,b.oracle_username,b.os_user_name from V$process p,v$session A, V $locked _object b,all_objects C where p.addr=a.paddr and A.process=b.process and c.object_id=b.object_id3

When the query to the results of complex processing, you can use the union query, sub-query, etc. to get the desired results. The following is a specific classic question, hoping to inspire readers.1. Title Requirements:Table NBA records the

Oracle study's--nls_date_formatSystem environment:Operating system: RedHat EL6Database: Oracle 11gR2When setting the time format in Rman, error:650) this.width=650; "Src=" http://img.blog.csdn.net/20150513193624565?watermark/2/text/

Original PowerDesigner to reverse engineer OracleObjectivePowerDesigner 15 Reverse engineering of the OracleClient 11gEnvironmentWIN7 64-bit systemOracle 11gOracleClient 11g ODACPowerDesigner 15Steps1,fileàreverse Engineeràdatabase2,dbms, select

(1). Table space and the concept of partitioned tablesTable Space:is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition table:When the amount of

Use the cmd Operation command to export, the details are as follows:The 1:g:\oracle\product\10.1.0\client_1\network\admin directory has a Tnsname.ora file with the following contents:Cmstar =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP)

Static registration and Dynamic Registration summaryFirst, what is registration?Registering is registering the database as a service to the listener. The client does not need to know the database name and the instance name, but only needs to know

1. Assuming that the field data is empty, you can do it directly, regardless of the field type you are changing to:ALTER TABLE TB Modify (name Nvarchar2 (20));2, if the field has data, then to NVARCHAR2 (20) can be directly executed:ALTER TABLE TB

 1. Log in to the database with the SYS accountSQL Plus Enter the command below: Conn SYS as DBA; Enter the password after the return.Tip: The connection succeeds with the second step.2. Modify the port number bitSQL Plus Enter the command below:

、、、、、、、、、、、、、、、、 create tablespace \ Assign role \ create data table \ Insert data \ Create sequence \ Add Comment 、、、、、、、、、、、、、、、、、、、、、、、、、、、--Create TABLE spaceCreate Tablespace New_tabspaceDataFile ' E:\File_Orc\File\A.DBF 'Size 100mCreate

--http://blog.csdn.net/gdjlc/article/details/23762549Oracle Modify field type method SummaryCategory: Oracle2014-04-15 15:24 15007 People read Comments (2) favorite reports There is a table named TB, field segment named Name, data type nchar (20)

ORACLE records the IP address of the connected user and the IP address of the Login Failed User The main function is to record the IP addresses of logon users and the IP addresses of Logon failures in oracle.1. You need to create a trigger to record

Oracle job creation example-- 1. Learning jobs in plsql-- Learning job-- Create a tableCreate table test_job (para_date date );Commit; Insert into test_job values (sysdate );Commit; Select * from test_job; -- Establish the storage processCreate or