PL SQL Where Clause with Column/Field name being a datatype

Question

Quick question playing with PL SQL it seems that the tables column was named as the data type NUMBER so trying to perform a query fails since the column is being recognized as a datatype instead of a column name. Anyone know how to get around this without modifying the schema?

EDIT:

Thanks everyone for the help yeah the issue was it had to be in quotes and was case sensitive.

Vadim K. · Accepted Answer · 2010-04-23 18:24:49Z

5

Place it between double quotes and the case of each character must match the case of the corresponding character in the column name exactly.

answered Apr 23, 2010 at 18:24

Vadim K.

2,61122 silver badges30 bronze badges

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

Comments

Shepherdess · Accepted Answer · 2010-04-23 18:23:29Z

3

Try putting the column name in double quotes ("column_name")

answered Apr 23, 2010 at 18:23

Shepherdess

6516 silver badges7 bronze badges

Comments

Alex Khvatov · Accepted Answer · 2010-04-23 18:21:29Z

-1

Try wrapping a column name in single or double quotes.

answered Apr 23, 2010 at 18:21

Alex Khvatov

1,4853 gold badges14 silver badges23 bronze badges

2 Comments

MJB Over a year ago

I think it has to be double quotes.

Bill Karwin Over a year ago

Yes, single quotes in SQL are for string literals, double quotes are for delimited identifiers.

Collectives™ on Stack Overflow

PL SQL Where Clause with Column/Field name being a datatype

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related