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 <select list></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 <order by clause> in <query expression></entry> 1494 <entry></entry> 1495 </row> 1496 <row> 1497 <entry>F851</entry> 1498 <entry></entry> 1499 <entry><order by clause> in subqueries</entry> 1500 <entry></entry> 1501 </row> 1502 <row> 1503 <entry>F852</entry> 1504 <entry></entry> 1505 <entry>Top-level <order by clause> in views</entry> 1506 <entry></entry> 1507 </row> 1508 <row> 1509 <entry>F855</entry> 1510 <entry></entry> 1511 <entry>Nested <order by clause> in <query expression></entry> 1512 <entry></entry> 1513 </row> 1514 <row> 1515 <entry>F856</entry> 1516 <entry></entry> 1517 <entry>Nested <fetch first clause> in <query expression></entry> 1518 <entry></entry> 1519 </row> 1520 <row> 1521 <entry>F857</entry> 1522 <entry></entry> 1523 <entry>Top-level <fetch first clause> in <query expression></entry> 1524 <entry></entry> 1525 </row> 1526 <row> 1527 <entry>F858</entry> 1528 <entry></entry> 1529 <entry><fetch first clause> in subqueries</entry> 1530 <entry></entry> 1531 </row> 1532 <row> 1533 <entry>F859</entry> 1534 <entry></entry> 1535 <entry>Top-level <fetch first clause> in views</entry> 1536 <entry></entry> 1537 </row> 1538 <row> 1539 <entry>F860</entry> 1540 <entry></entry> 1541 <entry><fetch first row count> in <fetch first clause></entry> 1542 <entry></entry> 1543 </row> 1544 <row> 1545 <entry>F861</entry> 1546 <entry></entry> 1547 <entry>Top-level <result offset clause> in <query expression></entry> 1548 <entry></entry> 1549 </row> 1550 <row> 1551 <entry>F862</entry> 1552 <entry></entry> 1553 <entry><result offset clause> in subqueries</entry> 1554 <entry></entry> 1555 </row> 1556 <row> 1557 <entry>F863</entry> 1558 <entry></entry> 1559 <entry>Nested <result offset clause> in <query expression></entry> 1560 <entry></entry> 1561 </row> 1562 <row> 1563 <entry>F864</entry> 1564 <entry></entry> 1565 <entry>Top-level <result offset clause> in views</entry> 1566 <entry></entry> 1567 </row> 1568 <row> 1569 <entry>F865</entry> 1570 <entry></entry> 1571 <entry><offset row count> in <result offset clause></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