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
Hi,

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;
IDENT_NUM
-----------
1

1 row selected


-Rajesh


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.
>
>Thanks,
>Jason
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>
>  
>


Mime
View raw message