目录
语句1：建立表格语句：
create table CONTACT_REF
(
MSISDN varchar2(128)
,CONTACT varchar2(128)
,PHONE varchar2(128)
,FLAG varchar2(128)
,CONTENT varchar2(128)
,CREATE_TIME varchar2(128)
,CHANGE_TIME varchar2(128)
,DATA_SOURCE varchar2(128)
,STATE varchar2(128)
,REG_STATUS varchar2(128)
,REG_DATE varchar2(128)
,ERROR_MSG varchar2(128)
,AREA_CODE varchar2(128)
,MOD_CHAN_TIME varchar2(128)
,LATITUDE varchar2(128)
,LONGITUDE varchar2(128)
);
语句2：插入数据语句：
INSERT INTO table_name (column_1, column_2, column_3, ... column_n)
VALUES( value_1, value_2, value_3, ..., value_n);
语句3：查询表格表结构：
desc tablename;
语句4：查询表格的所有数据
select * from tablename;
语句5：表格插入多行新的数据
INSERT INTO TMP_DIM_EXCH_RT
(EXCH_WH_KEY,
EXCH_NAT_KEY,
EXCH_DATE, EXCH_RATE,
FROM_CURCY_CD,
TO_CURCY_CD,
EXCH_EFF_DATE,
EXCH_EFF_END_DATE,
EXCH_LAST_UPDATED_DATE)
VALUES
(1, 1, '28-AUG-2008', 109.49, 'USD', 'JPY', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),
(2, 1, '28-AUG-2008', .54, 'USD', 'GBP', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),
(3, 1, '28-AUG-2008', 1.05, 'USD', 'CAD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),
(4, 1, '28-AUG-2008', .68, 'USD', 'EUR', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),
(5, 1, '28-AUG-2008', 1.16, 'USD', 'AUD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008'),
(6, 1, '28-AUG-2008', 7.81, 'USD', 'HKD', '28-AUG-2008', '28-AUG-2008', '28-AUG-2008');
语句6：登陆oracle
sqlplus 用户名@//1.1.1.1:1521/实例名
语句7：删除整个表格语句
DROP TABLE persons;