Thread: In SQL Statement What is the use of "?"

Hi Guys,

In this SQL Statement :

Select column1, column2, column3, from table1 where column1 = ? and column2 = ? and column3 = ?

What is the use of ? here, what is the value of ? here too.

appreciate your answers.

I don't think "?" has any meaning in oracle SQL.
I think you are using sql tools like TOAD or SQL Navigator.

"?" has no use in SQL .
I think you might have come across this statment which is called from any front end like Java.

Hi! Neol,
I guess you are using sql statement in java, there it represents value which is going to be retrieve from the table or from the user. And in general it is used as a wild card which hold a value of single digit or character.

Thanks & Regards.