Oracle

Asp.net%e5%bf%ab%e6%8d%b7%e9%94%ae%e5%a4%a7%e5%85%a8http://list.mp3.baidu.com/songlist/502651206http://list.mp3.baidu.com/songlist/502360424http://index.ttplayer.com/songlist/502586400http://list.mp3.baidu.com/songlist/502213105http://index.ttplayer.

1. The super Administrator is logged in Oracle:sqlplus/as sysdba  2. Displays the current connected user sql> show User3. Create a new user and authorize sql> to create a user a identified by A; Built under system table space) Pl/sql> grant

Create or Replace package Tx_pkg_pagepackage are type tx_resultlist is REF CURSOR; Procedure Tx_prc_pagination (tx_resultlist out Tx_resultlist,insql in Varchar2,currentpage in Number,pagecount in number ); End;create or Replace package body

Original: http://www.cnblogs.com/lambertwe/p/6116402.htmlToday in the project query process related information, found in the date of the word Gencun information is very strange, is a string of values, later found to be a long type or integer type

Deadlock:Session1:Sql> select * from T1;X----------12sql> Update T1 set x=11 where x=1;Session2:sql> Update T1 set x=22 where x=2;Session1:sql> Update T1 set x=222 where x=2; BlockingSession2:sql> Update T1 set x=111 where x=1; Dead lockERROR at

---Statistical invalidation index select SUM (A.AA) from (Select COUNT (*) AA from dba_indexes where status= ' unusable 'UNION ALLSelect COUNT (*) AA from dba_ind_partitions where status= ' unusable 'UNION ALLSelect COUNT (*) AA from

Pro-Test availableIn Oracle database operations, we sometimes use lock table queries and operations such as unlocking and kill processes, so how are these operations implemented? In this paper, we mainly introduce this part of the content.(1) The

1. View /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.oraCat/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora#

Collection operationsDesc job_history: Changing the position of historyJob_history: History tableVnion: Duplicate values retain only one remove duplicate value ★Vnion all: Retain all duplicate values without removing duplicate values ★Intersect:

Oracle Table complex Query aggregation functionMax (field value)--max valueMin (field value)--Minimum valuesum (field value)--Seek sumAVG (field value)--averagingCount (field value)--Number of numbersGROUP BY and HAVING clauseGROUP BY: used to group

1. Character classesLpad(STR1,LENGTH,STR2)The Lpad function fills the string with the specified character from the left. From its literal meaning can also be understood, L is the left shorthand, pad is the meaning of padding, so the lpad is the

Oracle tablespace Meaning: A tablespace is a logical division of a database, and a table space can belong to only one database. All database objects are stored in the specified table space. But the main storage is the table, so called table

Oracle:Begin${sql}EndNote: There must be a begin end;Ora-00933:sql command did not end correctly; Bad SQL Grammar []; Nested exception is Java.sql.sqlsyntaxerrorexception:ora-00933:sql command did not end correctlyMysql:${sql}Can not add when

I. Software PreparationAddress: Oracle websiteinstallation package: Because of personal learning, it is possible to install the server side. No client required.A total of two compressed files, extracted together into a directory. I use:

--query for positions that are not duplicatedSelect distinctJob fromEMP;--Search for annual salary, alias, alias not enclosed in single quotation marks.SelectSal* A asNianxin fromEMP Sal;--the specific data is displayed in this form: The employee

The common case is that a table with a primary key can be a unique form of knowledge. We are able to use the primary key and rownum mates to implement. Like what:select scott.emp.* from scott.emp left join (select empno id, rownum num from

Relevant concepts understand:Table: A basic collection of data stores, consisting of columns and rowsViews: Extracting logically related data collections from a tableSequence: Provides a regular number of valuesIndex: Make index query more

Javaweb projects are slightly different from plain Java projects when connecting to an Oracle database.Normal Java project will ojdbc.jar build path directly;The Javaweb project may not work and needs to be set up again:Right-click on the project

NVL () function in OracleHow Oracle's NVL function is usedThe total value of a field is obtained by querying, assuming that the value bit null will give a preset default valueSelect NVL (SUM (T.DWXHL), 1) from Tb_jhde t where zydm=-1Here the Nvl

1. Create userCreate user KD identified by 123456;2. Grant permission to connect to the databaseGrant connect to KD;3, the Scott User's EMP table is authorized to KD can be queriedGrant SELECT on Scott.emp to KD;Grant CREATE table to KD;4. Reclaim