Skip to content
February 4, 2013 / doganay

ORA-00998: MUST NAME THIS EXPRESSION WITH A COLUMN ALIAS


Problem:

create table table2 as
SELECT col1||','||col2 FROM table1;

ORA-00998: MUST NAME THIS EXPRESSION WITH A COLUMN ALIAS


Solution:

Give an alias:

create table table2 as
SELECT col1||','||col2 "newcol" FROM table1;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: