Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL scrapbook parse Oracle SQL and tell where there is an error?
SQL scrapbook parse Oracle SQL and tell where there is an error? [message #709645] Thu, 04 August 2011 06:07 Go to next message
Brian Lavender is currently offline Brian LavenderFriend
Messages: 12
Registered: July 2009
Junior Member
Is it possible for the SQL scrapbook to tell where I am missing an end parenthesis or that my query is not well constructed? I am writing queries for Oracle. Right now, it will prompt table names and column names and do syntax highlighting.
Re: SQL scrapbook parse Oracle SQL and tell where there is an error? [message #733501 is a reply to message #709645] Tue, 04 October 2011 21:48 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
Registered: July 2009
Senior Member
Unfortunately DTP doesn't have a syntax parser for Oracle SQL. Creating
an Oracle parser would take a serious amount of time and Oracle
expertise that isn't currently available to the project.

On 8/3/2011 11:07 PM, Brian Lavender wrote:
> Is it possible for the SQL scrapbook to tell where I am missing an end
> parenthesis or that my query is not well constructed? I am writing
> queries for Oracle. Right now, it will prompt table names and column
> names and do syntax highlighting.
Re: SQL scrapbook parse Oracle SQL and tell where there is an error? [message #1445237 is a reply to message #733501] Wed, 15 October 2014 06:55 Go to previous message
LV Frank is currently offline LV FrankFriend
Messages: 3
Registered: October 2014
Junior Member
Hi,Brian! Now,I met the same problem in use DTP to parse SQL that contained specific database syntax like TOP(MS SQL keyword).

And I know that several DTP committers have moved on to other things over the past few years, so the project is short-staffed and didn't to create parsers for specific DB.
But could the project team be able to provide some detailed documentation to guide developers to extend their stuff.

Brian Payton wrote on Tue, 04 October 2011 21:48
Unfortunately DTP doesn't have a syntax parser for Oracle SQL. Creating
an Oracle parser would take a serious amount of time and Oracle
expertise that isn't currently available to the project.

On 8/3/2011 11:07 PM, Brian Lavender wrote:
> Is it possible for the SQL scrapbook to tell where I am missing an end
> parenthesis or that my query is not well constructed? I am writing
> queries for Oracle. Right now, it will prompt table names and column
> names and do syntax highlighting.

Previous Topic:SQL Query Parser - standalone, db2 plugin?
Next Topic:Can't view Oracle packages in Data Sources Explorer
Goto Forum:
  


Current Time: Mon Nov 24 00:29:05 GMT 2014

Powered by FUDForum. Page generated in 0.02383 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software