Search This Blog

Wednesday, March 2, 2011

Oracle Variable Syntax for TOAD tool - tip

I have been working extensively with TOAD for Oracle on a current project and have just found something that I have been looking for, variable syntax for TOAD. If you are lucky and get to develop on SQL Server, you have it easy, like I once did. Now, Oracle is a pain-in-the-butt, hardcore. If you need to ever run Oracle SQL in TOAD, here is an easy tip for the variable syntax. Use your standard SQL code like following:

If you are in TOAD, then when you execute this you should get a popup like the following:

Pretty cool, huh?

Hope this helps!

No comments: