Try OpenEdge Now
skip to main content
SQL Development
Preface : Examples of syntax diagrams (SQL)
 

Examples of syntax diagrams (SQL)

In this example, GRANT, RESOURCE, DBA, and TO are keywords. You must specify RESOURCE, DBA, or both, and at least one user_name. Optionally you can specify additional user_name items; each subsequent user_name must be preceded by a comma:

GRANT { RESOURCE, DBA } TO user_name[, user_name]... ;
This excerpt from an ODBC application invokes a stored procedure using the ODBC syntax {callprocedure_name( param ) }, where braces and parentheses are part of the language:

proc1( param, "{ call proc2 (param) }", param);
In this example, you must specify a table_name, view_name, or synonym, but you can choose only one. In all SQL syntax, if you specify the optional owner_name qualifier, there must not be a space between the period separator and table_name, view_name, or synonym:

CREATE [ PUBLIC ] SYNONYM synonym
  FOR [ owner_name.]{table_name|view_name |synonym} ;
In this example, you must specify table_name or view_name:

DELETE FROM [ owner_name.]{table_name |view_name }  [ WHERE search_condition] ;
In this example, you must include one expression (expr) or column position (posn), and optionally you can specify the sort order as ascending (ASC) or descending (DESC). You can specify additional expressions or column positions for sorting within a sorted result set. The SQL engine orders the rows on the basis of the first expr or posn. If the values are the same, the second expr or posn is used in the ordering:

ORDER BY {expr|posn}[ ASC | DESC ]  [ , [{expr|posn}[ ASC | DESC ]]...]
* Long SQL syntax descriptions split across lines