Oracle

First, Oracle common related SQL statements1. Connect to the databaseSu-oracle-c "Sqlsplus User/Password Note: First time login with Sqlplus/as SYSDBANote: Close the database: Note: Shutdown can be turned off option, from the mildest to the most

Reason and method of Oracle user being lockedBe told that the test user is locked when logging in1, with the DBA role of the user login, unlock, first set the specific time format, in order to see the specific timeSql> alter session set

The following article reproduces the blog: Http://blog.csdn.net/bluishglc speaks deeply and thoroughly, turns to share under: basic idea and segmentation strategy of database shardinghttp://blog.csdn.net/bluishglc/article/details/6161475on the grain

Oracle can only be natively connected and not connected to other computers on the networkOracle listens only to local 127.0.0.1, causing the network other computers to not connect to the workaround:Modify the Listener.ora listening file to change

1, reduce the burden of the network: through the MV data from a database distributed to a number of different databases, through multiple database access to alleviate the network burden on a single database. 2, build distribution environment: By

In Oracle, there are three kinds of equals: <>,!=,^=For example:SELECT * FROM test where name<> ' xn '. The returned result is a record where name is not xn and name is not empty. But this is not the same as what we want to get, because our goal is

What is the cause of the large amount of empty data that sometimes occurs when you use the left association?This is because the field in the primary table is empty until the primary table is associated with another table, and then the field

1 , in the installation Oracle before installing the following component packages first, enter the following statements directly. Yum Install binutils*-yYum Install compat-lib*-yYum Install gcc*-yYum Install glibc*-yYum Install ksh*-yYum Install

I. Modifying and maintaining Table spaces1. Increase table Space capacityYou can increase the capacity of the tablespace by modifying the size of the tablespace data file or by adding a data file to the tablespace, and we can also use the

Online Baidu to appear this phenomenon reason, said seems to be quite reasonable, so copy come over:when you debug a procedure, function, or package, the company's firewall kills the session connection if there is no action for a long time. This

This function is in its own misoperation, will some data changes wrong, you want to restore the data before the change wrong, this time you can use this method but it is recommended to carefully change the data, if it is necessary to update, please

Oracle View character set and modify character set:To view the character set of the database server:Select userenv ('language' from dual;Login with DBA:To stop the database:ShutdownTo start the database into the Mount state:STARTUP MOUNT;ALTER SET

about Oracle with as usage– For an aliasWith TMP as (SELECT * from Tb_name)– For multiple aliasesWithTMP as (SELECT * from Tb_name),TMP2 as (SELECT * from Tb_name2),Tmp3 as (SELECT * from Tb_name3),... 1 2 3 4 5 6 7 8 9

Preface: Learning Oracle Recently, so follow this classic book "Oracle Database 9i/10g/11g Programming Art" to learn.Configuring the Environment How to set up Scott/tiger demo mode correctly Environments that need to be built and run How

This week is working overtime, Flash again Thursday, every day overtime time to go fast. The company bought 3 23-inch display, Dell's, can be arbitrarily rotated. First gave me this project group use, do not know calculate a kind of reward ... It's

Unconsciously also 10 days, weekends and overtime, I would like to take a half-day Monday morning to see the final NBA Finals ... Later, after all, is not a hardcore fan, back in the evening to repair the video to see the collection good.Company A

1.oracle Open File handle numberSql> Select COUNT (*) from V$open_cursor;COUNT (*)----------15652.number of connections to OracleSql> Select COUNT (*) from v$session;COUNT (*)----------863. Current number of processes Sql> Select COUNT (*) from

Oracle text and format string mismatch resolutionDate-Time type for OracleRemember to use the To_date () method when inserting data into the date type of Oracle.such as insert into Cuslogs (STARTTIME) VALUES (to_date (' 2009-5-21 18:55:49 ', '

CREATE OR REPLACE FUNCTIONFind_in_set (PIV_STR1varchar2, PIV_STR2varchar2, P_sepvarchar2:= ',') RETURN Number isL_idx Number:=0;--used to calculate the position of separators in PIV_STR2 Str varchar2( -);--substring intercepted by

1. Standard SQL specification1 One, single if2 1,3 4 ifA=... Then5 .........6 End if;7 8 2,9 Ten ifA=... Then One ...... A Else - .... - End if; the - two or more if - - ifA=.. Then + ...... -Elsif A=.. Then + .... A End if; atThe middle here is "