Oracle命令--查、多表联查、插入、修改

查
SELECT [ * | all | column1,column2 ]
 FROM  table1 [ ,table2 ]
 [ WHERE condition ]
 [ GROUP BY column1 ]
 [ ORDER BY column2(asc,desc) ]

 

多表联查

SELECT  employee_tbl.emp_name, employee_pay_tbl.position
FROM employee_tbl, employee_pay_tbl
WHERE  employee_tbl.emp_id = employee_pay_tbl.emp_id

 

插入
INSERT  INTO table_name
   VALUES(value1,value2,…...)

 

修改

UPDATE  table_name
SET column_name = ‘value’
 [WHERE  condition]