Re: SELECT returnig a constant

[Ray O'Donnell]

On 15/10/2019 14:28, stan wrote:
I used to be able to return a constant value in a SELECT statement in
ORACLE. I need to populate a table for testing, and I was going to do so
like this:
SELECT
         employee.id ,
                project.proj_no ,
                work_type.type  ,
                'rate' 1
FROM employee
CROSS JOIN project
CROSS JOIN work_type;

This statement works correctly, till I add the last "'rate' 1 line, then it
returns a syntax error.

I don't think you can use a number as a column name. Give it a different 
name and it should work:

SELECT .... , 'rate' my_constant_name FROM ...

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie