Home » SQL & PL/SQL » Client Tools » Tool to do syntax check on DML/DDL (Oracle 10g)
Tool to do syntax check on DML/DDL [message #290712] Mon, 31 December 2007 03:50 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Is there any tool in Toad or SQL Plus or any other IDE to do a syntax check on DDL/DML statements without executing them ?
Re: Tool to do syntax check on DML/DDL [message #290717 is a reply to message #290712] Mon, 31 December 2007 04:25 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Formatter Plus" by Quest Software is one of them. Or, you could use Online SQL and PL/SQL Formatter on this very site.
Re: Tool to do syntax check on DML/DDL [message #290719 is a reply to message #290717] Mon, 31 December 2007 04:34 Go to previous messageGo to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Thanks, but does that do sysntax checking too apart from formatting ?
Re: Tool to do syntax check on DML/DDL [message #290721 is a reply to message #290712] Mon, 31 December 2007 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For a DML statement, try to execute an explain plan.
Otherwise, there is no tool.

Regards
Michel
Re: Tool to do syntax check on DML/DDL [message #290740 is a reply to message #290719] Mon, 31 December 2007 06:00 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See for yourself:

./fa/3665/0/
Previous Topic: sqlplus table output
Next Topic: I can't get BREAK to work
Goto Forum:
  


Current Time: Wed Dec 07 16:51:21 CST 2016

Total time taken to generate the page: 0.13768 seconds