| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA Reference Manual |
![[-]](/dwicons/i_colpse.gif)
| Chapter 6: SQL Language Elements |
Chapter 6
This chapter presents detailed descriptions of the language elements and conventions of SQL.
|
| Keywords |
| Reserved words |
| Identifiers |
| Strings |
|
| Expressions |
| Constants in expressions |
| Column names in expressions |
| Subqueries in expressions |
![[+]](/dwicons/i_expand.gif)
| SQL Operators |
| IF expressions |
| CASE expressions |
| Java expressions |
|
| Compatibility of expressions |
|
| Search conditions |
| Comparison conditions |
| Subqueries in search conditions |
| ALL or ANY conditions |
| BETWEEN conditions |
| LIKE conditions |
| IN conditions |
| EXISTS conditions |
| IS NULL conditions |
| Conditions with logical operators |
| NOT conditions |
| Truth value conditions |
| Three-valued logic |
| User-supplied estimates |
|
| Special values |
| CURRENT DATE special value |
| CURRENT TIME special value |
| CURRENT TIMESTAMP special value |
| SQLCODE special value |
| SQLSTATE special value |
| CURRENT USER special value |
| CURRENT PUBLISHER special value |
| LAST USER special value |
|
| Variables |
| Local variables |
| Connection-level variables |
| Global variables |
| Comments |
| NULL value |
|
|