SQL101-命令大全(国外英语资料).docVIP

SQL101-命令大全(国外英语资料) Up sqlplus system / 123456 @ former Select the user from dual; Database system subsystem: transaction handler; Query processor; Storage manager. Data Definition Language (DDL) Data Manipulation Language (DML) DBMS (Data Management System) Data blocks (Extents) section (sections) The table space (Tablespaces) Table columns and rows Data Definition Language (DDL) Statements Data Manipulation Language (DML) Statements Transaction Control Statements Transaction Control Statements Session Control Statements System Control Statements Embedded SQL Statements Embedded SQL Statements Create table: create table [schema.] table_name (column_name datatype [...]); Using the create global temporary table command, you can create a temporary table, On commit delete rows (the default option) for the specified transaction temporary table, The on commit preserve rows option is used to specify the session temporary table. Use the subquery build table: create table table_name (column, column...)] as subquery In this case, table_name is used to specify the table name; Column is used to specify column names; Subquery is used to specify subqueries. Alter table: alter table table_name add (column datatype [, column datatype...]) Alter table table_name modify (column datatype [, column datatype...]) Alter table table_name drop (column); Alter table table_name rename column column_name to new_column_name; Modify the table name: rename object_name to new_object_name; Add comments: comment on table table_name is text ; The comment on column table_name.column is text ; Truncate table: truncate table table_name / / you cant go back. Drop table: drop table table_name [purge]; In this case, table_name is used to specify the table name; Cascade constraints is used to specify cascading deletes from the tables external keys; Purge is used to specify a complete delete table. Flashback table table_name to before drop; Display the user table: select table_name from user_tables; / / s