文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > Introduction to Oracle9i SQL
侵权投诉

Introduction to Oracle9i SQL

Introduction to Oracle9i  SQL

1-1. List the capabilities of SQL SELECT statements 描述一個SQL SELECT 敘述 1-2. Execute a basic SELECT statement 執行一個簡單的SELECT敘述

1-3. Differentiate between SQL statements and iSQL*Plus commands 瞭解SQL與iSQL*Plus命令間的差異

SELECT *|{[DISTINCT] column|expression [alias],...} FROM table;

SQL的語句可以分多行來表示,但關鍵字與變數不可分割斷行.

DISTINCT 過濾重複值

*distinct必頇放置在所有column之前. 當一個欄位時,只傳回唯一值.

當二個欄位以上時,傳回欄位組合的唯一值.

Aslias欄位別名

*在SELECT選取欄位後可接 as 或空白,來替代欄位別名。 SQL > SELECT job 職位 FROM emp; 或

SQL > SELECT job 職位 FROM emp; 或

SQL > SELECT job AS 職位 FROM emp; 兩者結果相同

FROM 表格來源

*在FROM子句中可接表格或用子查詢來替代表格. SQL > SELECT * FROM emp ;

SQL > SELECT * FROM ( SELECT job FROM emp) ;

Arithmetic Expressions 數學表示式 運算優先順序 * / + -

SQL > SELECT 120*salary+100 FROM employees; 要注意salary先乘120再加100 *在使用欄位運算時,欄位值如果是CHAR型態,回傳時會自動轉型為NUMBER SQL > CREATE TABLE b ( b1 CHAR(10) ) ; SQL > INSERT INTO b VALUES (‘2’) ; SQL > SELECT b1 * 2 FROM b ; success!!

SQL > INSERT INTO b VALUES (‘a’) ; SQL > SELECT b1 * 2 FROM b ; false!!

當欄位運算遇到NULL時,則傳回NULL

SQL > SELECT NULL*2 COLUMN1 , 123*2 COLUMN2 FROM dual;

COLUMN1 123*2

Introduction to Oracle9i  SQL

246

Concatenation Operator 連結運算元,注意 連接字串時是使用’’單引號,而欄位別名是使用 雙引號 連結運算元 || 用來連接兩個欄位值,其值不分number,char,date型別. SELECT last_name || ' is a ' || job_id AS "Employee Details" FROM employees;

上一页第3页

你可能喜欢

热门文档

相关文档

  • Introduction to Oracle9i SQL -__ Volume III

    Introduction to Oracle9i SQL -__ Volume III oracle认证教材oracle认证教材隐藏>> Introduction to Oracle9i: SQL Additional Practices ? Volume 3 40049GC10 Produ...

  • Oracle OCP SQL Introduction to Oracle9i SQL

    Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义隐藏>> Introduction to Oracle9i: SQL...

  • Oracle9i-SQL

    Introduction to Oracle9i: SQL Electronic Presentation 40049GC11 Production 1.1 October 2001 D33996 Copyright ? Oracle Corporation, 2001. All rights reserved....

  • Analytic Extensions to SQL in Oracle9i

    Oracle9i-SQL-20 Oracle9i... 22页 免费 Introduction to Oracle9i... 暂无评价 41页 免费 Introduction to Oracle9i... 76页 5财富值 Oracle OCP SQL Introduct...

  • Introduction to T-SQL

    Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...

  • 02-Introduction to SQL

    Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...

  • Oracle9i_sql

    Exam# 1Z0-007: Introduction to Oracle9i: SQL? Writing Basic SQL Select Statements [ ] List the capabilities of SQL SELECT statements [ ] Execute a bas...

  • Oracle9i OCP考试

    表1-3 Oracle9i Certified Associate 考试概况 考试号 1Z0-007 考试内容 Introduction to Oracle9i:SQL 1Z0-031 Oracle9i Database : Fundamentals I 44 60 73% ...

  • SQL Group Functions

    SQL Group FunctionsSQL Group Functions隐藏>> SQL Group Functions Introduction to Oracle9i: SQL 1 Chapter Objectives ? Differentiate between single-row and mult...

  • ORACLE基础篇-SQL

    Introduction to Oracle9i: SQL I-5 Oracle9i Database Object Relational Data Documents XML Multimedia Messages I-6 Copyright ? Oracle Corporation, 2001. All ...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email