## –创建表格
CREATE TABLE Account_szl1(
id NUMBER(9),
recommender_id NUMBER(9),
login_name VARCHAR2(30),
login_passwd VARCHAR2(8),
status CHAR(1),
create_date DATE,
pause_date date,
close_date date,
real_name VARCHAR2(20),
idcard_no char(18),
birthdate date,
gender CHAR(1),
occupation varchar2(50),
telephone VARCHAR2(15),
email VARCHAR2(50),
mailaddress VARCHAR2(50),
zipcode CHAR(6),
qq VARCHAR2(15),
last_login_time date,
last_login_ip VARCHAR2(15)
);
## --修改表名
RENAME account_szl to t_account_szl;
## --增加一列bak,其数据类型为varchar2,长度为50;
ALTER TABLE account_szl add(
bak VARCHAR2(50)
);
–bak列的长度为40,并增加默认值的设置,默认值为“login”;
ALTER table account_szl MODIFY(
bak VARCHAR2(40) DEFAULT’login’
);
–删除t_Account_XXX表中的bak列。
ALTER TABLE account_szl drop(bak);
–向t_Account_XXX表中插入一条记录
INSERT INTO account_szl(id,login_name,login_passwd,create_date,real_name,idcard_no,telephone) VALUES
(1,‘chenhh’,256528,SYSDATE,‘chenhehe’,410381194302256523,13669351234);
update account_szl set create_date =(to_date(‘2008-01-28’,‘yyyy-MM-dd’));
where id = 1;
–将账务账户表ID为1的账务账户的密码更改为801206。
UPDATE account_szl set login_passwd = 801206
where id = 1 ;
–删除账务账户表中ID为1的账务账户信息。
DELETE from account_szl
WHERE id = 1;
创建表格
CREATE TABLE emp_szl(
empno NUMBER(4,0),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4,0),
hiredate date,
sal NUMBER(7,2),
comm NUMBER(7,2),
deptno NUMBER(2,0)
);
CREATE table dept_szl(
deptno NUMBER(2,0),
dname VARCHAR2(14 BYTE),
loc VARCHAR2(13 BYTE)
);
INSERT INTO emp_szl(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES
(7369,‘SMITH’,‘CLERK’,7902,to_date(‘1980/12/17’,‘yyyy/MM/dd’),800,NULL,20);
INSERT INTO emp_szl(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)VALUES
(7499,‘ALLEN’,‘SALESMAN’,7698,to_date(‘1981/2/20’,‘yyyy/MM/dd’),1600,300,30);
INSERT INTO emp_szl(E