OraFAQ Forum: Client Tools » Tool to do syntax check on DML/DDL

Home » Other » Client Tools » Tool to do syntax check on DML/DDL (Oracle 10g)

Mon, 31 December 2007 03:50

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 ?

Mon, 31 December 2007 04:25

Littlefoot
Messages: 21823
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.

Mon, 31 December 2007 04:34

hidnana
Messages: 87
Registered: November 2007
Location: chennai

Member

Thanks, but does that do sysntax checking too apart from formatting ?

Mon, 31 December 2007 04:38

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For a DML statement, try to execute an explain plan.
Otherwise, there is no tool.

Regards
Michel

Mon, 31 December 2007 06:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

See for yourself:

/forum/fa/3665/0/

Previous Topic:	sqlplus table output
Next Topic:	I can't get BREAK to work

Goto Forum:

]

Current Time: Fri Jan 03 08:02:19 CST 2025