oracle sql concat query title -
for course of databases got home sql excercises. 1 of them result this:
who earns _____________________ mr martin earns 1250 month
now got way select right data in:
select 'mr ' || ename || ' earns ' || sal || ' month ' emp ename = 'martin';
but can't find how put title on top of query? can me on that?
as "who earns what"
like this:
select 'mr ' || ename || ' earns ' || sal || ' month ' "who earns what" emp ename = 'martin';
Comments
Post a Comment