SQL Builder to produce "As"-less alias? [message #631526] |
Thu, 07 October 2010 16:22  |
Eclipse User |
|
|
|
I'm using the DTP SQL builder and ran into a problem. If I have an existing sql statement with table alias
Select *
From Employee E
And I edit it in the SQL builder, the keyword AS will be inserted after the edit, so I get
Select *
From Employee AS E
Does the SQL builder has a switch to make AS-less alias?
Thanks!
|
|
|
|
|
Re: SQL Builder to produce "As"-less alias? [message #632927 is a reply to message #632671] |
Thu, 14 October 2010 12:58  |
Eclipse User |
|
|
|
Well, if you are set up to build DTP, you can apply the patch in bug
319927 to the plugin org.eclipse.datatools.sqltools.sqlbuilder. It will
probably apply to the 1.6.2 version without a problem.
I can't think of much else that would fix the problem in 1.6.2.
On 10/13/2010 1:14 PM, chauncey wrote:
> Brian,
> I'm using version 1.6.2, and unfortunately I'm not able to upgrade at
> this moment. Is there a workaround I can opt for?
> Yup, Oracle database is what's causing all these.
>
> Great you have a solution in 1.8.1 though.
|
|
|
Powered by
FUDForum. Page generated in 0.26946 seconds