Oracle DB - Select Multiple Columns As Alias

Question

When working with Oracle is it possible to select multiple columns at once and assign them each an alias? I have Googled around but can't seem to come up with a straight answer. An example of what I want to do would be something like:

SELECT prod_id, prod_name AS "Product ID", "Product Name" FROM tbl_products

When I run this I get the error: ORA-00904: "Product Name": invalid identifier

Any advice?

Arion · Accepted Answer · 2012-05-21 09:25:27Z

1

I think you mean like this:

SELECT prod_id AS "Product ID", prod_name AS "Product Name" FROM tbl_products

answered May 21, 2012 at 9:25

Arion

31.3k10 gold badges75 silver badges89 bronze badges

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

2 Comments

iainjames88 Over a year ago

Thanks for the quick reply - I feel like such an idiot with the solution being so simple!

Arion Over a year ago

No problem. Glad to help:P. Remember to accept the answer if you are fine with it.

Collectives™ on Stack Overflow

Oracle DB - Select Multiple Columns As Alias

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related