使用小结

2007-11-29
1.向数据库表中插入新列
ALTER TABLE GLOSSARY ADD (DIS_ORDER VARCHAR2(2 BYTE));

2.修改数据库
ALTER DATABASE Test1
ADD FILE //为数据库增加文件
( NAME = test1dat3,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat3.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB),
( NAME = test1dat4,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat4.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)

2007-11-30
3.改变数据库的显示值
decode(Building.PBL_VISIBLE,'1','Yes','No')
//表Building 列PBL_VISIBLE
如果列值为1则显示Yes,否则显示No

:) 4.屏蔽掉相同的列：distinct

:) 5.连接号：||
把两个字符连接起来
eg:select game_card_type_id||name from game_card_type;
eg:多个列值合并成一列显示
select distinct(A.AREA_CODE), (D.NAME||' - '||C.NAME||' - '||B.NAME) as NAME,
(D.NAME_C||' - '||C.NAME_C||' - '||B.NAME_C) as NAME_C, B.DIS_ORDER
from village A, z_area B, z_district C, z_region D
where A.AREA_CODE = B.AREA_CODE and A.REGION_CODE = D.REGION_CODE and A.DISTRICT_CODE = C.DISTRICT_CODE


6.处理符号 >=,<= 等,在Oracle里不能直接使用,需要包装
select * from "USER"
where USR_ID='amo1' and MONTHS_BETWEEN(TRUNC(SYSDATE, 'DD'), TRUNC(PW_UPD_DT, 'DD')) <![CDATA[ <= ]]> 6