Skip to main content



      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 02:07 Go to next message
Eclipse UserFriend
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 17:48 Go to previous messageGo to next message
Eclipse UserFriend
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 02:55 Go to previous message
Eclipse UserFriend
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: Wed Jul 23 14:16:13 EDT 2025

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

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

Back to the top