Re: SELECT returnig a constant

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
ray@rodonnell.ie