Oracle

If we access the database through JDBC, then it is necessary to take different SQL paging statements according to the database type, for MySQL database, we can use the limit statement for paging, for the Oracle database, we can use rownum way of

1 Toss for a long time, see other people's not full, or not clearGo to Qt ' s Command Prompt window. (VS 2010)Set include=%include%; This inside your Oracle's path, not fixed d:/work/oracle_10.2_client/oci/includeSet lib=%lib%; This inside your

Time difference calculation:Two date Type fields: Start_date,end_date, which calculates the time difference between these two dates (in days, hours, minutes, seconds, milliseconds, respectively):Days:ROUND (To_number

Partition Table PurposePartition table by the judge of the partition column, the partition column of different records, put into different partitions. Partitions are completely transparent to the application. Oracle's partitioned tables can include

Since I was debugging a project shortly before, the ID of one piece of data is the same as the ID of another data, but I do not know why there is no error, when the page found a problem, delete this data when the error, Oralce record is locked by

Use of the Oracle trunc () function1.TRUNC (for dates)The date value that the Trunc function truncates for the specified element.Its specific syntax format is as follows:TRUNC (Date[,fmt])whichDate a datetime valueFMT date format, which is truncated

1. Column Conversion 1: Each letter turns into a lineSELECT SUBSTR (A.column1, LEV, 1) COLUMN1From (SELECT ' AABDC ' COLUMN1 from DUALA(SELECT level LEV from DUAL CONNECT by levelWHERE LEV 2. Through the "," through the column careerSELECT COLUMN1,

Data Description:Select * fromDave;ID NAME 8Anqing1Dave2BL1BL2Dave3DBA4sf-Express5DmmSelect * from B1;ID NAME 1 Dave2 bl3 Big Bird4 exc 9 Huaining1. INNER JOIN (join)Join defaults to INNER join.The following 3 ways of writing the

Previously wrote a JSP+SERVLET+JAVABEAN+MYSQL implementation page multi-conditional fuzzy query using MySQL paging query, MySQL with limit control, and Oracle is using RowNum, today, the first time to write Oracle, Checked the data, tried it, put

This article describes the command mode (Administrator rights):1. Open the command Console with administrator privileges and enter the following command:Sqlplus sys/Administrator account name (that is, DBA account) as SYSDBA; (Remember the semicolon

There are two methods: SCN and time stamp two methods of recovery.I. Recovering deleted and committed data through the SCN1. Obtain the SCN number of the current databaseSelect Current_scn from V$database; (Switch to SYS user or System user

Here's a code to create a function that splits a string into paragraphs by a comma ', 'Create or Replace function Splitstringbycomma (aName in varchar2) return Myarraytype isResult Myarraytype;Len number;I integer;J Integer;P integer;Comma varchar2 (

RowNum principle:1 Oracle executes your query.Perform a query operation2 Oracle fetches the first row and calls it row number 1.Place row num on the first row at 13 have we gotten past row number meets the criteria? If no, then Oracle discards the

Oracle views and modifies the maximum number of connectionsFirst step, on the cmd command line, enter SqlplusStep two, follow the prompts to enter the user name and password1. View processes and Sessions parametersSql> Show parameter processesNAME

#!/bin/SH# Chkconfig: * the Ten# description:oracle Auto Start-Stop script.## Set ora_home to being equivalent to the $ORACLE _home# fromwhichYou wish to execute Dbstart and dbshut;## Set Ora_owner to the userIDOf the owner of the# Oracle

User management:1. Create a user (to log on with DBA authority to create a Sys/system login)Create user username identified by password (password starts with a letter);2. Change the password to the user1>alter user username identified by new

[Date: 2011-08-05]Source: Linux Community wangshengfeng1986211[Font: Big Small]2010-07-01 15:031. SET AUTOTRACE on EXPLAIN(Set AUTOT on exp)The Sqlplus command, which displays the execution plan while executing the SQL statement, sets exp (lain) to

About Super Admin login does not require a password because:Three types of authentication mechanisms for databases:Operating system validation (for users with SYSDBA and Sysopera)Password file validation (for users with SYSDBA and Sysopera)Database

1. Case-When expressions have two forms--Simple Case functionCase SexWhen‘1‘Then‘Man‘When‘2‘Then‘Woman‘ELSE‘Other‘END--Case Search functioncase when sex = Span style= "color: #ff0000;" > ' 2 then ' female else ' other "end 2.

SELECT * FROM teacher--female teacher number, nameSelect Tno,tname,gendar from teacher where gendar= ' woman '--Han's female teacher number, name, ID numberSelect Tno,tname,tid from teacher where gendar= ' women ' and tname like ' Korean '--Salary