如何在SQL查询中声明常量?

I am using Oracle 11g R2. Is there a way to give a name (alias) to a single value selected from a table before an SQL query in the same expression? That is a single SQL command, I mean, and no PL/SQL.I am using Oracle 11g R2. Is there a way to giv