Oracle

The first part of Oracle Learning1.oracle Introduction1.1 Common database classification at presentSmall database: SQL Server,access (Microsoft)Medium database: MySQL (Swedish company), Sybase (US Sybase)Large database: Informix (IBM), Oracle

Sys_guid ()-Unique indexIn Oracle, you can use Sys_guid () to generate a GUID that is equivalent to NEWID () in MSSQL.The resulting data in oracle9i and Oracle 10g is 32 bits, such as: 234E45F0077881AAE0430AA3034681AAHowever, the GUID in Oracle is

DECLAREV_sqlVARCHAR2( +); V_sql_headVARCHAR2( -); V_sql_tailVARCHAR2(Ten); V_dayVARCHAR2(8); CURSORC_cur is SELECTTo_char ((To_date ('2012-01','yyyy-mm')+(ROWNUM- 1)), 'YYYYMMDD') S_date fromDUAL CONNECT byROWNUMLast_day (To_date ('2012-12','yyyy-mm'

Install with previous version of the database, the installation directory selection is the same as before. Turn off all services from Oracle. Copy the database folder from the original Oracle_home directory to the current directory (it is a

First you have to have a PL/SQL, in fact, there is no line, but this database still has a visual interface for good AH.1. First, log on PL/SQL as the SYS user2. To find out the ID of the table you want to change, take my local data for example, I

The method to do the map match1 the algorithm proceduresFirst, we should find the most nearest road to the point from all roads in haerbin;Second, we should find the most nearest point-to-the-point from the road.For example, as Figure 1, we'll do

Here, we will use the Dbms_random package and case when statement, the idea is as follows:First, the use of dbms_random. The random function randomly generates values and then models the values, and if we want to read them randomly in 10 elements,

CREATE OR REPLACE FUNCTION idfms.func_dec236 (parm in INT DEFAULT 0)RETURN VARCHAR2Is/*10 binary number to 36 binary number*/SRC VARCHAR2 (+): = ' 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ '; --Change to another string, which is any binaryLEN INT;Res

Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import the DMP file from a local to a distant database

Oracle divides a column into multiple columnsIn Oracle, we can use Listagg (Oracle 11g and above) to merge one column of multiple rows into one column, and now our requirement is to split one column into multiple columns.First create a table and

Open and close under Oracle Linux1, start Oracle monitoring first to login user Oracle:su-oracleoracle@localhostbin]$ Lsnrctl--Start the Oracle Listener commandLsnrctl forLinux:version10.2.0.1.0 -Production on in-OCT- . +: $: GenevaCopyright (c)199

Sqlplus Login Oracle Server query table display Chinese is garbledSql> select * from test11;Id----------NAME--------------------------------------------------------------------------------111??222??333??????Sql> Select Userenv (' language ') from

Recently do the DRP project, can be the Oracle toss miserably, the first time installation of rough doomed after the temper, now I put these blood and tears of history are organized here, hoping to help you in Oracle's connection less detours, less

Today, the Oracle client is installed in the CentOS6.4 operating system, centos6.4oracle After the installation was complete, the environment variable settings had been exhausted for a long time. Later, I knew that I had to restart the environment

Oracle time format and integer format conversion If the time field of the Oracle database is set to the "NUMBER" type, the query Time column is displayed as a numerical value, such as the "1241450728000" style, which is not readable; if the update

Basic knowledge about oracle Database 2 Oracle beginners series II Basic Database knowledge This article combs basic database knowledge that has been forgotten, and may not be remembered at all. In either case, remember it. If you cannot remember it,

Summary of basic Oracle functions and object examples -- ## Character function, case-sensitive processing function select lower ('abcde') FROM dual; -- ABcDe, all converted to LOWER case select upper ('abcde') FROM dual; -- abcde, convert all to

Oracle divides a column into multiple columnsOracle divides a column into multiple columns In Oracle, we can use listparts (Oracle 11g and above) to merge multiple rows into one column. Now we need to split one column into multiple columns. Create a

In one of the RAC decomposition steps, install the oracle 10.2.0.1.0 operation log on oracle linux 4u4, 4u410. 2.0.1.0 Exercise the oracle rac formation process. Step 1: First practice installing oracle 10.2.0.1.0 on 4u4. It is difficult to directly

Oracle Random Number Generation Method Dbms_random is a package that can generate random values or strings.   Dbms_random.value Method   1. Decimal (0 ~ 1)   Select dbms_random.value from dual; 2. decimal places in the specified range (0 ~ 10