Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2020-12-07 03:13:23
CREATE TABLE AS
1809
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
If you want to create a table from an existing table by copying the columns of existing table, CREATE TABLE AS statement is used.
Syntax:
CREATE TABLE new_table AS (SELECT * FROM old_table);
Copying selected columns of another table
Syntax:
CREATE TABLE new_table AS (SELECT column_1, column2, ... column_n FROM old_table);
Copying selected columns from multiple tables
Syntax:
CREATE TABLE new_table AS (SELECT column_1, column2, ... column_n FROM old_table_1, old_table_2, ... old_table_n);