[撰寫簡單的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 [建立與維護約束條件]
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 认证考试 PPT讲义Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义隐藏>> Introduction to Oracle9i: SQL...
Introduction to Oracle9i: SQL Electronic Presentation 40049GC11 Production 1.1 October 2001 D33996 Copyright ? Oracle Corporation, 2001. All rights reserved....
Oracle9i-SQL-20 Oracle9i... 22页 免费 Introduction to Oracle9i... 暂无评价 41页 免费 Introduction to Oracle9i... 76页 5财富值 Oracle OCP SQL Introduct...
Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...
Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...
Exam# 1Z0-007: Introduction to Oracle9i: SQL? Writing Basic SQL Select Statements [ ] List the capabilities of SQL SELECT statements [ ] Execute a bas...
表1-3 Oracle9i Certified Associate 考试概况 考试号 1Z0-007 考试内容 Introduction to Oracle9i:SQL 1Z0-031 Oracle9i Database : Fundamentals I 44 60 73% ...
SQL Group FunctionsSQL Group Functions隐藏>> SQL Group Functions Introduction to Oracle9i: SQL 1 Chapter Objectives ? Differentiate between single-row and mult...
Introduction to Oracle9i: SQL I-5 Oracle9i Database Object Relational Data Documents XML Multimedia Messages I-6 Copyright ? Oracle Corporation, 2001. All ...
热门文档