Oracle 处理数据
INSERT语句:
- 为每一列添加一个新值。
- 按列的默认顺序列出各个列的值。
- 在 INSERT 子句中随意列出列名和他们的值。
- 字符和日期型数据应包含在单引号中
INSERT INTO departments(department_id, department_name, manager_id, location_id)
VALUES (71, 'Public Relationss', 101, 1700);
插入日期方式:
INSERT INTO employees
(employee_id,
first_name, last_name,
email, phone_number,
hire_date, job_id, salary,
commission_pct, manager_id,
department_id)
VALUES
(208, 'Louis', 'Popp',
'pop', '33333',
to_date('2012-3-21','yyyy-mm-dd'),
'AC_ACCOUNT', 6900,
NULL, 205, 100);
隐式方式:
INSERT INTO departments (department_id, department_name )
VALUES (310, 'Purchasing');
显示方式:
INSERT INTO