topic Re: Syntax check in Operating System - HP-UX

Syntax check

intp — Mon, 22 May 2006 11:03:00 GMT

Hi,

I have a huge query (runs to 2-3 pages) and this query runs for 3-4 hours in production.
I have made few changes and want to make sure
i havent introduced any syntax issues.

So i want to know a way in which i can check the syntax is proper and at this point really dont want to run the query.

I have Toad 6.3.11.1 g and SQLPlus. But i dont have enough priviledges like checking explain plan,view session info etc..

Pls HELP..THANKS

Re: Syntax check

TwoProc — Mon, 22 May 2006 13:07:48 GMT

Hit the little "ambulance" icon on your toad screen while you have the code in the sql editor window. This of course gives you the cost of the query, but if there is a syntax error in the sql-code, it can't give you the cost. Therefore, if you get a cost, you don't have a syntax error.

However, what you are asking for is the very purpose of test systems - why don't you run and test the query in a test environment first?

Re: Syntax check

intp — Mon, 22 May 2006 14:01:28 GMT

Thanks.Worked.

Test environment has same replica of data as in production.

Thanks once again.

Re: Syntax check

Arturo Galbiati — Tue, 23 May 2006 03:59:05 GMT

HI,
copy and paste you SQL query here:
http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

This will format bfor you the query.
Having a query well written will help you a lot to check syntax

HTH,
Art