Oracle SQL Developer - format query output

Question

I've got this simple query:

select e.empname.title, e.empname.firstname, e.empname.surname 
from employee e
where e.empname.firstName like '%on%' and e.empaddress.city like 'New York';

I'm using objects, and im trying to format the columns on the query results, so it shows 'Title', 'First name' and 'Surname'instead of the types ive created i've tried adding the following above the query, and a few other variations with no luck.

COLUMN E.EMPNAME.TITLE    HEADING 'Title'

Any guidance would be appreciated!

Shreyas Chavan · Accepted Answer · 2015-08-04 22:44:43Z

1

select e.empname.title as Title , e.empname.firstname as Firstname, e.empname.surname as Surname
from employee e
where e.empname.firstName like '%on%' and e.empaddress.city like 'New York';

answered Aug 4, 2015 at 22:44

Shreyas Chavan

1,0991 gold badge7 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Oracle SQL Developer - format query output

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related