1、 KSKSKSKSKSKSKSK KSKSKS KSKSK KSKS KSK KS KS X ISO/IEC 9075 2 SQL 2: (SQL/ )KS X ISO/IEC 9075 2:2011 2011 12 30 http:/www.kats.go.krKS X ISO/IEC 9075 2:2011 : e ( ) ( ) () () ( ) : (COSD) ( ) : (http:/www.standard.go.kr) : :2000 11 14 :2011 12 30 2011-0676 : e : (COSD) ( 02-509-7262) (http:/www.kats
2、.go.kr). 10 5 , . KS X ISO/IEC 9075 2:2011 i x . xi 1 1 2 2 2.1 ISO IEC .2 2.2 .2 3 , , 4 3.1 .4 3.2 .10 3.3 .11 4 12 4.1 12 4.2 17 4.3 27 4.4 .29 4.5 32 4.6 .33 4.7 .39 4.8 .45 4.9 46 4.10 48 4.11 51 4.12 .52 4.13 , 53 4.14 .55 4.15 ( ).64 4.16 .68 4.17 69 4.18 74 4.19 .83 4.20 SQL 84 4.21 .86 4.22
3、 SQL 88 4.23 90 4.24 SQL .91 4.25 SQL .94 4.26 .95 4.27 SQL .96 4.28 SQL 103 4.29 .104 4.30 106 KS X ISO/IEC 9075 2:2011 ii 4.31 106 4.32 .108 4.33 SQL 113 4.34 .124 4.35 SQL .129 4.36 SQL 134 4.37 SQL 135 4.38 .139 4.39 143 5 .144 5.1 144 5.2 Seperator .148 5.3 .158 5.4 168 6 .180 6.1 .180 6.2 192
4、6.3 .193 6.4 195 6.5 201 6.6 203 6.7 207 6.8 .209 6.9 210 6.10 212 6.11 216 6.12 220 6.13 .233 6.14 .235 6.15 .236 6.16 238 6.17 .240 6.18 242 6.19 .244 6.20 245 6.21 .246 6.22 247 6.23 .249 6.24 .250 6.25 .251 6.26 .255 6.27 257 6.28 .269 6.29 273 6.30 288 6.31 .291 6.32 293 6.33 .297 6.34 .298 6.3
5、5 .302 6.36 .304 KS X ISO/IEC 9075 2:2011 iii 6.37 .306 6.38 309 6.39 .310 7 .312 7.1 .312 7.2 315 7.3 .317 7.4 .319 7.5 320 7.6 322 7.7 .332 7.8 340 7.9 341 7.10 350 7.11 351 7.12 361 7.13 370 7.14 385 7.15 .389 8 391 8.1 .391 8.2 392 8.3 .398 8.4 .399 8.5 401 8.6 .406 8.7 412 8.8 413 8.9 415 8.10
6、.417 8.11 .418 8.12 419 8.13 .420 8.14 422 8.15 .424 8.16 .426 8.17 428 8.18 .430 8.19 .431 8.20 .433 9 434 9.1 434 9.2 438 9.3 442 9.4 .445 9.5 .446 9.6 .449 9.7 .451 9.8 .452 9.9 454 KS X ISO/IEC 9075 2:2011 iv 9.10 456 9.11 .458 9.12 460 9.13 462 9.14 463 9.15 .466 9.16 XQuery .467 9.17 XQuery .4
7、70 9.18 .472 9.19 from - sql 474 9.20 from-sql 475 9.21 to-sql .476 9.22 to-sql 477 9.23 .478 9.24 479 9.25 .481 10 483 10.1 483 10.2 .486 10.3 487 10.4 .488 10.5 507 10.6 509 10.7 512 10.8 .513 10.9 514 10.10 .525 10.11 527 10.12 529 11 .532 11.1 532 11.2 535 11.3 538 11.4 .548 11.5 553 11.6 557 11
8、.7 .559 11.8 561 11.9 565 11.10 .567 11.11 .568 11.12 570 11.13 .571 11.14 572 11.15 .573 11.16 574 11.17 .576 11.18 578 11.19 579 11.20 .581 KS X ISO/IEC 9075 2:2011 v 11.21 .582 11.22 .585 11.23 .588 11.24 .597 11.25 600 11.26 .602 11.27 .603 11.28 604 11.29 605 11.30 .606 11.31 .607 11.32 .609 11
9、.33 611 11.34 .613 11.35 .615 11.36 617 11.37 .619 11.38 .620 11.39 622 11.40 624 11.41 629 11.42 632 11.43 .647 11.44 649 11.45 650 11.46 .652 11.47 .654 11.48 .659 11.49 663 11.50 666 11.51 .669 11.52 694 11.53 .697 11.54 699 11.55 .701 11.56 703 11.57 706 11.58 .708 11.59 .711 11.60 712 11.61 .71
10、4 11.62 .716 11.63 718 11.64 721 11.65 722 12 .723 12.1 .723 12.2 727 12.3 .730 12.4 734 12.5 735 12.6 .737 12.7 738 KS X ISO/IEC 9075 2:2011 vi 12.8 754 13 SQL .755 13.1 .755 13.2 760 13.3 .761 13.4 .764 13.5 780 13.6 .787 14 .794 14.1 .794 14.2 .795 14.3 .797 14.4 .800 14.5 .801 14.6 805 14.7 .806
11、 14.8 .809 14.9 811 14.10 .814 14.11 816 14.12 821 14.13 .829 14.14 .831 14.15 835 14.16 840 14.17 .842 14.18 843 15 844 15.1 .844 15.2 .847 15.3 848 15.4 .850 15.5 851 15.6 .853 15.7 .856 15.8 .858 15.9 860 15.10 862 15.11 864 15.12 866 15.13 .868 15.14 870 15.15 872 15.16 BEFORE .874 15.17 .875 15
12、.18 AFTER 880 15.19 881 16 .883 KS X ISO/IEC 9075 2:2011 vii 16.1 883 16.2 .884 17 .885 17.1 .885 17.2 .887 17.3 889 17.4 891 17.5 .892 17.6 .893 17.7 .894 17.8 896 18 .898 18.1 898 18.2 901 18.3 903 19 .905 19.1 .905 19.2 907 19.3 .908 19.4 .909 19.5 .910 19.6 911 19.7 912 19.8 913 19.9 914 19.10 9
13、15 20 SQL.917 20.1 SQL 917 20.2 925 20.3 927 20.4 .928 20.5 .931 20.6 935 20.7 945 20.8 .946 20.9 .947 20.10 .953 20.11 957 20.12 961 20.13 963 20.14 964 20.15 .965 20.16 968 20.17 970 20.18 .971 20.19 972 20.20 973 20.21 .974 20.22 976 20.23 .978 20.24 980 KS X ISO/IEC 9075 2:2011 viii 21 SQL .982
14、21.1 982 21.2 993 21.3 .997 21.4 1004 21.5 1013 21.6 .1020 21.7 1027 21.8 1033 21.9 .1039 22 SQL 1046 22.1 1046 22.2 1050 23 .1051 23.1 .1051 23.2 (pushing) (popping) .1065 24 .1066 24.1 SQLSTATE .1066 24.2 SQLSTATE 1072 25 1073 25.1 SQL/Foundation 1073 25.2 SQL/Foundation 1074 25.3 SQL/Foundation .
15、1075 A( ) SQL 1077 B( ) .1137 C( ) .1154 D( ) .1161 E( ) ISO/IEC 9075:2003 .1162 F( ) SQL 1164 G( ) .1187 1188 KS X ISO/IEC 9075 2:2011 1189 1 .25 2 .34 3 .35 4 - INTERVAL .36 5 - INTERVAL .36 6 INTERVAL 36 7 37 8 SQL 131 KS X ISO/IEC 9075 2:2011 ix 9 188 10 .188 11 AND .301 12 OR 301 13 IS 301 14 .
16、414 15 486 16 Ada .787 17 C .788 18 COBOL .789 19 Fortran 790 20 M .791 21 Pascal .792 22 PL/I .793 23 SQL 920 24 SQL .921 25 SQL SQL 922 26 SQL 923 27 SQL .923 28 SQL / SQL 924 29 SQL .924 30 1053 31 1053 32 SQL 1054 33 SQLSTATE .1067 34 RDA SQLSTATE 1072 35 SQL/Foundation .1075 36 .1164 37 1178 KS
17、 X ISO/IEC 9075 2:2011 x . KS X ISO/IEC 9075 2:2009 . . , , . , , . ISO(International Organization for Standardization) IEC(International Electrotechnical Commission, ) . ISO IEC . ISO IEC . , , ISO IEC . ISO/IEC Directives, 2 . ISO IEC ISO/IEC JTC 1 . . 75 % . . ISO IEC . KS X ISO/IEC 9075 2 2008 I
18、SO/IEC 9075 2 3 KS . ISO/IEC 9075 2:2008, 3 2003 2 (ISO/IEC 9075 2:2003) , (Technical Corrigendum) ISO/IEC 9075 2: 2003/ Cor.1:2005, ISO/IEC 9075 2:2003/ Cor.2:2007 . ISO/IEC 9075 SQL . 1 : (SQL/ ) 2 : (SQL/ ) 3 : (SQL/CLI) 4 : (SQL/PSM) 5 : (SQL/ ) 9 : (SQL/MED) 10 : (SQL/OLB) 11 : 13 : SQL (SQL/JR
19、T) 14 : XML (SQL/XML) KS X ISO/IEC 9075 2:2011 xi 2008 3 ISO/IEC 9075 2, Information technology Database languages SQL Part 2: Foundation(SQL/Foundation) , . KS X ISO/IEC 9075 2 . 1) 1 “” . 2) 2 “” . 3) 3 “ , , ” . 4) 4 “” SQL . 5) 5 “ ” . 6) 6 “ ” . 7) 7 “ ” . 8) 8 “” . 9) 9 “ ” SQL SQL , (formatio
20、n rules) . 10) 10 “ ” . 11) 11 “ ” . 12) 12 “ ” SQL . 13) 13 “SQL ” SQL . 14) 14 “ ” . 15) 15 “ ” . 16) 16 “ ” SQL . 17) 17 “ ” SQL . 18) 18 “ ” SQL . 19) 19 “ ” SQL . KS X ISO/IEC 9075 2:2011 xii 20) 20 “ SQL” . 21) 21 “ SQL” (host language embeddings) . 22) 22 “SQL ” SQL . 23) 23 “ ” . 24) 24 “ ”
21、SQL . 25) 25 “” . 26) A “SQL ” , SQL . 27) B “ ” , . , , , SQL , . 28) C “ ” , . , , , SQL , . 29) D “ ” , . 30) E “ISO/IEC 9075: 2003 ” , . 31) F “SQL ” , SQL . , SQL . 32) G “ISO/IEC 9075 ” , . ISO/IEC 9075 , . , 5 “ ” 24 “ ” . . KS X ISO/IEC 9075 2:2011 SQL 2: (SQL/ ) Information technology Datab
22、ase languages SQL Part 2: Foundation(SQL/Foundation) 1 SQL . SQL , , , . . SQL SQL ( ) SQL . , SQL . SQL , SQL . SQL SQL SQL . SQL . , , , , , , . KS X ISO/IEC 9075 2:2011 2 2 . . ( ) . 2.1 ISO IEC ISO 646 ISO/IEC 646 : 1991, Information technology ISO 7-bit coded character set for informationinterc
23、hange ISO 1539 ISO/IEC 1539 1: 2004, Information technology Programming languages Fortran Part 1: Base language ISO 1989 ISO/IEC 1989: 2002, Information technology Programming languages COBOL ISO 6160 KS X ISO 6160, PL/1 ISO 6429 ISO/IEC 6429: 1992, Information technology Control functions for coded
24、 character sets. ISO 7185 KS X ISO 7185, ISO 8601 ISO 8601: 2004, Data elements and interchange formats Information interchangeRepresentation of dates and times ISO 8649 ISO/IEC 8649: 1996, Information technology Open Systems Interconnection Service Definitionfor the Association Control Service Elem
25、ent ISO/IEC 8649: 1996/Amd.1: 1997, Support of authentication mechanisms for the connectionless mode. ISO/IEC 8649: 1996/Amd.2: 1998, Fast-associate mechanism ISO 8652 KS X ISO 8652, Ada ISO 8859 1 KS X ISO/IEC 8859 1, 8 1: 1 ISO 9075 1 ISO/IEC 9075 1: 2008, Information technology Database languages
26、 SQL Part 1:Framework (SQL/Framework) ISO 9075 11 KS X ISO/IEC 9075 11, SQL 11: ISO 9579 KS X ISO/IEC 9579, SQL ISO 9899 KS X ISO/IEC 9899, C ISO/IEC 9899: 1999/Cor 1: 2001, ISO/IEC 9899: 1999/Cor 2: 2004 ISO 10026 2 KS X ISO/IEC 10026 2, 2: OSI TP ISO 10206 KS X ISO/IEC 10206, ISO 10646 KS X ISO/IE
27、C 10646, (UCS) , ISO 11756 KS X ISO/IEC 11756, M ISO 14651 ISO/IEC 14651: 2007, Information technology International string ordering and comparison Method for comparing character strings and description of the common template tailorable ordering 2.2 IANA The Internet Assigned Numbers Authority, Character sets http:/www.iana.org/assignments/character-sets KS X ISO/IEC 9075 2:2011 3 Unicode The Unicode Consortium, The Unicode Standard. (Information about the late
copyright@ 2008-2019 麦多课文库(www.mydoc123.com)网站版权所有
备案/许可证编号:苏ICP备17064731号-1