Oracle

Sometimes the data is dead, or no listening, do not have to restart the machine, restart the database service line, the following is the Linux boot step, did not execute under win, may also be!Taking Oracle9i as an example(1) Log in to the database

One, duplicate table structure and dataCreate Table as Select * from V_topic v where > to_date ('2016-01-01 00:00:00','yyyy-mm-dd hh24: Mi:ss');Second, duplicate table structureCreate Table as Select * from V_topic v where 1

Oracle Advanced Queries1 set operationUnion combining two tables to form a single tableIntersect the intersection of the same leave, not the same don'tMinus minus the previous result minus the result of the followingCREATE TABLE Emp3 as SELECT *

Query method: Like '%xx% 'Normal: SELECT * from TABLE T WHERE t.colunm like '%xx% 'Optimization: Using INSTRSELECT * from TABLE T WHERE INSTR (t.colunm, XX) >0At the time of execution, the execution plan shows that the consumption value, IO value,

Recently encountered a server using the Oracle database, in the Mad learning oracle+ to consult a master after finally got the site management interface of all user passwords, I found that Oracle operation is too troublesome, for the sake of the

Today help others solve the problem, about Oracle, suddenly feel that should be a note, friends can see. Here is the detailed configuration:1. First locate the attached configuration net Manager at installation time in Oracle, open it, and configure

First of all, the installation of Orcale should be very simple, installation is not good only familiar with some of the problems encountered in the record, if later forget can also look.The first biggest problem is installing the client when

--oracle querying the current versionSELECT * from V$version;----------Oracle Query server-side encoding----------SELECT * from v$nls_parameters where parameter= ' nls_characterset ';----------Three ways Oracle queries the current

Open Database Configuration Assistant Next Select "Advanced Mode" next Choose the type of database you are creating (typically select Data Warehouse)(general purpose or transaction processing?:?thatOLTP(online transaction processing). The

The beginning of the study, I am a bit stupid, originally wanted to use Oracle VBox, installed a red hat+oracle, but the virtual machine has been error, 0x00000000 memory can not written. So think of other ways, just contact Golang, and then know

What is a view? ）1. A view is a database object, a virtual table that is exported from one or more data tables or views, and the data corresponding to the view is not really stored in the view, but is stored in the referenced data table, and the

GROUP BY group--Number of jobs per job from the EMP group by job;--How much work select COUNT (coutn) from the EMP group by job;--the maximum wage for each job select M Ax (SAL) from EMP Group by job;--minimum wage per work Select min (sal) from EMP

Stored procedure (stored procedure): can be regarded as the name of the PL/SQL program block, by name call execution; can take parameters or without parameters.Trigger (Trigger): Event-triggered execution, which can be considered a special type of

--Look up the name and size of the table spaceSELECT T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) ts_size from Dba_tablespaces T, dba_data_files D WHERE t.ta Blespace_name = D.tablespace_name GROUP by t.tablespace_name;--Find the physical

Two methods:Method one, by backing up the table1. Create a backup tableCREATE TABLE T_bak as SELECT * FROM t2. Change the corresponding column data type after deleting the original table dataDelete from T3. Import the data from the backup table into

1. Installing Plsql2. Download Oracle instance client, because my Plsql version is 12.1, only download 64-bit version, the old version will use 32-bit3. In the Oracle instance client build Network\admin folder, configureORCL =(DESCRIPTION

First, Dbms_jobs1, check the running job;SELECT * from User_scheduler_running_jobs2, according to Sid isolated the corresponding session;Select sid,serial# from v$session where sid= ' session_id ';3, kill the corresponding session;Alter system kill

The specific installation tutorial will not write, there are many online.After the grid and Oracle are installed, the delay time of the building is several hours, permissions, monitoring what is done, is not found the problem, and then the use of

In Java, change the time of the string type to the date type and then perform the operation:Date time1 = new SimpleDateFormat ("Yyyy-mm-dd HH:mm:ss"). Parse (Intime);Time2.gettime () converts to a long type of this time, which realizes the judgment

Calling external C dynamic library functions in OracleIn order to shorten the development time, the project must call the C program that has been developed externally in Oracle.I found some posts on the Internet and summarized the article based on