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

Introduction to Oracle9i SQL

[撰寫簡單的SQL Select敘述] [ ] List the capabilities of SQL SELECT statements 描述一個SQL SELECT 敘述 [ ] Execute a basic SELECT statement 執行一個簡單的SELECT敘述

[ ] Differentiate between SQL statements and iSQL*Plus commands 瞭解SQL與iSQL*Plus命令間的差異

[限制及排序資料] [ ] Limit the rows retrieved by a query 限制請求取回的列資料 [ ] Sort the rows retrieved by a query 排序請求取回的列資料

[單列函數] [ ] Describe various types of functions available in SQL 說明SQL中各種有用的函數類型

[ ] Use character, number, and date functions in SELECT statement 在SELECT敘述中使用字元,數字,日期函數 [ ] Use conversion functions 使用轉換函數

[從多表單中顯示資料]

[ ] Write SELECT statements to access data from more than one table using equality and nonequality joins [ ] View data that generally does not meet a join condition by using outer joins [ ] Join a table to itself using a self-join

[使用群組函數來統計資料] [ ] Identify the available group functions 分辨使用群組函數的時機 [ ] Use group functions 使用群組函數 [ ] Group data using the GROUP BY clause 使用GROUP BY子句來群組資料 [ ] Include or exclude grouped rows by using the HAVING clause

[子查詢] [ ] Describe the types of problems that subqueries can solve [描寫「次查詢」能夠解決的問題] [ ] Define subqueries [撰寫「次查詢」指令] [ ] List the types of subqueries [辨識不同種類的「次查詢」] [ ] Write single-row and multiple-row subqueries [撰寫「單列次查詢」與「多列次查詢」]

[在SQL*Plus 產生美觀的輸出報表] [ ] Produce queries that require a substitution variable [使用替代變數撰寫SQL敘述句] [ ] Produce more readable output [產生可讀性較高的輸出結果] [ ] Create and execute script files [建立與執行指令]

[資料處理動作] [ ] Describe each DML statement [熟悉各種DML敘述句] [ ] Insert rows into a table [將資料新增至表格] [ ] Update rows in a table [更改表格既有資料] [ ] Delete rows from a table [刪除表格資料] [ ] Merge rows in a table [合併表格資料] [ ] Control transactions [控制資料庫交易]

[建立與維護表格] [ ] Describe the main database objects [描述主要的資料庫物件] [ ] Create tables [定義表格欄位時可使用的資料型別] [ ] Describe the datatypes that can be used when specifying column definition [定義表格欄位時可使用的資料型別] [ ] Alter table definitions [更改表格定義] [ ] Drop, rename and truncate tables [刪除、更名與截斷表格]

[加入約束條件] [ ] Describe constraints [瞭解「約束條件」contraints的用途] [ ] Create and maintain constraints [建立與維護約束條件]

第1页

你可能喜欢

热门文档

相关文档

  • 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