Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Syntax check

SOLVED
Go to solution
intp
Frequent Advisor

Syntax check

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
3 REPLIES
TwoProc
Honored Contributor
Solution

Re: Syntax check

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?
We are the people our parents warned us about --Jimmy Buffett
intp
Frequent Advisor

Re: Syntax check

Thanks.Worked.

Test environment has same replica of data as in production.

Thanks once again.
Arturo Galbiati
Esteemed Contributor

Re: Syntax check

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