1<tbody>
2 <row>
3  <entry>B012</entry>
4  <entry></entry>
5  <entry>Embedded C</entry>
6  <entry></entry>
7 </row>
8 <row>
9  <entry>B021</entry>
10  <entry></entry>
11  <entry>Direct SQL</entry>
12  <entry></entry>
13 </row>
14 <row>
15  <entry>E011</entry>
16  <entry>Core</entry>
17  <entry>Numeric data types</entry>
18  <entry></entry>
19 </row>
20 <row>
21  <entry>E011-01</entry>
22  <entry>Core</entry>
23  <entry>INTEGER and SMALLINT data types</entry>
24  <entry></entry>
25 </row>
26 <row>
27  <entry>E011-02</entry>
28  <entry>Core</entry>
29  <entry>REAL, DOUBLE PRECISION, and FLOAT data types</entry>
30  <entry></entry>
31 </row>
32 <row>
33  <entry>E011-03</entry>
34  <entry>Core</entry>
35  <entry>DECIMAL and NUMERIC data types</entry>
36  <entry></entry>
37 </row>
38 <row>
39  <entry>E011-04</entry>
40  <entry>Core</entry>
41  <entry>Arithmetic operators</entry>
42  <entry></entry>
43 </row>
44 <row>
45  <entry>E011-05</entry>
46  <entry>Core</entry>
47  <entry>Numeric comparison</entry>
48  <entry></entry>
49 </row>
50 <row>
51  <entry>E011-06</entry>
52  <entry>Core</entry>
53  <entry>Implicit casting among the numeric data types</entry>
54  <entry></entry>
55 </row>
56 <row>
57  <entry>E021</entry>
58  <entry>Core</entry>
59  <entry>Character data types</entry>
60  <entry></entry>
61 </row>
62 <row>
63  <entry>E021-01</entry>
64  <entry>Core</entry>
65  <entry>CHARACTER data type</entry>
66  <entry></entry>
67 </row>
68 <row>
69  <entry>E021-02</entry>
70  <entry>Core</entry>
71  <entry>CHARACTER VARYING data type</entry>
72  <entry></entry>
73 </row>
74 <row>
75  <entry>E021-03</entry>
76  <entry>Core</entry>
77  <entry>Character literals</entry>
78  <entry></entry>
79 </row>
80 <row>
81  <entry>E021-04</entry>
82  <entry>Core</entry>
83  <entry>CHARACTER_LENGTH function</entry>
84  <entry>trims trailing spaces from CHARACTER values before counting</entry>
85 </row>
86 <row>
87  <entry>E021-05</entry>
88  <entry>Core</entry>
89  <entry>OCTET_LENGTH function</entry>
90  <entry></entry>
91 </row>
92 <row>
93  <entry>E021-06</entry>
94  <entry>Core</entry>
95  <entry>SUBSTRING function</entry>
96  <entry></entry>
97 </row>
98 <row>
99  <entry>E021-07</entry>
100  <entry>Core</entry>
101  <entry>Character concatenation</entry>
102  <entry></entry>
103 </row>
104 <row>
105  <entry>E021-08</entry>
106  <entry>Core</entry>
107  <entry>UPPER and LOWER functions</entry>
108  <entry></entry>
109 </row>
110 <row>
111  <entry>E021-09</entry>
112  <entry>Core</entry>
113  <entry>TRIM function</entry>
114  <entry></entry>
115 </row>
116 <row>
117  <entry>E021-10</entry>
118  <entry>Core</entry>
119  <entry>Implicit casting among the character string types</entry>
120  <entry></entry>
121 </row>
122 <row>
123  <entry>E021-11</entry>
124  <entry>Core</entry>
125  <entry>POSITION function</entry>
126  <entry></entry>
127 </row>
128 <row>
129  <entry>E021-12</entry>
130  <entry>Core</entry>
131  <entry>Character comparison</entry>
132  <entry></entry>
133 </row>
134 <row>
135  <entry>E031</entry>
136  <entry>Core</entry>
137  <entry>Identifiers</entry>
138  <entry></entry>
139 </row>
140 <row>
141  <entry>E031-01</entry>
142  <entry>Core</entry>
143  <entry>Delimited identifiers</entry>
144  <entry></entry>
145 </row>
146 <row>
147  <entry>E031-02</entry>
148  <entry>Core</entry>
149  <entry>Lower case identifiers</entry>
150  <entry></entry>
151 </row>
152 <row>
153  <entry>E031-03</entry>
154  <entry>Core</entry>
155  <entry>Trailing underscore</entry>
156  <entry></entry>
157 </row>
158 <row>
159  <entry>E051</entry>
160  <entry>Core</entry>
161  <entry>Basic query specification</entry>
162  <entry></entry>
163 </row>
164 <row>
165  <entry>E051-01</entry>
166  <entry>Core</entry>
167  <entry>SELECT DISTINCT</entry>
168  <entry></entry>
169 </row>
170 <row>
171  <entry>E051-02</entry>
172  <entry>Core</entry>
173  <entry>GROUP BY clause</entry>
174  <entry></entry>
175 </row>
176 <row>
177  <entry>E051-04</entry>
178  <entry>Core</entry>
179  <entry>GROUP BY can contain columns not in &lt;select list&gt;</entry>
180  <entry></entry>
181 </row>
182 <row>
183  <entry>E051-05</entry>
184  <entry>Core</entry>
185  <entry>Select list items can be renamed</entry>
186  <entry></entry>
187 </row>
188 <row>
189  <entry>E051-06</entry>
190  <entry>Core</entry>
191  <entry>HAVING clause</entry>
192  <entry></entry>
193 </row>
194 <row>
195  <entry>E051-07</entry>
196  <entry>Core</entry>
197  <entry>Qualified * in select list</entry>
198  <entry></entry>
199 </row>
200 <row>
201  <entry>E051-08</entry>
202  <entry>Core</entry>
203  <entry>Correlation names in the FROM clause</entry>
204  <entry></entry>
205 </row>
206 <row>
207  <entry>E051-09</entry>
208  <entry>Core</entry>
209  <entry>Rename columns in the FROM clause</entry>
210  <entry></entry>
211 </row>
212 <row>
213  <entry>E061</entry>
214  <entry>Core</entry>
215  <entry>Basic predicates and search conditions</entry>
216  <entry></entry>
217 </row>
218 <row>
219  <entry>E061-01</entry>
220  <entry>Core</entry>
221  <entry>Comparison predicate</entry>
222  <entry></entry>
223 </row>
224 <row>
225  <entry>E061-02</entry>
226  <entry>Core</entry>
227  <entry>BETWEEN predicate</entry>
228  <entry></entry>
229 </row>
230 <row>
231  <entry>E061-03</entry>
232  <entry>Core</entry>
233  <entry>IN predicate with list of values</entry>
234  <entry></entry>
235 </row>
236 <row>
237  <entry>E061-04</entry>
238  <entry>Core</entry>
239  <entry>LIKE predicate</entry>
240  <entry></entry>
241 </row>
242 <row>
243  <entry>E061-05</entry>
244  <entry>Core</entry>
245  <entry>LIKE predicate ESCAPE clause</entry>
246  <entry></entry>
247 </row>
248 <row>
249  <entry>E061-06</entry>
250  <entry>Core</entry>
251  <entry>NULL predicate</entry>
252  <entry></entry>
253 </row>
254 <row>
255  <entry>E061-07</entry>
256  <entry>Core</entry>
257  <entry>Quantified comparison predicate</entry>
258  <entry></entry>
259 </row>
260 <row>
261  <entry>E061-08</entry>
262  <entry>Core</entry>
263  <entry>EXISTS predicate</entry>
264  <entry></entry>
265 </row>
266 <row>
267  <entry>E061-09</entry>
268  <entry>Core</entry>
269  <entry>Subqueries in comparison predicate</entry>
270  <entry></entry>
271 </row>
272 <row>
273  <entry>E061-11</entry>
274  <entry>Core</entry>
275  <entry>Subqueries in IN predicate</entry>
276  <entry></entry>
277 </row>
278 <row>
279  <entry>E061-12</entry>
280  <entry>Core</entry>
281  <entry>Subqueries in quantified comparison predicate</entry>
282  <entry></entry>
283 </row>
284 <row>
285  <entry>E061-13</entry>
286  <entry>Core</entry>
287  <entry>Correlated subqueries</entry>
288  <entry></entry>
289 </row>
290 <row>
291  <entry>E061-14</entry>
292  <entry>Core</entry>
293  <entry>Search condition</entry>
294  <entry></entry>
295 </row>
296 <row>
297  <entry>E071</entry>
298  <entry>Core</entry>
299  <entry>Basic query expressions</entry>
300  <entry></entry>
301 </row>
302 <row>
303  <entry>E071-01</entry>
304  <entry>Core</entry>
305  <entry>UNION DISTINCT table operator</entry>
306  <entry></entry>
307 </row>
308 <row>
309  <entry>E071-02</entry>
310  <entry>Core</entry>
311  <entry>UNION ALL table operator</entry>
312  <entry></entry>
313 </row>
314 <row>
315  <entry>E071-03</entry>
316  <entry>Core</entry>
317  <entry>EXCEPT DISTINCT table operator</entry>
318  <entry></entry>
319 </row>
320 <row>
321  <entry>E071-05</entry>
322  <entry>Core</entry>
323  <entry>Columns combined via table operators need not have exactly the same data type</entry>
324  <entry></entry>
325 </row>
326 <row>
327  <entry>E071-06</entry>
328  <entry>Core</entry>
329  <entry>Table operators in subqueries</entry>
330  <entry></entry>
331 </row>
332 <row>
333  <entry>E081</entry>
334  <entry>Core</entry>
335  <entry>Basic Privileges</entry>
336  <entry></entry>
337 </row>
338 <row>
339  <entry>E081-01</entry>
340  <entry>Core</entry>
341  <entry>SELECT privilege</entry>
342  <entry></entry>
343 </row>
344 <row>
345  <entry>E081-02</entry>
346  <entry>Core</entry>
347  <entry>DELETE privilege</entry>
348  <entry></entry>
349 </row>
350 <row>
351  <entry>E081-03</entry>
352  <entry>Core</entry>
353  <entry>INSERT privilege at the table level</entry>
354  <entry></entry>
355 </row>
356 <row>
357  <entry>E081-04</entry>
358  <entry>Core</entry>
359  <entry>UPDATE privilege at the table level</entry>
360  <entry></entry>
361 </row>
362 <row>
363  <entry>E081-05</entry>
364  <entry>Core</entry>
365  <entry>UPDATE privilege at the column level</entry>
366  <entry></entry>
367 </row>
368 <row>
369  <entry>E081-06</entry>
370  <entry>Core</entry>
371  <entry>REFERENCES privilege at the table level</entry>
372  <entry></entry>
373 </row>
374 <row>
375  <entry>E081-07</entry>
376  <entry>Core</entry>
377  <entry>REFERENCES privilege at the column level</entry>
378  <entry></entry>
379 </row>
380 <row>
381  <entry>E081-08</entry>
382  <entry>Core</entry>
383  <entry>WITH GRANT OPTION</entry>
384  <entry></entry>
385 </row>
386 <row>
387  <entry>E081-09</entry>
388  <entry>Core</entry>
389  <entry>USAGE privilege</entry>
390  <entry></entry>
391 </row>
392 <row>
393  <entry>E081-10</entry>
394  <entry>Core</entry>
395  <entry>EXECUTE privilege</entry>
396  <entry></entry>
397 </row>
398 <row>
399  <entry>E091</entry>
400  <entry>Core</entry>
401  <entry>Set functions</entry>
402  <entry></entry>
403 </row>
404 <row>
405  <entry>E091-01</entry>
406  <entry>Core</entry>
407  <entry>AVG</entry>
408  <entry></entry>
409 </row>
410 <row>
411  <entry>E091-02</entry>
412  <entry>Core</entry>
413  <entry>COUNT</entry>
414  <entry></entry>
415 </row>
416 <row>
417  <entry>E091-03</entry>
418  <entry>Core</entry>
419  <entry>MAX</entry>
420  <entry></entry>
421 </row>
422 <row>
423  <entry>E091-04</entry>
424  <entry>Core</entry>
425  <entry>MIN</entry>
426  <entry></entry>
427 </row>
428 <row>
429  <entry>E091-05</entry>
430  <entry>Core</entry>
431  <entry>SUM</entry>
432  <entry></entry>
433 </row>
434 <row>
435  <entry>E091-06</entry>
436  <entry>Core</entry>
437  <entry>ALL quantifier</entry>
438  <entry></entry>
439 </row>
440 <row>
441  <entry>E091-07</entry>
442  <entry>Core</entry>
443  <entry>DISTINCT quantifier</entry>
444  <entry></entry>
445 </row>
446 <row>
447  <entry>E101</entry>
448  <entry>Core</entry>
449  <entry>Basic data manipulation</entry>
450  <entry></entry>
451 </row>
452 <row>
453  <entry>E101-01</entry>
454  <entry>Core</entry>
455  <entry>INSERT statement</entry>
456  <entry></entry>
457 </row>
458 <row>
459  <entry>E101-03</entry>
460  <entry>Core</entry>
461  <entry>Searched UPDATE statement</entry>
462  <entry></entry>
463 </row>
464 <row>
465  <entry>E101-04</entry>
466  <entry>Core</entry>
467  <entry>Searched DELETE statement</entry>
468  <entry></entry>
469 </row>
470 <row>
471  <entry>E111</entry>
472  <entry>Core</entry>
473  <entry>Single row SELECT statement</entry>
474  <entry></entry>
475 </row>
476 <row>
477  <entry>E121</entry>
478  <entry>Core</entry>
479  <entry>Basic cursor support</entry>
480  <entry></entry>
481 </row>
482 <row>
483  <entry>E121-01</entry>
484  <entry>Core</entry>
485  <entry>DECLARE CURSOR</entry>
486  <entry></entry>
487 </row>
488 <row>
489  <entry>E121-02</entry>
490  <entry>Core</entry>
491  <entry>ORDER BY columns need not be in select list</entry>
492  <entry></entry>
493 </row>
494 <row>
495  <entry>E121-03</entry>
496  <entry>Core</entry>
497  <entry>Value expressions in ORDER BY clause</entry>
498  <entry></entry>
499 </row>
500 <row>
501  <entry>E121-04</entry>
502  <entry>Core</entry>
503  <entry>OPEN statement</entry>
504  <entry></entry>
505 </row>
506 <row>
507  <entry>E121-06</entry>
508  <entry>Core</entry>
509  <entry>Positioned UPDATE statement</entry>
510  <entry></entry>
511 </row>
512 <row>
513  <entry>E121-07</entry>
514  <entry>Core</entry>
515  <entry>Positioned DELETE statement</entry>
516  <entry></entry>
517 </row>
518 <row>
519  <entry>E121-08</entry>
520  <entry>Core</entry>
521  <entry>CLOSE statement</entry>
522  <entry></entry>
523 </row>
524 <row>
525  <entry>E121-10</entry>
526  <entry>Core</entry>
527  <entry>FETCH statement implicit NEXT</entry>
528  <entry></entry>
529 </row>
530 <row>
531  <entry>E121-17</entry>
532  <entry>Core</entry>
533  <entry>WITH HOLD cursors</entry>
534  <entry></entry>
535 </row>
536 <row>
537  <entry>E131</entry>
538  <entry>Core</entry>
539  <entry>Null value support (nulls in lieu of values)</entry>
540  <entry></entry>
541 </row>
542 <row>
543  <entry>E141</entry>
544  <entry>Core</entry>
545  <entry>Basic integrity constraints</entry>
546  <entry></entry>
547 </row>
548 <row>
549  <entry>E141-01</entry>
550  <entry>Core</entry>
551  <entry>NOT NULL constraints</entry>
552  <entry></entry>
553 </row>
554 <row>
555  <entry>E141-02</entry>
556  <entry>Core</entry>
557  <entry>UNIQUE constraints of NOT NULL columns</entry>
558  <entry></entry>
559 </row>
560 <row>
561  <entry>E141-03</entry>
562  <entry>Core</entry>
563  <entry>PRIMARY KEY constraints</entry>
564  <entry></entry>
565 </row>
566 <row>
567  <entry>E141-04</entry>
568  <entry>Core</entry>
569  <entry>Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action</entry>
570  <entry></entry>
571 </row>
572 <row>
573  <entry>E141-06</entry>
574  <entry>Core</entry>
575  <entry>CHECK constraints</entry>
576  <entry></entry>
577 </row>
578 <row>
579  <entry>E141-07</entry>
580  <entry>Core</entry>
581  <entry>Column defaults</entry>
582  <entry></entry>
583 </row>
584 <row>
585  <entry>E141-08</entry>
586  <entry>Core</entry>
587  <entry>NOT NULL inferred on PRIMARY KEY</entry>
588  <entry></entry>
589 </row>
590 <row>
591  <entry>E141-10</entry>
592  <entry>Core</entry>
593  <entry>Names in a foreign key can be specified in any order</entry>
594  <entry></entry>
595 </row>
596 <row>
597  <entry>E151</entry>
598  <entry>Core</entry>
599  <entry>Transaction support</entry>
600  <entry></entry>
601 </row>
602 <row>
603  <entry>E151-01</entry>
604  <entry>Core</entry>
605  <entry>COMMIT statement</entry>
606  <entry></entry>
607 </row>
608 <row>
609  <entry>E151-02</entry>
610  <entry>Core</entry>
611  <entry>ROLLBACK statement</entry>
612  <entry></entry>
613 </row>
614 <row>
615  <entry>E152</entry>
616  <entry>Core</entry>
617  <entry>Basic SET TRANSACTION statement</entry>
618  <entry></entry>
619 </row>
620 <row>
621  <entry>E152-01</entry>
622  <entry>Core</entry>
623  <entry>SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause</entry>
624  <entry></entry>
625 </row>
626 <row>
627  <entry>E152-02</entry>
628  <entry>Core</entry>
629  <entry>SET TRANSACTION statement: READ ONLY and READ WRITE clauses</entry>
630  <entry></entry>
631 </row>
632 <row>
633  <entry>E153</entry>
634  <entry>Core</entry>
635  <entry>Updatable queries with subqueries</entry>
636  <entry></entry>
637 </row>
638 <row>
639  <entry>E161</entry>
640  <entry>Core</entry>
641  <entry>SQL comments using leading double minus</entry>
642  <entry></entry>
643 </row>
644 <row>
645  <entry>E171</entry>
646  <entry>Core</entry>
647  <entry>SQLSTATE support</entry>
648  <entry></entry>
649 </row>
650 <row>
651  <entry>F021</entry>
652  <entry>Core</entry>
653  <entry>Basic information schema</entry>
654  <entry></entry>
655 </row>
656 <row>
657  <entry>F021-01</entry>
658  <entry>Core</entry>
659  <entry>COLUMNS view</entry>
660  <entry></entry>
661 </row>
662 <row>
663  <entry>F021-02</entry>
664  <entry>Core</entry>
665  <entry>TABLES view</entry>
666  <entry></entry>
667 </row>
668 <row>
669  <entry>F021-03</entry>
670  <entry>Core</entry>
671  <entry>VIEWS view</entry>
672  <entry></entry>
673 </row>
674 <row>
675  <entry>F021-04</entry>
676  <entry>Core</entry>
677  <entry>TABLE_CONSTRAINTS view</entry>
678  <entry></entry>
679 </row>
680 <row>
681  <entry>F021-05</entry>
682  <entry>Core</entry>
683  <entry>REFERENTIAL_CONSTRAINTS view</entry>
684  <entry></entry>
685 </row>
686 <row>
687  <entry>F021-06</entry>
688  <entry>Core</entry>
689  <entry>CHECK_CONSTRAINTS view</entry>
690  <entry></entry>
691 </row>
692 <row>
693  <entry>F031</entry>
694  <entry>Core</entry>
695  <entry>Basic schema manipulation</entry>
696  <entry></entry>
697 </row>
698 <row>
699  <entry>F031-01</entry>
700  <entry>Core</entry>
701  <entry>CREATE TABLE statement to create persistent base tables</entry>
702  <entry></entry>
703 </row>
704 <row>
705  <entry>F031-02</entry>
706  <entry>Core</entry>
707  <entry>CREATE VIEW statement</entry>
708  <entry></entry>
709 </row>
710 <row>
711  <entry>F031-03</entry>
712  <entry>Core</entry>
713  <entry>GRANT statement</entry>
714  <entry></entry>
715 </row>
716 <row>
717  <entry>F031-04</entry>
718  <entry>Core</entry>
719  <entry>ALTER TABLE statement: ADD COLUMN clause</entry>
720  <entry></entry>
721 </row>
722 <row>
723  <entry>F031-13</entry>
724  <entry>Core</entry>
725  <entry>DROP TABLE statement: RESTRICT clause</entry>
726  <entry></entry>
727 </row>
728 <row>
729  <entry>F031-16</entry>
730  <entry>Core</entry>
731  <entry>DROP VIEW statement: RESTRICT clause</entry>
732  <entry></entry>
733 </row>
734 <row>
735  <entry>F031-19</entry>
736  <entry>Core</entry>
737  <entry>REVOKE statement: RESTRICT clause</entry>
738  <entry></entry>
739 </row>
740 <row>
741  <entry>F032</entry>
742  <entry></entry>
743  <entry>CASCADE drop behavior</entry>
744  <entry></entry>
745 </row>
746 <row>
747  <entry>F033</entry>
748  <entry></entry>
749  <entry>ALTER TABLE statement: DROP COLUMN clause</entry>
750  <entry></entry>
751 </row>
752 <row>
753  <entry>F034</entry>
754  <entry></entry>
755  <entry>Extended REVOKE statement</entry>
756  <entry></entry>
757 </row>
758 <row>
759  <entry>F034-01</entry>
760  <entry></entry>
761  <entry>REVOKE statement performed by other than the owner of a schema object</entry>
762  <entry></entry>
763 </row>
764 <row>
765  <entry>F034-02</entry>
766  <entry></entry>
767  <entry>REVOKE statement: GRANT OPTION FOR clause</entry>
768  <entry></entry>
769 </row>
770 <row>
771  <entry>F034-03</entry>
772  <entry></entry>
773  <entry>REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION</entry>
774  <entry></entry>
775 </row>
776 <row>
777  <entry>F041</entry>
778  <entry>Core</entry>
779  <entry>Basic joined table</entry>
780  <entry></entry>
781 </row>
782 <row>
783  <entry>F041-01</entry>
784  <entry>Core</entry>
785  <entry>Inner join (but not necessarily the INNER keyword)</entry>
786  <entry></entry>
787 </row>
788 <row>
789  <entry>F041-02</entry>
790  <entry>Core</entry>
791  <entry>INNER keyword</entry>
792  <entry></entry>
793 </row>
794 <row>
795  <entry>F041-03</entry>
796  <entry>Core</entry>
797  <entry>LEFT OUTER JOIN</entry>
798  <entry></entry>
799 </row>
800 <row>
801  <entry>F041-04</entry>
802  <entry>Core</entry>
803  <entry>RIGHT OUTER JOIN</entry>
804  <entry></entry>
805 </row>
806 <row>
807  <entry>F041-05</entry>
808  <entry>Core</entry>
809  <entry>Outer joins can be nested</entry>
810  <entry></entry>
811 </row>
812 <row>
813  <entry>F041-07</entry>
814  <entry>Core</entry>
815  <entry>The inner table in a left or right outer join can also be used in an inner join</entry>
816  <entry></entry>
817 </row>
818 <row>
819  <entry>F041-08</entry>
820  <entry>Core</entry>
821  <entry>All comparison operators are supported (rather than just =)</entry>
822  <entry></entry>
823 </row>
824 <row>
825  <entry>F051</entry>
826  <entry>Core</entry>
827  <entry>Basic date and time</entry>
828  <entry></entry>
829 </row>
830 <row>
831  <entry>F051-01</entry>
832  <entry>Core</entry>
833  <entry>DATE data type (including support of DATE literal)</entry>
834  <entry></entry>
835 </row>
836 <row>
837  <entry>F051-02</entry>
838  <entry>Core</entry>
839  <entry>TIME data type (including support of TIME literal) with fractional seconds precision of at least 0</entry>
840  <entry></entry>
841 </row>
842 <row>
843  <entry>F051-03</entry>
844  <entry>Core</entry>
845  <entry>TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6</entry>
846  <entry></entry>
847 </row>
848 <row>
849  <entry>F051-04</entry>
850  <entry>Core</entry>
851  <entry>Comparison predicate on DATE, TIME, and TIMESTAMP data types</entry>
852  <entry></entry>
853 </row>
854 <row>
855  <entry>F051-05</entry>
856  <entry>Core</entry>
857  <entry>Explicit CAST between datetime types and character string types</entry>
858  <entry></entry>
859 </row>
860 <row>
861  <entry>F051-06</entry>
862  <entry>Core</entry>
863  <entry>CURRENT_DATE</entry>
864  <entry></entry>
865 </row>
866 <row>
867  <entry>F051-07</entry>
868  <entry>Core</entry>
869  <entry>LOCALTIME</entry>
870  <entry></entry>
871 </row>
872 <row>
873  <entry>F051-08</entry>
874  <entry>Core</entry>
875  <entry>LOCALTIMESTAMP</entry>
876  <entry></entry>
877 </row>
878 <row>
879  <entry>F052</entry>
880  <entry>Enhanced datetime facilities</entry>
881  <entry>Intervals and datetime arithmetic</entry>
882  <entry></entry>
883 </row>
884 <row>
885  <entry>F053</entry>
886  <entry></entry>
887  <entry>OVERLAPS predicate</entry>
888  <entry></entry>
889 </row>
890 <row>
891  <entry>F081</entry>
892  <entry>Core</entry>
893  <entry>UNION and EXCEPT in views</entry>
894  <entry></entry>
895 </row>
896 <row>
897  <entry>F111</entry>
898  <entry></entry>
899  <entry>Isolation levels other than SERIALIZABLE</entry>
900  <entry></entry>
901 </row>
902 <row>
903  <entry>F111-01</entry>
904  <entry></entry>
905  <entry>READ UNCOMMITTED isolation level</entry>
906  <entry></entry>
907 </row>
908 <row>
909  <entry>F111-02</entry>
910  <entry></entry>
911  <entry>READ COMMITTED isolation level</entry>
912  <entry></entry>
913 </row>
914 <row>
915  <entry>F111-03</entry>
916  <entry></entry>
917  <entry>REPEATABLE READ isolation level</entry>
918  <entry></entry>
919 </row>
920 <row>
921  <entry>F131</entry>
922  <entry>Core</entry>
923  <entry>Grouped operations</entry>
924  <entry></entry>
925 </row>
926 <row>
927  <entry>F131-01</entry>
928  <entry>Core</entry>
929  <entry>WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views</entry>
930  <entry></entry>
931 </row>
932 <row>
933  <entry>F131-02</entry>
934  <entry>Core</entry>
935  <entry>Multiple tables supported in queries with grouped views</entry>
936  <entry></entry>
937 </row>
938 <row>
939  <entry>F131-03</entry>
940  <entry>Core</entry>
941  <entry>Set functions supported in queries with grouped views</entry>
942  <entry></entry>
943 </row>
944 <row>
945  <entry>F131-04</entry>
946  <entry>Core</entry>
947  <entry>Subqueries with GROUP BY and HAVING clauses and grouped views</entry>
948  <entry></entry>
949 </row>
950 <row>
951  <entry>F131-05</entry>
952  <entry>Core</entry>
953  <entry>Single row SELECT with GROUP BY and HAVING clauses and grouped views</entry>
954  <entry></entry>
955 </row>
956 <row>
957  <entry>F171</entry>
958  <entry></entry>
959  <entry>Multiple schemas per user</entry>
960  <entry></entry>
961 </row>
962 <row>
963  <entry>F191</entry>
964  <entry>Enhanced integrity management</entry>
965  <entry>Referential delete actions</entry>
966  <entry></entry>
967 </row>
968 <row>
969  <entry>F200</entry>
970  <entry></entry>
971  <entry>TRUNCATE TABLE statement</entry>
972  <entry></entry>
973 </row>
974 <row>
975  <entry>F201</entry>
976  <entry>Core</entry>
977  <entry>CAST function</entry>
978  <entry></entry>
979 </row>
980 <row>
981  <entry>F221</entry>
982  <entry>Core</entry>
983  <entry>Explicit defaults</entry>
984  <entry></entry>
985 </row>
986 <row>
987  <entry>F222</entry>
988  <entry></entry>
989  <entry>INSERT statement: DEFAULT VALUES clause</entry>
990  <entry></entry>
991 </row>
992 <row>
993  <entry>F231</entry>
994  <entry></entry>
995  <entry>Privilege tables</entry>
996  <entry></entry>
997 </row>
998 <row>
999  <entry>F231-01</entry>
1000  <entry></entry>
1001  <entry>TABLE_PRIVILEGES view</entry>
1002  <entry></entry>
1003 </row>
1004 <row>
1005  <entry>F231-02</entry>
1006  <entry></entry>
1007  <entry>COLUMN_PRIVILEGES view</entry>
1008  <entry></entry>
1009 </row>
1010 <row>
1011  <entry>F231-03</entry>
1012  <entry></entry>
1013  <entry>USAGE_PRIVILEGES view</entry>
1014  <entry></entry>
1015 </row>
1016 <row>
1017  <entry>F251</entry>
1018  <entry></entry>
1019  <entry>Domain support</entry>
1020  <entry></entry>
1021 </row>
1022 <row>
1023  <entry>F261</entry>
1024  <entry>Core</entry>
1025  <entry>CASE expression</entry>
1026  <entry></entry>
1027 </row>
1028 <row>
1029  <entry>F261-01</entry>
1030  <entry>Core</entry>
1031  <entry>Simple CASE</entry>
1032  <entry></entry>
1033 </row>
1034 <row>
1035  <entry>F261-02</entry>
1036  <entry>Core</entry>
1037  <entry>Searched CASE</entry>
1038  <entry></entry>
1039 </row>
1040 <row>
1041  <entry>F261-03</entry>
1042  <entry>Core</entry>
1043  <entry>NULLIF</entry>
1044  <entry></entry>
1045 </row>
1046 <row>
1047  <entry>F261-04</entry>
1048  <entry>Core</entry>
1049  <entry>COALESCE</entry>
1050  <entry></entry>
1051 </row>
1052 <row>
1053  <entry>F262</entry>
1054  <entry></entry>
1055  <entry>Extended CASE expression</entry>
1056  <entry></entry>
1057 </row>
1058 <row>
1059  <entry>F271</entry>
1060  <entry></entry>
1061  <entry>Compound character literals</entry>
1062  <entry></entry>
1063 </row>
1064 <row>
1065  <entry>F281</entry>
1066  <entry></entry>
1067  <entry>LIKE enhancements</entry>
1068  <entry></entry>
1069 </row>
1070 <row>
1071  <entry>F302</entry>
1072  <entry></entry>
1073  <entry>INTERSECT table operator</entry>
1074  <entry></entry>
1075 </row>
1076 <row>
1077  <entry>F302-01</entry>
1078  <entry></entry>
1079  <entry>INTERSECT DISTINCT table operator</entry>
1080  <entry></entry>
1081 </row>
1082 <row>
1083  <entry>F302-02</entry>
1084  <entry></entry>
1085  <entry>INTERSECT ALL table operator</entry>
1086  <entry></entry>
1087 </row>
1088 <row>
1089  <entry>F304</entry>
1090  <entry></entry>
1091  <entry>EXCEPT ALL table operator</entry>
1092  <entry></entry>
1093 </row>
1094 <row>
1095  <entry>F311-01</entry>
1096  <entry>Core</entry>
1097  <entry>CREATE SCHEMA</entry>
1098  <entry></entry>
1099 </row>
1100 <row>
1101  <entry>F311-02</entry>
1102  <entry>Core</entry>
1103  <entry>CREATE TABLE for persistent base tables</entry>
1104  <entry></entry>
1105 </row>
1106 <row>
1107  <entry>F311-03</entry>
1108  <entry>Core</entry>
1109  <entry>CREATE VIEW</entry>
1110  <entry></entry>
1111 </row>
1112 <row>
1113  <entry>F311-04</entry>
1114  <entry>Core</entry>
1115  <entry>CREATE VIEW: WITH CHECK OPTION</entry>
1116  <entry></entry>
1117 </row>
1118 <row>
1119  <entry>F311-05</entry>
1120  <entry>Core</entry>
1121  <entry>GRANT statement</entry>
1122  <entry></entry>
1123 </row>
1124 <row>
1125  <entry>F321</entry>
1126  <entry></entry>
1127  <entry>User authorization</entry>
1128  <entry></entry>
1129 </row>
1130 <row>
1131  <entry>F361</entry>
1132  <entry></entry>
1133  <entry>Subprogram support</entry>
1134  <entry></entry>
1135 </row>
1136 <row>
1137  <entry>F381</entry>
1138  <entry></entry>
1139  <entry>Extended schema manipulation</entry>
1140  <entry></entry>
1141 </row>
1142 <row>
1143  <entry>F381-01</entry>
1144  <entry></entry>
1145  <entry>ALTER TABLE statement: ALTER COLUMN clause</entry>
1146  <entry></entry>
1147 </row>
1148 <row>
1149  <entry>F381-02</entry>
1150  <entry></entry>
1151  <entry>ALTER TABLE statement: ADD CONSTRAINT clause</entry>
1152  <entry></entry>
1153 </row>
1154 <row>
1155  <entry>F381-03</entry>
1156  <entry></entry>
1157  <entry>ALTER TABLE statement: DROP CONSTRAINT clause</entry>
1158  <entry></entry>
1159 </row>
1160 <row>
1161  <entry>F382</entry>
1162  <entry></entry>
1163  <entry>Alter column data type</entry>
1164  <entry></entry>
1165 </row>
1166 <row>
1167  <entry>F383</entry>
1168  <entry></entry>
1169  <entry>Set column not null clause</entry>
1170  <entry></entry>
1171 </row>
1172 <row>
1173  <entry>F391</entry>
1174  <entry></entry>
1175  <entry>Long identifiers</entry>
1176  <entry></entry>
1177 </row>
1178 <row>
1179  <entry>F392</entry>
1180  <entry></entry>
1181  <entry>Unicode escapes in identifiers</entry>
1182  <entry></entry>
1183 </row>
1184 <row>
1185  <entry>F393</entry>
1186  <entry></entry>
1187  <entry>Unicode escapes in literals</entry>
1188  <entry></entry>
1189 </row>
1190 <row>
1191  <entry>F401</entry>
1192  <entry></entry>
1193  <entry>Extended joined table</entry>
1194  <entry></entry>
1195 </row>
1196 <row>
1197  <entry>F401-01</entry>
1198  <entry></entry>
1199  <entry>NATURAL JOIN</entry>
1200  <entry></entry>
1201 </row>
1202 <row>
1203  <entry>F401-02</entry>
1204  <entry></entry>
1205  <entry>FULL OUTER JOIN</entry>
1206  <entry></entry>
1207 </row>
1208 <row>
1209  <entry>F401-04</entry>
1210  <entry></entry>
1211  <entry>CROSS JOIN</entry>
1212  <entry></entry>
1213 </row>
1214 <row>
1215  <entry>F402</entry>
1216  <entry></entry>
1217  <entry>Named column joins for LOBs, arrays, and multisets</entry>
1218  <entry></entry>
1219 </row>
1220 <row>
1221  <entry>F411</entry>
1222  <entry>Enhanced datetime facilities</entry>
1223  <entry>Time zone specification</entry>
1224  <entry>differences regarding literal interpretation</entry>
1225 </row>
1226 <row>
1227  <entry>F421</entry>
1228  <entry></entry>
1229  <entry>National character</entry>
1230  <entry></entry>
1231 </row>
1232 <row>
1233  <entry>F431</entry>
1234  <entry></entry>
1235  <entry>Read-only scrollable cursors</entry>
1236  <entry></entry>
1237 </row>
1238 <row>
1239  <entry>F431-01</entry>
1240  <entry></entry>
1241  <entry>FETCH with explicit NEXT</entry>
1242  <entry></entry>
1243 </row>
1244 <row>
1245  <entry>F431-02</entry>
1246  <entry></entry>
1247  <entry>FETCH FIRST</entry>
1248  <entry></entry>
1249 </row>
1250 <row>
1251  <entry>F431-03</entry>
1252  <entry></entry>
1253  <entry>FETCH LAST</entry>
1254  <entry></entry>
1255 </row>
1256 <row>
1257  <entry>F431-04</entry>
1258  <entry></entry>
1259  <entry>FETCH PRIOR</entry>
1260  <entry></entry>
1261 </row>
1262 <row>
1263  <entry>F431-05</entry>
1264  <entry></entry>
1265  <entry>FETCH ABSOLUTE</entry>
1266  <entry></entry>
1267 </row>
1268 <row>
1269  <entry>F431-06</entry>
1270  <entry></entry>
1271  <entry>FETCH RELATIVE</entry>
1272  <entry></entry>
1273 </row>
1274 <row>
1275  <entry>F441</entry>
1276  <entry></entry>
1277  <entry>Extended set function support</entry>
1278  <entry></entry>
1279 </row>
1280 <row>
1281  <entry>F442</entry>
1282  <entry></entry>
1283  <entry>Mixed column references in set functions</entry>
1284  <entry></entry>
1285 </row>
1286 <row>
1287  <entry>F471</entry>
1288  <entry>Core</entry>
1289  <entry>Scalar subquery values</entry>
1290  <entry></entry>
1291 </row>
1292 <row>
1293  <entry>F481</entry>
1294  <entry>Core</entry>
1295  <entry>Expanded NULL predicate</entry>
1296  <entry></entry>
1297 </row>
1298 <row>
1299  <entry>F491</entry>
1300  <entry>Enhanced integrity management</entry>
1301  <entry>Constraint management</entry>
1302  <entry></entry>
1303 </row>
1304 <row>
1305  <entry>F501</entry>
1306  <entry>Core</entry>
1307  <entry>Features and conformance views</entry>
1308  <entry></entry>
1309 </row>
1310 <row>
1311  <entry>F501-01</entry>
1312  <entry>Core</entry>
1313  <entry>SQL_FEATURES view</entry>
1314  <entry></entry>
1315 </row>
1316 <row>
1317  <entry>F501-02</entry>
1318  <entry>Core</entry>
1319  <entry>SQL_SIZING view</entry>
1320  <entry></entry>
1321 </row>
1322 <row>
1323  <entry>F501-03</entry>
1324  <entry>Core</entry>
1325  <entry>SQL_LANGUAGES view</entry>
1326  <entry></entry>
1327 </row>
1328 <row>
1329  <entry>F502</entry>
1330  <entry></entry>
1331  <entry>Enhanced documentation tables</entry>
1332  <entry></entry>
1333 </row>
1334 <row>
1335  <entry>F502-01</entry>
1336  <entry></entry>
1337  <entry>SQL_SIZING_PROFILES view</entry>
1338  <entry></entry>
1339 </row>
1340 <row>
1341  <entry>F502-02</entry>
1342  <entry></entry>
1343  <entry>SQL_IMPLEMENTATION_INFO view</entry>
1344  <entry></entry>
1345 </row>
1346 <row>
1347  <entry>F502-03</entry>
1348  <entry></entry>
1349  <entry>SQL_PACKAGES view</entry>
1350  <entry></entry>
1351 </row>
1352 <row>
1353  <entry>F531</entry>
1354  <entry></entry>
1355  <entry>Temporary tables</entry>
1356  <entry></entry>
1357 </row>
1358 <row>
1359  <entry>F555</entry>
1360  <entry>Enhanced datetime facilities</entry>
1361  <entry>Enhanced seconds precision</entry>
1362  <entry></entry>
1363 </row>
1364 <row>
1365  <entry>F561</entry>
1366  <entry></entry>
1367  <entry>Full value expressions</entry>
1368  <entry></entry>
1369 </row>
1370 <row>
1371  <entry>F571</entry>
1372  <entry></entry>
1373  <entry>Truth value tests</entry>
1374  <entry></entry>
1375 </row>
1376 <row>
1377  <entry>F591</entry>
1378  <entry></entry>
1379  <entry>Derived tables</entry>
1380  <entry></entry>
1381 </row>
1382 <row>
1383  <entry>F611</entry>
1384  <entry></entry>
1385  <entry>Indicator data types</entry>
1386  <entry></entry>
1387 </row>
1388 <row>
1389  <entry>F641</entry>
1390  <entry></entry>
1391  <entry>Row and table constructors</entry>
1392  <entry></entry>
1393 </row>
1394 <row>
1395  <entry>F651</entry>
1396  <entry></entry>
1397  <entry>Catalog name qualifiers</entry>
1398  <entry></entry>
1399 </row>
1400 <row>
1401  <entry>F661</entry>
1402  <entry></entry>
1403  <entry>Simple tables</entry>
1404  <entry></entry>
1405 </row>
1406 <row>
1407  <entry>F672</entry>
1408  <entry></entry>
1409  <entry>Retrospective check constraints</entry>
1410  <entry></entry>
1411 </row>
1412 <row>
1413  <entry>F690</entry>
1414  <entry></entry>
1415  <entry>Collation support</entry>
1416  <entry>but no character set support</entry>
1417 </row>
1418 <row>
1419  <entry>F692</entry>
1420  <entry></entry>
1421  <entry>Extended collation support</entry>
1422  <entry></entry>
1423 </row>
1424 <row>
1425  <entry>F701</entry>
1426  <entry>Enhanced integrity management</entry>
1427  <entry>Referential update actions</entry>
1428  <entry></entry>
1429 </row>
1430 <row>
1431  <entry>F711</entry>
1432  <entry></entry>
1433  <entry>ALTER domain</entry>
1434  <entry></entry>
1435 </row>
1436 <row>
1437  <entry>F731</entry>
1438  <entry></entry>
1439  <entry>INSERT column privileges</entry>
1440  <entry></entry>
1441 </row>
1442 <row>
1443  <entry>F751</entry>
1444  <entry></entry>
1445  <entry>View CHECK enhancements</entry>
1446  <entry></entry>
1447 </row>
1448 <row>
1449  <entry>F761</entry>
1450  <entry></entry>
1451  <entry>Session management</entry>
1452  <entry></entry>
1453 </row>
1454 <row>
1455  <entry>F762</entry>
1456  <entry></entry>
1457  <entry>CURRENT_CATALOG</entry>
1458  <entry></entry>
1459 </row>
1460 <row>
1461  <entry>F763</entry>
1462  <entry></entry>
1463  <entry>CURRENT_SCHEMA</entry>
1464  <entry></entry>
1465 </row>
1466 <row>
1467  <entry>F771</entry>
1468  <entry></entry>
1469  <entry>Connection management</entry>
1470  <entry></entry>
1471 </row>
1472 <row>
1473  <entry>F781</entry>
1474  <entry></entry>
1475  <entry>Self-referencing operations</entry>
1476  <entry></entry>
1477 </row>
1478 <row>
1479  <entry>F791</entry>
1480  <entry></entry>
1481  <entry>Insensitive cursors</entry>
1482  <entry></entry>
1483 </row>
1484 <row>
1485  <entry>F801</entry>
1486  <entry></entry>
1487  <entry>Full set function</entry>
1488  <entry></entry>
1489 </row>
1490 <row>
1491  <entry>F850</entry>
1492  <entry></entry>
1493  <entry>Top-level &lt;order by clause&gt; in &lt;query expression&gt;</entry>
1494  <entry></entry>
1495 </row>
1496 <row>
1497  <entry>F851</entry>
1498  <entry></entry>
1499  <entry>&lt;order by clause&gt; in subqueries</entry>
1500  <entry></entry>
1501 </row>
1502 <row>
1503  <entry>F852</entry>
1504  <entry></entry>
1505  <entry>Top-level &lt;order by clause&gt; in views</entry>
1506  <entry></entry>
1507 </row>
1508 <row>
1509  <entry>F855</entry>
1510  <entry></entry>
1511  <entry>Nested &lt;order by clause&gt; in &lt;query expression&gt;</entry>
1512  <entry></entry>
1513 </row>
1514 <row>
1515  <entry>F856</entry>
1516  <entry></entry>
1517  <entry>Nested &lt;fetch first clause&gt; in &lt;query expression&gt;</entry>
1518  <entry></entry>
1519 </row>
1520 <row>
1521  <entry>F857</entry>
1522  <entry></entry>
1523  <entry>Top-level &lt;fetch first clause&gt; in &lt;query expression&gt;</entry>
1524  <entry></entry>
1525 </row>
1526 <row>
1527  <entry>F858</entry>
1528  <entry></entry>
1529  <entry>&lt;fetch first clause&gt; in subqueries</entry>
1530  <entry></entry>
1531 </row>
1532 <row>
1533  <entry>F859</entry>
1534  <entry></entry>
1535  <entry>Top-level &lt;fetch first clause&gt; in views</entry>
1536  <entry></entry>
1537 </row>
1538 <row>
1539  <entry>F860</entry>
1540  <entry></entry>
1541  <entry>&lt;fetch first row count&gt; in &lt;fetch first clause&gt;</entry>
1542  <entry></entry>
1543 </row>
1544 <row>
1545  <entry>F861</entry>
1546  <entry></entry>
1547  <entry>Top-level &lt;result offset clause&gt; in &lt;query expression&gt;</entry>
1548  <entry></entry>
1549 </row>
1550 <row>
1551  <entry>F862</entry>
1552  <entry></entry>
1553  <entry>&lt;result offset clause&gt; in subqueries</entry>
1554  <entry></entry>
1555 </row>
1556 <row>
1557  <entry>F863</entry>
1558  <entry></entry>
1559  <entry>Nested &lt;result offset clause&gt; in &lt;query expression&gt;</entry>
1560  <entry></entry>
1561 </row>
1562 <row>
1563  <entry>F864</entry>
1564  <entry></entry>
1565  <entry>Top-level &lt;result offset clause&gt; in views</entry>
1566  <entry></entry>
1567 </row>
1568 <row>
1569  <entry>F865</entry>
1570  <entry></entry>
1571  <entry>&lt;offset row count&gt; in &lt;result offset clause&gt;</entry>
1572  <entry></entry>
1573 </row>
1574 <row>
1575  <entry>S071</entry>
1576  <entry>Enhanced object support</entry>
1577  <entry>SQL paths in function and type name resolution</entry>
1578  <entry></entry>
1579 </row>
1580 <row>
1581  <entry>S092</entry>
1582  <entry></entry>
1583  <entry>Arrays of user-defined types</entry>
1584  <entry></entry>
1585 </row>
1586 <row>
1587  <entry>S095</entry>
1588  <entry></entry>
1589  <entry>Array constructors by query</entry>
1590  <entry></entry>
1591 </row>
1592 <row>
1593  <entry>S096</entry>
1594  <entry></entry>
1595  <entry>Optional array bounds</entry>
1596  <entry></entry>
1597 </row>
1598 <row>
1599  <entry>S098</entry>
1600  <entry></entry>
1601  <entry>ARRAY_AGG</entry>
1602  <entry></entry>
1603 </row>
1604 <row>
1605  <entry>S111</entry>
1606  <entry>Enhanced object support</entry>
1607  <entry>ONLY in query expressions</entry>
1608  <entry></entry>
1609 </row>
1610 <row>
1611  <entry>S201</entry>
1612  <entry></entry>
1613  <entry>SQL-invoked routines on arrays</entry>
1614  <entry></entry>
1615 </row>
1616 <row>
1617  <entry>S201-01</entry>
1618  <entry></entry>
1619  <entry>Array parameters</entry>
1620  <entry></entry>
1621 </row>
1622 <row>
1623  <entry>S201-02</entry>
1624  <entry></entry>
1625  <entry>Array as result type of functions</entry>
1626  <entry></entry>
1627 </row>
1628 <row>
1629  <entry>S211</entry>
1630  <entry>Enhanced object support</entry>
1631  <entry>User-defined cast functions</entry>
1632  <entry></entry>
1633 </row>
1634 <row>
1635  <entry>T031</entry>
1636  <entry></entry>
1637  <entry>BOOLEAN data type</entry>
1638  <entry></entry>
1639 </row>
1640 <row>
1641  <entry>T071</entry>
1642  <entry></entry>
1643  <entry>BIGINT data type</entry>
1644  <entry></entry>
1645 </row>
1646 <row>
1647  <entry>T121</entry>
1648  <entry></entry>
1649  <entry>WITH (excluding RECURSIVE) in query expression</entry>
1650  <entry></entry>
1651 </row>
1652 <row>
1653  <entry>T122</entry>
1654  <entry></entry>
1655  <entry>WITH (excluding RECURSIVE) in subquery</entry>
1656  <entry></entry>
1657 </row>
1658 <row>
1659  <entry>T131</entry>
1660  <entry></entry>
1661  <entry>Recursive query</entry>
1662  <entry></entry>
1663 </row>
1664 <row>
1665  <entry>T132</entry>
1666  <entry></entry>
1667  <entry>Recursive query in subquery</entry>
1668  <entry></entry>
1669 </row>
1670 <row>
1671  <entry>T141</entry>
1672  <entry></entry>
1673  <entry>SIMILAR predicate</entry>
1674  <entry></entry>
1675 </row>
1676 <row>
1677  <entry>T151</entry>
1678  <entry></entry>
1679  <entry>DISTINCT predicate</entry>
1680  <entry></entry>
1681 </row>
1682 <row>
1683  <entry>T152</entry>
1684  <entry></entry>
1685  <entry>DISTINCT predicate with negation</entry>
1686  <entry></entry>
1687 </row>
1688 <row>
1689  <entry>T171</entry>
1690  <entry></entry>
1691  <entry>LIKE clause in table definition</entry>
1692  <entry></entry>
1693 </row>
1694 <row>
1695  <entry>T172</entry>
1696  <entry></entry>
1697  <entry>AS subquery clause in table definition</entry>
1698  <entry></entry>
1699 </row>
1700 <row>
1701  <entry>T173</entry>
1702  <entry></entry>
1703  <entry>Extended LIKE clause in table definition</entry>
1704  <entry></entry>
1705 </row>
1706 <row>
1707  <entry>T191</entry>
1708  <entry>Enhanced integrity management</entry>
1709  <entry>Referential action RESTRICT</entry>
1710  <entry></entry>
1711 </row>
1712 <row>
1713  <entry>T201</entry>
1714  <entry>Enhanced integrity management</entry>
1715  <entry>Comparable data types for referential constraints</entry>
1716  <entry></entry>
1717 </row>
1718 <row>
1719  <entry>T211-01</entry>
1720  <entry>Active database, Enhanced integrity management</entry>
1721  <entry>Triggers activated on UPDATE, INSERT, or DELETE of one base table</entry>
1722  <entry></entry>
1723 </row>
1724 <row>
1725  <entry>T211-02</entry>
1726  <entry>Active database, Enhanced integrity management</entry>
1727  <entry>BEFORE triggers</entry>
1728  <entry></entry>
1729 </row>
1730 <row>
1731  <entry>T211-03</entry>
1732  <entry>Active database, Enhanced integrity management</entry>
1733  <entry>AFTER triggers</entry>
1734  <entry></entry>
1735 </row>
1736 <row>
1737  <entry>T211-04</entry>
1738  <entry>Active database, Enhanced integrity management</entry>
1739  <entry>FOR EACH ROW triggers</entry>
1740  <entry></entry>
1741 </row>
1742 <row>
1743  <entry>T211-05</entry>
1744  <entry>Active database, Enhanced integrity management</entry>
1745  <entry>Ability to specify a search condition that must be true before the trigger is invoked</entry>
1746  <entry></entry>
1747 </row>
1748 <row>
1749  <entry>T211-07</entry>
1750  <entry>Active database, Enhanced integrity management</entry>
1751  <entry>TRIGGER privilege</entry>
1752  <entry></entry>
1753 </row>
1754 <row>
1755  <entry>T212</entry>
1756  <entry>Enhanced integrity management</entry>
1757  <entry>Enhanced trigger capability</entry>
1758  <entry></entry>
1759 </row>
1760 <row>
1761  <entry>T213</entry>
1762  <entry></entry>
1763  <entry>INSTEAD OF triggers</entry>
1764  <entry></entry>
1765 </row>
1766 <row>
1767  <entry>T231</entry>
1768  <entry></entry>
1769  <entry>Sensitive cursors</entry>
1770  <entry></entry>
1771 </row>
1772 <row>
1773  <entry>T241</entry>
1774  <entry></entry>
1775  <entry>START TRANSACTION statement</entry>
1776  <entry></entry>
1777 </row>
1778 <row>
1779  <entry>T271</entry>
1780  <entry></entry>
1781  <entry>Savepoints</entry>
1782  <entry></entry>
1783 </row>
1784 <row>
1785  <entry>T281</entry>
1786  <entry></entry>
1787  <entry>SELECT privilege with column granularity</entry>
1788  <entry></entry>
1789 </row>
1790 <row>
1791  <entry>T312</entry>
1792  <entry></entry>
1793  <entry>OVERLAY function</entry>
1794  <entry></entry>
1795 </row>
1796 <row>
1797  <entry>T321-01</entry>
1798  <entry>Core</entry>
1799  <entry>User-defined functions with no overloading</entry>
1800  <entry></entry>
1801 </row>
1802 <row>
1803  <entry>T321-03</entry>
1804  <entry>Core</entry>
1805  <entry>Function invocation</entry>
1806  <entry></entry>
1807 </row>
1808 <row>
1809  <entry>T321-06</entry>
1810  <entry>Core</entry>
1811  <entry>ROUTINES view</entry>
1812  <entry></entry>
1813 </row>
1814 <row>
1815  <entry>T321-07</entry>
1816  <entry>Core</entry>
1817  <entry>PARAMETERS view</entry>
1818  <entry></entry>
1819 </row>
1820 <row>
1821  <entry>T323</entry>
1822  <entry></entry>
1823  <entry>Explicit security for external routines</entry>
1824  <entry></entry>
1825 </row>
1826 <row>
1827  <entry>T325</entry>
1828  <entry></entry>
1829  <entry>Qualified SQL parameter references</entry>
1830  <entry></entry>
1831 </row>
1832 <row>
1833  <entry>T331</entry>
1834  <entry></entry>
1835  <entry>Basic roles</entry>
1836  <entry></entry>
1837 </row>
1838 <row>
1839  <entry>T341</entry>
1840  <entry></entry>
1841  <entry>Overloading of SQL-invoked functions and procedures</entry>
1842  <entry></entry>
1843 </row>
1844 <row>
1845  <entry>T351</entry>
1846  <entry></entry>
1847  <entry>Bracketed SQL comments (/*...*/ comments)</entry>
1848  <entry></entry>
1849 </row>
1850 <row>
1851  <entry>T441</entry>
1852  <entry></entry>
1853  <entry>ABS and MOD functions</entry>
1854  <entry></entry>
1855 </row>
1856 <row>
1857  <entry>T461</entry>
1858  <entry></entry>
1859  <entry>Symmetric BETWEEN predicate</entry>
1860  <entry></entry>
1861 </row>
1862 <row>
1863  <entry>T491</entry>
1864  <entry></entry>
1865  <entry>LATERAL derived table</entry>
1866  <entry></entry>
1867 </row>
1868 <row>
1869  <entry>T501</entry>
1870  <entry></entry>
1871  <entry>Enhanced EXISTS predicate</entry>
1872  <entry></entry>
1873 </row>
1874 <row>
1875  <entry>T551</entry>
1876  <entry></entry>
1877  <entry>Optional key words for default syntax</entry>
1878  <entry></entry>
1879 </row>
1880 <row>
1881  <entry>T581</entry>
1882  <entry></entry>
1883  <entry>Regular expression substring function</entry>
1884  <entry></entry>
1885 </row>
1886 <row>
1887  <entry>T591</entry>
1888  <entry></entry>
1889  <entry>UNIQUE constraints of possibly null columns</entry>
1890  <entry></entry>
1891 </row>
1892 <row>
1893  <entry>T614</entry>
1894  <entry></entry>
1895  <entry>NTILE function</entry>
1896  <entry></entry>
1897 </row>
1898 <row>
1899  <entry>T615</entry>
1900  <entry></entry>
1901  <entry>LEAD and LAG functions</entry>
1902  <entry></entry>
1903 </row>
1904 <row>
1905  <entry>T617</entry>
1906  <entry></entry>
1907  <entry>FIRST_VALUE and LAST_VALUE function</entry>
1908  <entry></entry>
1909 </row>
1910 <row>
1911  <entry>T621</entry>
1912  <entry></entry>
1913  <entry>Enhanced numeric functions</entry>
1914  <entry></entry>
1915 </row>
1916 <row>
1917  <entry>T631</entry>
1918  <entry>Core</entry>
1919  <entry>IN predicate with one list element</entry>
1920  <entry></entry>
1921 </row>
1922 <row>
1923  <entry>T651</entry>
1924  <entry></entry>
1925  <entry>SQL-schema statements in SQL routines</entry>
1926  <entry></entry>
1927 </row>
1928 <row>
1929  <entry>T655</entry>
1930  <entry></entry>
1931  <entry>Cyclically dependent routines</entry>
1932  <entry></entry>
1933 </row>
1934 <row>
1935  <entry>X010</entry>
1936  <entry></entry>
1937  <entry>XML type</entry>
1938  <entry></entry>
1939 </row>
1940 <row>
1941  <entry>X011</entry>
1942  <entry></entry>
1943  <entry>Arrays of XML type</entry>
1944  <entry></entry>
1945 </row>
1946 <row>
1947  <entry>X016</entry>
1948  <entry></entry>
1949  <entry>Persistent XML values</entry>
1950  <entry></entry>
1951 </row>
1952 <row>
1953  <entry>X020</entry>
1954  <entry></entry>
1955  <entry>XMLConcat</entry>
1956  <entry></entry>
1957 </row>
1958 <row>
1959  <entry>X031</entry>
1960  <entry></entry>
1961  <entry>XMLElement</entry>
1962  <entry></entry>
1963 </row>
1964 <row>
1965  <entry>X032</entry>
1966  <entry></entry>
1967  <entry>XMLForest</entry>
1968  <entry></entry>
1969 </row>
1970 <row>
1971  <entry>X034</entry>
1972  <entry></entry>
1973  <entry>XMLAgg</entry>
1974  <entry></entry>
1975 </row>
1976 <row>
1977  <entry>X035</entry>
1978  <entry></entry>
1979  <entry>XMLAgg: ORDER BY option</entry>
1980  <entry></entry>
1981 </row>
1982 <row>
1983  <entry>X036</entry>
1984  <entry></entry>
1985  <entry>XMLComment</entry>
1986  <entry></entry>
1987 </row>
1988 <row>
1989  <entry>X037</entry>
1990  <entry></entry>
1991  <entry>XMLPI</entry>
1992  <entry></entry>
1993 </row>
1994 <row>
1995  <entry>X040</entry>
1996  <entry></entry>
1997  <entry>Basic table mapping</entry>
1998  <entry></entry>
1999 </row>
2000 <row>
2001  <entry>X041</entry>
2002  <entry></entry>
2003  <entry>Basic table mapping: nulls absent</entry>
2004  <entry></entry>
2005 </row>
2006 <row>
2007  <entry>X042</entry>
2008  <entry></entry>
2009  <entry>Basic table mapping: null as nil</entry>
2010  <entry></entry>
2011 </row>
2012 <row>
2013  <entry>X043</entry>
2014  <entry></entry>
2015  <entry>Basic table mapping: table as forest</entry>
2016  <entry></entry>
2017 </row>
2018 <row>
2019  <entry>X044</entry>
2020  <entry></entry>
2021  <entry>Basic table mapping: table as element</entry>
2022  <entry></entry>
2023 </row>
2024 <row>
2025  <entry>X045</entry>
2026  <entry></entry>
2027  <entry>Basic table mapping: with target namespace</entry>
2028  <entry></entry>
2029 </row>
2030 <row>
2031  <entry>X046</entry>
2032  <entry></entry>
2033  <entry>Basic table mapping: data mapping</entry>
2034  <entry></entry>
2035 </row>
2036 <row>
2037  <entry>X047</entry>
2038  <entry></entry>
2039  <entry>Basic table mapping: metadata mapping</entry>
2040  <entry></entry>
2041 </row>
2042 <row>
2043  <entry>X048</entry>
2044  <entry></entry>
2045  <entry>Basic table mapping: base64 encoding of binary strings</entry>
2046  <entry></entry>
2047 </row>
2048 <row>
2049  <entry>X049</entry>
2050  <entry></entry>
2051  <entry>Basic table mapping: hex encoding of binary strings</entry>
2052  <entry></entry>
2053 </row>
2054 <row>
2055  <entry>X050</entry>
2056  <entry></entry>
2057  <entry>Advanced table mapping</entry>
2058  <entry></entry>
2059 </row>
2060 <row>
2061  <entry>X051</entry>
2062  <entry></entry>
2063  <entry>Advanced table mapping: nulls absent</entry>
2064  <entry></entry>
2065 </row>
2066 <row>
2067  <entry>X052</entry>
2068  <entry></entry>
2069  <entry>Advanced table mapping: null as nil</entry>
2070  <entry></entry>
2071 </row>
2072 <row>
2073  <entry>X053</entry>
2074  <entry></entry>
2075  <entry>Advanced table mapping: table as forest</entry>
2076  <entry></entry>
2077 </row>
2078 <row>
2079  <entry>X054</entry>
2080  <entry></entry>
2081  <entry>Advanced table mapping: table as element</entry>
2082  <entry></entry>
2083 </row>
2084 <row>
2085  <entry>X055</entry>
2086  <entry></entry>
2087  <entry>Advanced table mapping: target namespace</entry>
2088  <entry></entry>
2089 </row>
2090 <row>
2091  <entry>X056</entry>
2092  <entry></entry>
2093  <entry>Advanced table mapping: data mapping</entry>
2094  <entry></entry>
2095 </row>
2096 <row>
2097  <entry>X057</entry>
2098  <entry></entry>
2099  <entry>Advanced table mapping: metadata mapping</entry>
2100  <entry></entry>
2101 </row>
2102 <row>
2103  <entry>X058</entry>
2104  <entry></entry>
2105  <entry>Advanced table mapping: base64 encoding of binary strings</entry>
2106  <entry></entry>
2107 </row>
2108 <row>
2109  <entry>X059</entry>
2110  <entry></entry>
2111  <entry>Advanced table mapping: hex encoding of binary strings</entry>
2112  <entry></entry>
2113 </row>
2114 <row>
2115  <entry>X060</entry>
2116  <entry></entry>
2117  <entry>XMLParse: Character string input and CONTENT option</entry>
2118  <entry></entry>
2119 </row>
2120 <row>
2121  <entry>X061</entry>
2122  <entry></entry>
2123  <entry>XMLParse: Character string input and DOCUMENT option</entry>
2124  <entry></entry>
2125 </row>
2126 <row>
2127  <entry>X070</entry>
2128  <entry></entry>
2129  <entry>XMLSerialize: Character string serialization and CONTENT option</entry>
2130  <entry></entry>
2131 </row>
2132 <row>
2133  <entry>X071</entry>
2134  <entry></entry>
2135  <entry>XMLSerialize: Character string serialization and DOCUMENT option</entry>
2136  <entry></entry>
2137 </row>
2138 <row>
2139  <entry>X072</entry>
2140  <entry></entry>
2141  <entry>XMLSerialize: Character string serialization</entry>
2142  <entry></entry>
2143 </row>
2144 <row>
2145  <entry>X090</entry>
2146  <entry></entry>
2147  <entry>XML document predicate</entry>
2148  <entry></entry>
2149 </row>
2150 <row>
2151  <entry>X120</entry>
2152  <entry></entry>
2153  <entry>XML parameters in SQL routines</entry>
2154  <entry></entry>
2155 </row>
2156 <row>
2157  <entry>X121</entry>
2158  <entry></entry>
2159  <entry>XML parameters in external routines</entry>
2160  <entry></entry>
2161 </row>
2162 <row>
2163  <entry>X400</entry>
2164  <entry></entry>
2165  <entry>Name and identifier mapping</entry>
2166  <entry></entry>
2167 </row>
2168 <row>
2169  <entry>X410</entry>
2170  <entry></entry>
2171  <entry>Alter column data type: XML type</entry>
2172  <entry></entry>
2173 </row>
2174</tbody>
2175