PL SQL Where Clause with column / field name being data type

A quick question with PL SQL, it seems that the table column was called the NUMBER data type, so an attempt to execute the query is not performed because the column is recognized as a data type instead of the column name. Does anyone know how to get around this without changing the circuit?

EDIT:

Thanks to everyone for the help, yes, the problem was that it had to be in quotation marks and was case sensitive.

+3
source share
3 answers

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

+5
source

( "column_name" )

+3

Try swapping the column name in single or double quotes.

-1
source

Source: https://habr.com/ru/post/1742512/


All Articles