oracleн¨Óû§£¬ÊÚȨ£¬½¨±í¿Õ¼äÓï¾ä

oracle´´½¨±í¿Õ¼ä£¬´´½¨Óû§(ת)
¹Ø¼ü×Ö: oracle ±í¿Õ¼ä Óû§
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//´´½¨Êý¾Ý±í¿Õ¼ä
create tablespace test_data
logging
datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user username identified by password
default tablespace test_data
temporary tablespace test_temp;
//¸øÓû§ÊÚÓèȨÏÞ
grant connect,resource to username;
//ÒÔºóÒÔ¸ÃÓû§µÇ¼£¬´´½¨µÄÈκÎÊý¾Ý¿â¶ÔÏó¶¼ÊôÓÚtest_temp ºÍtest_data±í¿Õ¼ä£¬Õâ¾Í²»ÓÃÔÚÿ´´½¨Ò»¸ö¶ÔÏó¸øÆäÖ¸¶¨±í¿Õ¼äÁË¡£
-----------------------------------------------
´´½¨±í£º
ÓÃÕâ¸öн¨Óû§µÇ¼oracle£¬´´½¨±í£º
Óû§±í ITS_USER
×Ö¶ÎÃèÊö
×Ö¶ÎÃû
ÀàÐÍ
Ö÷¼ü
²»Îª¿Õ
±¸×¢
Óû§´úÂë
USERXH
VARCHAR2(32)
TRUE
TRUE
 
Óû§ÐÕÃû
USERNAME
VARCHAR2(16)
FALSE
TRUE
ÐÕÃû
Óû§ÃÜÂë
PASSWORD
VARCHAR2(32)
FALSE
FALSE
Óû§ÃÜÂë
ÁªÏµµç»°
TELEPHONE
VARCHAR2(30)
FALSE
FALSE
ÁªÏµµç»°
¹ÜÀí²¿ÃÅ
GLBM
VARCHAR2(10)
FALSE
TRUE
¹ÜÀí²¿ÃÅ£¬its_departmnet.glbm
Óû§µÈ¼¶
YHDJ
VARCHAR2(2)
FALSE
TRUE
 
Óû§½ÇÉ«
YHJS
VARCHAR2(1)
FALSE
TRUE
‘1’¹ÜÀíÔ±£¬‘2’ÆÕͨÓû§
CREATE TABLE ITS_USER
   (USERXH VARCHAR2(32) NOT NULL,
    USERNAME VARCHAR2(16),
    PASSWORD VARCHAR2(32),
    TELEPHONE VARCHAR2(30),
    GLBM VARCHAR2(10),
    YHDJ VARCHAR2(2),
    YHJS VARCHAR2(1),
    constraint PK_T_SCORE primary key(USERXH)
    );
----------------------------------------------------------
²éѯ£º
select * from ITS_USER
-------------------------------------------------------
²åÈëÊý¾Ý£º
INSERT INTO ITS_USER(USERXH,USERNAME,PASSWORD,