[建立視觀表] [ ] Describe a view [描述「視觀表」view的用途] [ ] Create, alter the definition, and drop a view [建立、更改與移除視觀表] [ ] Retrieve data through a view [查詢視觀表的資料] [ ] Insert, update and delete data through a view [透過視觀表執行新增、修改與刪除資料] [ ] Create and use an inline view [建立「內嵌視觀表」(inline view)] [ ] Perform Top 'N' Analysis [執行Top-N查詢]
[建立其他資料物件] [ ] Create, maintain and use sequences [建立、維護與使用「序列」(sequences)] [ ] Create and maintain indexes [建立與維護「索引」(index)] [ ] Create private and public synonyms [建立公用與私有「同義字」synonym]
[使用者權限管理] [ ] Create users [建立使用者帳號] [ ] Create Roles to ease setup and maintenance of the security model
[利用「角色」來簡化資料庫安全性管理機制]
[ ] Use the GRANT and REVOKE statements to grant and revoke object privileges [執行grant與revoke敘述來授予撤回權力]
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 ...
热门文档