Prev: How do oracle programmers send batches of SQL from inside a program?
Next: Future of Oracle RDBMS?
From: GhostBuck on 21 Mar 2010 12:36
In SQL I am able to select a field as something else. I will use this
in generic function for naming grid columns readable to the user.

e.g. Select bdate as [Date of Birth] from ....

Oracle via ADO does not seem to like the [] around the "AS" name. How
would I accomplish this in Oracle?
From: Mladen Gogala on 21 Mar 2010 12:44
On Sun, 21 Mar 2010 09:36:08 -0700, GhostBuck wrote:

> Oracle via ADO does not seem to like the [] around the "AS" name. How
> would I accomplish this in Oracle?

Without the brackets around?



--
http://mgogala.freehostia.com
From: GhostBuck on 21 Mar 2010 12:58
Without the brackets it works... but you have to lose the spaces, ":",
".", etc. For instance I might want to do this:

Select BatchNo as [Batch Number:] to make a grid readable by the user.
From: Tony Sequeira on 21 Mar 2010 13:46
GhostBuck wrote:
> In SQL I am able to select a field as something else. I will use this
> in generic function for naming grid columns readable to the user.
>
> e.g. Select bdate as [Date of Birth] from ....
>
> Oracle via ADO does not seem to like the [] around the "AS" name. How
> would I accomplish this in Oracle?

Try with double quotes, so:

Select bdate as "[Date of Birth]" from ....

May help. Know nothing about ADO, pardon if this has been tried and
discarded.
--
S. Anthony Sequeira
++
As usual, this being a 1.3.x release, I haven't even compiled this
kernel yet. So if it works, you should be doubly impressed.
(Linus Torvalds, announcing kernel 1.3.3 on the linux-kernel mailing list.)
++
From: Robert Klemme on 21 Mar 2010 14:12
On 03/21/2010 06:46 PM, Tony Sequeira wrote:
> GhostBuck wrote:
>> In SQL I am able to select a field as something else. I will use this
>> in generic function for naming grid columns readable to the user.
>>
>> e.g. Select bdate as [Date of Birth] from ....
>>
>> Oracle via ADO does not seem to like the [] around the "AS" name. How
>> would I accomplish this in Oracle?
>
> Try with double quotes, so:
>
> Select bdate as "[Date of Birth]" from ....
>
> May help. Know nothing about ADO, pardon if this has been tried and
> discarded.

I believe double quotes are quite standard in SQL land. So my first
choice would be

Select bdate as "Date of Birth" from ....

Kind regards

robert


--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
 |  Next  |  Last
Pages: 1 2
Prev: How do oracle programmers send batches of SQL from inside a program?
Next: Future of Oracle RDBMS?