Oracle

Upload the Oracle installation file to the Linux server first1. Unzip the zipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip2. Create the installation directoryMkdir/opt/oracle3. Create a user group:Groupadd

DescriptionOracle Database account Number: SticOracle Database Password: sticOracle DB instance: ORCLOracle database table: UserInfoColumns for Oracle tables: Id,nameThe code that does not handle the exception is as follows:Create a database

There is no self-increment field in Oracle, which can be implemented indirectly via sequence + trigger, Sqlplus login in cmd and run directly. It usually takes a few steps:1 Creating a data sheetCreateTable test_increase (             userid number (

How do I create a tablespace in Oracle? There are two main ways: one is to use SQL commands, and the other is created by the Oracle Client Enterprise Manager console. Here are a few separate sections:1 Create a tablespace from SQL command1.1

Mybatis Jdbctype Oracle MYSQL Jdbctype ARRAY Jdbctype BIGINT BIGINT Jdbctype BINARY Jdbctype BIT BIT

SELECT A.areaname AS Level two place name from houses h,houses H2,Areas a WHERE H.areaid=a.areasid and H2.areaid=a.areasid and H.finalassessmentid=1 andH.houseslevel=2 and H2.houseslevel=1 and A.areasid!=a.parentareasid and a.companysid=2;SELECT *

One: Start Oracle[Email protected] ~]# su-l Oracle[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.4.0-production on Mon June 13 14:11:16 2016Copyright (c) 1982, Oracle. All rights Reserved.Sql> Conn/as SYSDBA Connected to an idle instance.

Http://www.cnblogs.com/chen1388/archive/2010/07/06/1771919.htmlDecode function:Decode (AA, 1, ' XS ', 2, ' ps ', ' MS ')Equivalent(Case AA If 1 then ' XS 'When 2 Then ' PS 'Else ' Ms

1. Query the sname, Ssex, and class columns of all records in the student table.2, the inquiry teacher all units namely does not duplicate depart column.3. Query all records of student table4. Query all records from 60 to 80 of the scores in the

1, GROUP by ROLLUP (A, B): can achieve a simple statistical report, the equivalent of group by a, B, then group by a, then GROUP by *2, Break on a SKIP 2: With the group by rollup, the break on a means that the same a only display 1 times, SKIP 2

1. Attention PointsIn the process of querying, not determining the amount of data in the database table, first querying the data volume, the data volume is large, you can not directly query (SELECT * from EMP), if the data volume is large, direct

1, randomly fetching records from the tableSelect * from(Select * fromStaffOrder bydbms_random.random)whereRowNum 4To randomly fetch 3 records from the staff table2, generating random numbersSELECTDbms_random. RANDOM fromDUAL; produce a random

And the advantage of the essay is that you can force yourself to learn, what you did not want to learn today, or how much to learnIn the afternoon by a bug, just the two days of interns have been on leave, had to self (but today this matter interns

Main content: User and table space; tables and constraints; Query statements.I. OverviewOracle Installation: Visit the website, downloadSecond, the User and table spaceYou can log in to Oracle with SQL Puls in the Start menu when you install Oracle.1

I. Related content1. Verify system Rights Management.2. Verify role management.3. Verify profile Management.Second, the specific operationA1. Grant and recycle the system permissions according to the following requirements:(1) Create a user User1

1. Numerical functions　　Round (N[,m])　　　Rounded, M is 0 directly rounded n,m>0 take the decimal point after the M bit, m　Ceil (N)Take a minimum integer value greater than n　　Floor (N)Take the maximum integer value less than n　　ABS (N)Take the

Today's study of Oracle encountered this problem ora-01033:oracle initialization or shutdown in progress, after the analysis of the study finally solved, write down a memorial. My library is Oracle 9i, specifically 90.First of all: the cause of the

In a paged query, you need to use pseudo-column rownum, the code is as follows:SELECT * FROM (select RowNum RN, name from cost where rownum 3;But the first time with RowNum, the second use RN, position can not change, otherwise error, the first time

Suppose there are two tables, a, B, there is only one field phone1,minusSelect Phone from A minus select phone from B; Equivalent to the result set minus result B by result set a. The same effect can be achieved with the select PHONE from A where is

1. Differences between temporal and tablespace spacesTablespace: This space is used for data storage (tables, function, stored procedures, etc.), so is the actual physical storage area.Temporal tablespace: The primary purpose is to sort operations