SQL Syntax in Rapid SQL by Dan Hotka

by Sep 23, 2014

Abstract: Guest blog post from Dan Hotka, Oracle ACE

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.


Click to see full-sized image

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


Click to see full-sized image

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

Dan Hotka is a training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, and over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well-published with12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.