Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Data Definition LangRSS Feeds

CREATING A TABLE FROM A TABLE

Posted By: Matheus Silva     Category: Oracle     Views: 2747

This article provides an example of CREATING A TABLE FROM A TABLE.

Customer - orders - salespeople database

CREATING A TABLE FROM A TABLE

CREATE TABLE Ahmd_Salespeople(snum,sname,city) AS (SELECT snum,sname,city FROM Salespeople  WHERE city='ahmd');

SELECT * FROM Ahmd_Salespeople;

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on CREATING A TABLE FROM A TABLE Or get search suggestion and latest updates.

Matheus  Silva
Matheus Silva author of CREATING A TABLE FROM A TABLE is from Salvador, Brazil.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!