Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I put a literal, or header, in a select query?

626608Sep 22 2008 — edited Mar 19 2009
I want to run a bunch of select queries and would like them to have headers

SELECT id
FROM fac_import_invoices
where facilities_pa is null;

SELECT id
FROM next_table
where facilities_pa is null;

SELECT id, facilities_pa not_Found_project
from fac_import_invoices
WHERE facilities_pa not in (select facilities_pa from fac_import_projects);
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2008
Added on Sep 22 2008
20 comments
2,680 views