db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Kartha <kar...@Source-Zone.Org>
Subject Re: LABEL ON functionality in Derby?
Date Wed, 19 Jan 2005 00:29:42 GMT

Is  'Select  <col> as from <table>' , what you are looking for.

The schema:
ij> select * from atab;
ID         |COL1|COL2
1          |CA  |MI

1 row selected

Using the 'select as'

ij> select id as IDENT_NUM from atab;

1 row selected


Jason Palmatier wrote:

>Does Derby support anything like LABEL ON which allows
>you to set the label (i.e. a displayable name) for a
>column after a table is created?  I checked the
>reference manual and it doesn't seem to but I wanted
>to ask here to be sure.
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 

View raw message