Oracle

This explains my understanding of the Oracle Network (static listening):650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/57/wKioL1e8W1XhBxylAABNjdsDQZs648.png "title=" Qq20160823221132.png "alt=" Wkiol1e8w1xhbxylaabnjdsdqzs648.png

Database Stop (four modes)1. Normal shutdown: shutdown normal = shutdownNormal user connections are not allowed to establishWait for query to endWait for transaction to endGenerate checkpoints (data synchronization)Close online logs and data

Create a database manually (Madrid)Export Oracle_sid=madrid1. Create a password fileOrapwd file= $ORACLE _home/dbs/orapw$oracle_sid password=oracle2. Create a parameter fileVI $ORACLE _home/dbs/initmadrid.ora------------------------------------------

Oracle's analytic functions are powerful, and work is often used over the years. This time, the usual analysis functions are sorted out for later viewing.We learn by taking cases, so it's easier to understand them.1. Build a tableCREATE table

Check whether a table is locked in--oracle to see if the table is lockedSELECT/*+ rule*/A.sid, B.owner, object_name, object_typeFrom V$lock A, all_objects bWHERE TYPE = ' TM 'and a.id1 = b.object_id;--so you can kill it.SELECT sid,serial# from

SUBSTR (string, intercept start position, intercept length)//return intercepted wordsubstr (' Hello World ', 0, 1)//return result is ' H ' * start with a string of length 1 from the first charactersubstr (' Hello World ', 1, 1)//Returns the result

--substr (string, intercept start position, intercept length) = return the intercepted wordSelectSubstr'miaoying',0,1) fromDual--The returned result is: MSelectSubstr'miaoying',1,1) fromDual--The returned result is: m--description 0 and 1 both

VARCHAR2 The maximum is 4000 bytes, then look at your Oracle Character set: (select Userenv (' language ') from dual;)If the character set is 16-bit encoded, ZHS16GBK, then each character 16 bits, 2 bytes, so can accommodate 2000 characters.In the

Triggers do not require a commitI can't write a commit.The trigger and the DML that triggered it are the same transactionDML commits, the action of the trigger is also submitted, or it is rolled back together.Of course, if you must write a commit in

One, Oracle six ways to connectIn ①myeclipseOpen Myeclipse,window----Show view----Other---Input DB click DB BrowserSelect Right-click New. The following page appears to fill in the relevant information:The Ojdbc6.jar package needs to be introduced

CRS Resource in Oracle 10g includes GSD (Global serveice Daemon), ONS (Oracle Notification Service), VIP, Database, Instance and serviceWhen you start the CRS in the 11GR2, you will be prompted that OHASD has been started. So what resources does

Data Objects in Oracle have tables, views, indexes, sequences, and so onRelated Operations for tables1. Create a tableWay one: Way two:CREATE TABLE person (

http://blog.csdn.net/zhoufoxcn/article/details/1762351In Oracle, sequence is the serial number, which automatically increases each time it is taken. Sequence is not related to tables.1. Create SequenceFirst, create sequence or create any sequence

Original: http://www.jb51.net/article/37633.htmNumber (precision, scale)A) precision represents a valid bit in the number, and if no precision is specified, Oracle uses 38 as the precision.b) If scale is greater than 0, indicates the number of

Create a new control file based on an existing database#数据库必须是mounted或open状态sql> ALTER DATABASE backup Controlfile to trace;You can use the following shortcut to find the corresponding trace filesql> ALTER DATABASE backup Controlfile to trace;sql>

[SQL]EXP-00091: The problematic statistics are being exported. Www.2cto.com. . Exporting table Wf_general Export EXP-00091: Problem statistics are being exported ... . Exporting table Wf_plan_book Export EXP-00091: Problem statistics are being

Getting Started with Oracle 11g installationModify Shell LimitsVi/etc/security/limits.conf---------------------------------------------Oracle Soft Nofile 65536Oracle Hard Nofile 65536Oracle Soft Nproc 16384Oracle Hard Nproc 16384modifying kernel

In a recent project, because of the large amount of data in the interface query, the associated table is more, some of the data to be temporarily saved for use in subsequent queries, so think of using Oracle's temporary table to achieve this

One of the Oracle transactions: Lock and QuarantineI. Overview of transactionsTransaction management is the core of database processing. The database must ensure that the user can execute the transaction concurrently and ensure the consistency of

Problem:Recently in making use of Geotools to import SHP files into an Oracle table, a problem was found when an Oracle table name was underlined when the import failed, the question code line: Dsoracle.getfeaturewriterappend