Oracle SQL语句之UPDATE
来源:互联网 发布:多表查询sql语句 编辑:程序博客网 时间:2024/05/22 11:41
ELECT - All columns
Return all columns.
SELECT * FROM COURSES
SELECT - Return first 10 rows
Run a SQL Select statement and limit the number of rows returned. Useful when you are not sure of how to limit the recordset to be returned and you only want to return a few rows to do some initial analysis.
SELECT COURSE_DESIGNATER , COURSE_NAME , EMPLOYEE_INACTIVATING FROM COURSESWHERE RowNum < 11
SELECT - Count rows in table
Returns a count of the total number of rows in a table.
SELECT COUNT(*) from COURSES
SELECT - Joining tables
Join two Oracle tables together.
SELECT b.COURSE_NAME , a.CLASS_END_DATE , a.CLASS_START_DATE FROM CLASSES a JOIN COURSES b ON b.COURSE_DESIGNATER = a.COURSE_DESIGNATER_FKWHERE RowNum < 100 /
UPDATE - Single row
Update a single row of data.
UPDATE STUDENTSSET EMPLOYEE_ID_FK = '3789' , GENDER_CODE = 'F' , MARITAL_STATUS_CODE = 'M' WHERE STUDENT_ID = 11 /COMMIT WORK ;/
UPDATE - Update multiple rows
Update multiple rows of data..
UPDATE CLASSCONVENINGSSET ACITVE_FLG = 2WHERE CLASS_CONVENE_DATE = TO_DATE('2005-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS') /COMMIT WORK ;/http://www.sqlinfo.net/oracle/oracle_INSERT.phpOracle SQL INSERT Example
INSERT - Row
Insert a row of data. Note: the minimum requirements for and insert must include columns that are part of the primary key, part of indexes where no duplicates are allowed, and all columns that cannot be null.
INSERT INTO COURSES ( COURSE_DESIGNATER , COURSE_NAME , EDUCATION_DELIVERY_METHOD , COURSE_DESCRIPTION_SHORT , COURSE_DESCRIPTION_LONG , COURSE_SYLLABUS_ATTACHMENT , COURSE_MATERIALS_ZIP , COURSE_MATERIALS_LOCATION , MAX_RECOMMENDED_ENROLLMENT , CONVENINGS , CONVENINGS_DETAILS , CONVENINGS_CONSECUTIVE_FLG , TYPICAL_PRECLASS_PREP_TIME , TYPICAL_POSTCLASS_PREP_TIME , TYPICAL_CONVENING_TIME , SPONSER_NAME , ACTIVE_FLG , INACTIVE_DATE , INACTIVE_REASON , EMPLOYEE_INACTIVATING ) VALUES ( 'SQL200' , 'Intermediate SQL' , 'Classroom' , NULL , NULL , 'doc' , 'zip' , 'DataExpressions\csematerials' , 16 , 0 , NULL , 0 , NULL , NULL , NULL , NULL , 1 , NULL , NULL , 0 ) /COMMIT WORK ;Oracle SQL DELETE Examples
DELETE - Row
Delete a row of data.
DELETE FROM COURSESWHERE COURSE_DESIGNATER = 'Java110' /COMMIT WORK ;DELETE - Multiple rows of data
Delete multiple rows of data. Be careful!
DELETE FROM CLASSCONVENINGSWHERE CLASSES_NUM_FK > 4 AND CLASS_CONVENE_DATE = TO_DATE('2006-02-15 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND CLASS_LOCATION_FK = 'Seattle-Training Room 1
- Oracle SQL语句之UPDATE
- SQL语句之Update
- Oracle SQL:update更新语句总结
- oracle之sql语句
- oracle之SQL语句
- Oracle-----Update语句优化之merge into
- LINQ to SQL语句(11)之Update
- LINQ to SQL语句(11)之Update
- LINQ to SQL语句(11)之Update
- 81.Oracle数据库SQL开发之 修改表内存——使用UPDATE语句
- Oracle与SQL Server对Update语句的处理
- oracle恢复update以后数据的SQL语句
- oracle update语句
- ORACLE UPDATE 语句语法
- oracle update 语句无效
- oracle update语句
- Oracle update语句 格式
- oracle update 语句分析
- win7系统IE8中Internet选项启用内存保护帮助减少联机攻击置灰,无法去掉选项勾。
- 【ARM 汇编语言】
- Android下JNI使用stringstream
- 奇偶剪枝***&&***HDU1010 Tempter of the Bone
- jquery的each()详细介绍
- Oracle SQL语句之UPDATE
- 什么因素决定浏览器前进后退时的页面一定会被刷新?
- word 自动项目编号,自动关联上一级编号
- 怎样取消IE8中的启用内存保护攻击
- .java.io.StreamCorruptedException: invalid type code: AC解决办法
- Java类装载的过程及原理介绍
- 绿化软件之常用工具
- ios UItableview的使用
- acl_cpp中流式编程的设计