Syntax check

[intp]

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

[TwoProc · Accepted solution]

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?

[intp]

Thanks.Worked.

Test environment has same replica of data as in production.

Thanks once again.

[Arturo Galbiati]

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