Add a empty row into select SQL query

Question

Is it possible to add a dummy row in the select clause which represents as a header to the results that are returned. The header should be part of the SQL query results.

Name|Address|Phone Numer
XYZ|City name|1233457890

The second row is the sql result and first one the header. I already have the header string constructed which is dynamic.

You could do something like this but note that it will attempt to cast all the data in the rest of your query to the types of the values in the header. — Nick
– Nick, Commented Sep 24, 2019 at 23:07

Ed Bangga · Accepted Answer · 2019-09-25 00:09:30Z

1

Here's your query.

select 'Name' as "Name", 'Address' as "Address", 'Phone Number' as "Phone Number" from dual
union all
select Name, Address, "Phone Number" from yourtable

answered Sep 25, 2019 at 0:09

Ed Bangga

13k4 gold badges18 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add a empty row into select SQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related