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

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'

The parameter Parallel_max is the Oracle's largest open parallel service process, the concurrent sum of all sessions.Sql> Show Parameter Parallel_max_serversNAME TYPE VALUE------------------------------------ ----------- -----------------------------

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

--oracle Database Creation Table spaceCreate Tablespace New_taspace--Table space nameDataFile ' D:\NEWTABLESPACE. DBF ' -the data file and location associated with the tablespaceSize 200M --File Initial sizeAutoextend on next 20MB MAXSIZE 400MB;

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

--Initialize datadrop table test Purge;CREATE TABLE Test as SELECT * from Dba_objects;Delete from test where object_id is null;ALTER TABLE TEST ADD constraint pk_test_object_id primary key (OBJECT_ID);CREATE INDEX ind_t_object_name on test

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,

As the following table table1:Number of dates (exportdate) (amount)--------------                    -----------1 April-February-08 20October-March-08 21 April-April-08 61 April-June-08 752 April-October-09 231 April-November-09 45April-August-10

1. Open cmd window, enter Sqlplus/as SYSDBA2, run CMD, enter the ALTER user username account unlock;3. Alter user name (System) identified by new password (m1234); Change Password (note: Be sure to enter the letter in the English input state,

Solution to ORA-12560: TNS: protocol adapter errorsThere are three reasons for the problem that caused the ORA-12560: TNS: protocol adapter error:1. The listening service is not started. On the windows platform, perform the following operations:

Oraclesys_context () function The first parameter is 'userenv', which is fixed. The second parameter is also fixed, but multiple options are fixed. The optional values are as follows:   Select sys_context ('userenv', 'authentication _ type') from

Guarantee of successful installation of oracle11gEnvironment: LSB Version: core-4.0-amd64: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-noarch:Distributor ID: RedHatEnterpriseServerDescription: Red Hat

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

Modify the ORACLE field order First, you need to have a pl/SQL statement, but there is still a visual interface for this database. 1. First, log on to PL/SQL as a sys user2. query the ID of the table you want to change. Take my local data as an

Oracle11g installation problem summary Test environment: win7 64-bit flagship edition + jdk7 (64-bit) Installed Software: oracle 11g R2 64-bit After the database is installed according to the general online tutorial, a bunch of problems are found.

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,

Modify tables, add columns, delete columns, and modify columns in oracle1. Add ColumnsAlter table table_name ADD (column datatype [default expr] [, column datatype...]);For example:SQL> ALTER TABLE emp01 ADD eno NUMBER (4 ); 2. Modify column

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