What did I do wrong in this SQL query?

Question

create table divorced_females 
select cust_id, cust_first_name,cust_last_name, cust_gender, cust_marital_status from customers 
where cust_gender = 'F' and cust_marital_status = 'divorced';

I am getting errors like below:

Error starting at line : 1 in command -
create table divorced_females
select cust_id, cust_first_name,cust_last_name, cust_gender, cust_marital_status from customers
where cust_gender = 'F' and cust_marital_status = 'divorced'

Error report
ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
*Cause:
*Action:

Thank you in advance.

Where you trying to create a table from the result of a select statement? Such a statement is called a CTAS statement ("Create Table As Select ...") You are missing the keyword AS between the table name and the keyword select. — user5683823
– user5683823, Commented Oct 9, 2018 at 23:50

Pim H · Accepted Answer · 2018-10-10 04:53:25Z

2

You missing 'AS' after table name.

Try statement below:

create table divorced_females as
select cust_id, cust_first_name,cust_last_name, cust_gender, cust_marital_status 
from customers 
where cust_gender = 'F' and cust_marital_status = 'divorced';

answered Oct 10, 2018 at 4:53

Pim H

2232 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kapil · Accepted Answer · 2018-10-10 07:55:37Z

0

The syntax for the CREATE TABLE AS statement copying the selected columns is:

CREATE TABLE new_table
  AS (SELECT column_1, column2, ... column_n
  FROM old_table);

So in your case query will be

create table divorced_females  AS 
 (select cust_id, cust_first_name,cust_last_name, cust_gender, cust_marital_status 
 from customers 
where cust_gender = 'F' and cust_marital_status = 'divorced');

answered Oct 10, 2018 at 7:55

kapil

4192 silver badges7 bronze badges

Collectives™ on Stack Overflow

What did I do wrong in this SQL query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related