Paste SQL Syntax

From RapidSQL
Jump to: navigation, search

Go Up to Automated Error Detection and Coding Aid Features

The Paste SQL Syntax facility lets you paste syntax for SQL statements, system functions calls, and other commonly used elements into an SQL Editor.

at16fb43.jpg

Once pasted into the SQL Editor, placeholders can be replaced with values specific to your implementation. The following table lists the categories of elements for which syntax is available for pasting on a DBMS-by-DBMS basis.

DB2 LUW DB2 z/OS MySQL ORCL PSTGRS SQL SVR SYB ASE SYB IQ

Aggregate Functions

Analytical Functions

Character Functions

Column Functions

Conversion Functions

Datatype Conversion Functions

Date/Time Functions

Encryption Functions

Group Functions

HTTP Functions

Mathematical and Number/Numeric Functions

Optimizer Hints

Other/Miscellaneous Functions (User, NVL, etc.)

Scalar Functions

SQL Commands

String Functions

System Functions

System Diagnostics

Text/Image Functions

Time Series Functions

To paste SQL Syntax for an element into an SQL Editor

  1. Open a SQL Editor against the DBMS platform you want work against. For details, see Coding Environments/Editors.
  2. Place the cursor where you want to paste the SQL syntax.
  3. Select Edit > Paste SQL Syntax.
  4. In SQL Statements, select the element (such as an SQL statement or system function call) you want to paste. The syntax for the selected element is displayed in the Syntax pane.
  5. Click Paste.
Note: For information on generating and pasting complete SELECT, INSERT, UPDATE, or DELETE statements, see Paste SQL Statements.