《oracle教学课件》尚硅谷_宋红康07_创建和管理表.pptVIP

Data Types Creating a Table from Rows in Another Table A second method for creating a table is to apply the AS subquery clause, which both creates the table and inserts rows returned from the subquery. In the syntax: table is the name of the table column is the name of the column, default value, and integrity constraint subquery is the SELECT statement that defines the set of rows to be inserted into the new table Guidelines The table is created with the specified column names, and the rows retrieved by the SELECT statement are inserted into the table. The column defin