How to I write a string before the select statement?

Question

What I want to do is write a string so I can format the output of the SQL statement and have it display text before I actually output the rows I have selected.

i.e. The next timesheet ID is [timesheetID]

I'm trying to do it by using;

||'The next timesheet ID is'|| select max(timesheet_id) + 1 from funtom_timesheet;

Which obviously isn't working, how do I do this?

Answer 1

Use something like this

Select 'The next timesheet ID is ' || max(timesheet_id) + 1 from funtom_timesheet;

or

select concat('The next timesheet ID is ',max(timesheet_id)+1) from futom_timesheet;