SQL Syntax in Rapid SQL by Dan Hotka

Hi!

Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your fingertips when using an IDE tool such as Rapid SQL? Well, the answer is yes…you can have SQL syntax with the click of your mouse! Did you know that Rapid SQL has SQL syntax that you can copy and paste right into your code?

Using the menu items Edit | Paste SQL Syntax…

Check out the options here!

To use these…put the cursor in your code where you want this syntax, then click ‘Paste’ in the lower right corner.

Notice that Oracle can do language conversions! I filled in a few of the options in this syntax.

To get this split…just right click on the output tab and select ‘New Horizontal Tab Group’.

Lets review what else is in here…

I condensed all the groups so they would fit in one screen shot.

I’m impressed with the amount of SQL syntax available here. These options cover almost the entire gambit of SQL syntax (creating most any object, select statements, all the options identified), functions, formatting, XML, optimizer hints and some PL/SQL control syntax. This area contains mostly SQL syntax and its various options.

This option can save a ton of time looking up syntax in the Oracle documentation. I frequently use the date formatting options but can never quite remember the exact syntax. Are you an administrator? Check out all the CREATE syntax options under the SQL commands heading.

I hope this technique helps you in your day-to-day use of Rapid SQL.

Dan Hotka

Oracle ACE Director

Instructor/Author/CEO

Learn more about Rapid SQL | Try Rapid SQL Free! | Contact Us