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

Introduction to Oracle9i SQL

[建立視觀表] [ ] 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敘述來授予撤回權力]

上一页第2页

你可能喜欢

热门文档

相关文档

  • 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