oracle_30天之6.docVIP

sql语句——DDL and constraints 一．DDL 1. Creating and managing tables Table: Basic unit of storage; composed of rows and columns *Tables in the Oracle Database User Tables: 用户表 scotts or hrs Are a collection of tables created and maintained by the user. Contain user information. Data Dictionary:系统表 Is a collection of tables created and maintained by the Oracle Server. Contain database information,can see as the table created by systeam; ##数据字典:oracle本身的数据,管理数据库信息，系统信息 相当于：windows注册表 只能用，不能直接修改。只有在作DDL语句的时候才能由数据库服务器自 己更新数据字典。比如，新定义的表，表的名字等信息，会被存入数据字 典。 ##eg: dba_user,说明在oracle里面有那些用户。 ALL_COL_COMMENTS USER_COL_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS *The CREATE TABLE Statement ##First of all :You must have:CREATE TABLE privilege,A storage area. ##在创建表的时候，要有：创建的权限和存储区域，放文件 CREATE TABLE [schema.]table ##所有创建的表在SCHEMA里，默认有SCHEMAS 1：1 (column datatype [DEFAULT expr][, ...]); 最多1000列 用， 分开 You specify: －Table name tab_xxxxx ##英文单词，中文：第一个字全拼，第二个以后首字 母；如果与之前的第一第二个相同，也要用全拼。 －Column name, column data type, and column size ##Table names and column names: Must begin with a letter 字母打头 Must be 1-30 characters long 不超30 Must contain only A-Z, a-z, 0-9, _, $, and # Must not duplicate the name of another object owned by the same user Must not be an Oracle server reserved word 不用保留字 v$reserved_words 保留字 ##select KEYWORD,RESERVED from v$reserved_words where reserved=Y; ## help index ## help RESERVED WORDS －Referencing Another User?ˉs Tables