1<!DOCTYPE html> 2<html lang="ru-RU"> 3<head> 4<!-- Global site tag (gtag.js) - Google Analytics -->
5<script data-rocketlazyloadscript='https://www.googletagmanager.com/gtag/js?id=UA-139248612-1' async ></script>
vendor: 1 bytes, line 5
5
6<script data-rocketlazyloadscript='data:text/javascript;base64,CiAgd2luZG93LmRhdGFMYXllciA9IHdpbmRvdy5kYXRhTGF5ZXIgfHwgW107CiAgZnVuY3Rpb24gZ3RhZygpe2RhdGFMYXllci5wdXNoKGFyZ3VtZW50cyk7fQogIGd0YWcoJ2pzJywgbmV3IERhdGUoKSk7CiAgZ3RhZygnY29uZmlnJywgJ1VBLTEzOTI0ODYxMi0xJyk7Cg==' ></script>
6 7<meta charset="UTF-8" /> 8<meta name="viewport" content="width=device-width, initial-scale=1"> 9<meta name="viewport" content="width=device-width" /> 10<link rel="profile" href="http://gmpg.org/xfn/11" /> 11<link rel="pingback" href="https://oracleplsql.ru/xmlrpc.php" /> 12<!--[if lt IE 9]>
13<script src="https://oracleplsql.ru/wp-content/themes/f2/js/html5.js" type="text/javascript"></script>
13 14<![endif]--> 15
16<script data-rocketlazyloadscript='//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
vendor: 1 bytes, line 16
16
17<script> 18 (adsbygoogle = window.adsbygoogle || []).push({ 19 google_ad_client: "ca-pub-8777261894857145", 20 enable_page_level_ads: true 21 }); 22</script>
22 23 24<title>SQL — опиÑание — Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite</title><link rel="stylesheet" href="https://fonts.googleapis.com/css?family=PT%20Serif%7CPrata%7CBitter%3A700%7CGudea%3A400%2C700%2C400italic&display=swap" /><link rel="stylesheet" href="https://oracleplsql.ru/wp-content/cache/min/1/e6cd45c7c83be6010c82e9b45c293d40.css" media="all" data-minify="1" /> 25<meta name='robots' content='max-image-preview:large' /> 26<link rel='dns-prefetch' href='//fonts.googleapis.com' /> 27<link href='https://fonts.gstatic.com' crossorigin rel='preconnect' /> 28<link rel="alternate" type="application/rss+xml" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite » ÐенÑа" href="https://oracleplsql.ru/feed" /> 29<link rel="alternate" type="application/rss+xml" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite » ÐенÑа комменÑаÑиев" href="https://oracleplsql.ru/comments/feed" /> 30<style id="wp-img-auto-sizes-contain-inline-css"> 31img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px} 32/*# sourceURL=wp-img-auto-sizes-contain-inline-css */ 33</style> 34 35<style id="wp-emoji-styles-inline-css"> 36 37 img.wp-smiley, img.emoji { 38 display: inline !important; 39 border: none !important; 40 box-shadow: none !important; 41 height: 1em !important; 42 width: 1em !important; 43 margin: 0 0.07em !important; 44 vertical-align: -0.1em !important; 45 background: none !important; 46 padding: 0 !important; 47 } 48/*# sourceURL=wp-emoji-styles-inline-css */ 49</style> 50<style id="wp-block-library-inline-css"> 51:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;
51--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap!important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-break:normal!important}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style^=border-color],[style*=";border-color"],[style*="; border-color"]){border-style:solid}html :where([style^=border-top-color],[style*=";border-top-color"],[style*="; border-top-color"]){border-top-style:solid}html :where([style^=border-right-color],[style*=";border-right-color"],[style*="; border-right-color"]){border-right-style:solid}html :where([style^=border-bottom-color],[style*=";border-bottom-color"],[style*="; border-bottom-color"]){border-bottom-style:solid}html :where([style^=border-left-color],[style*=";border-left-color"],[style*="; border-left-color"]){border-left-style:solid}html :where([style^=border-width],[style*=";border-width"],[style*="; border-width"]){border-style:solid}html :where([style^=border-top-width],[style*=";border-top-width"],[style*="; border-top-width"]){border-top-style:solid}html :where([style^=border-right-width],[style*=";border-right-width"],[style*="; border-right-width"]){border-right-style:solid}html :where([style^=border-bottom-width],[style*=";border-bottom-width"],[style*="; border-bottom-width"]){border-bottom-style:solid}html :where([style^=border-left-width],[style*=";border-left-width"],[style*="; border-left-width"]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}} 52 53/*# sourceURL=/wp-includes/css/dist/block-library/common.min.css */ 54</style> 55<style id="classic-theme-styles-inline-css"> 56/*! This file is auto-generated */ 57.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} 58/*# sourceURL=/wp-includes/css/classic-themes.min.css */ 59</style> 60 61<style id="global-styles-inline-css"> 62:root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgb(252,185,
620) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgb(255, 255, 255), 6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp: 6px 6px 0px rgb(0, 0, 0);}.wp-block-button{--wp--preset--dimension--25: 25%;--wp--preset--dimension--50: 50%;--wp--preset--dimension--75: 75%;--wp--preset--dimension--100: 100%;}:where(body) { margin: 0; }:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}body{padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}:root :where(.wp-element-button, .wp-block-button__link){background-color: #32373c;border-width: 0;color: #fff;font-family: inherit;font-size: inherit;font-style: inherit;font-weight: inherit;letter-spacing: inherit;line-height: inherit;padding-top: calc(0.667em + 2px);padding-right: calc(1.333em + 2px);padding-bottom: calc(0.667em + 2px);padding-left: calc(1.333em + 2px);text-decoration: none;text-transform: inherit;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}
62.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;} 63/*# sourceURL=global-styles-inline-css */ 64</style> 65 66 67 68<link rel='stylesheet' id='print-css' href='https://oracleplsql.ru/wp-content/themes/f2/print.css?ver=2.2.3' media='print' />
69<script id="jquery-core-js" src="https://oracleplsql.ru/wp-includes/js/jquery/jquery.min.js?ver=3.7.1" defer></script>
69 70
71<script id="crayon_js-js-extra"> 72var CrayonSyntaxSettings = {"version":"_2.7.2_beta","is_admin":"0","ajaxurl":"https://oracleplsql.ru/wp-admin/admin-ajax.php","prefix":"crayon-","setting":"crayon-setting","selected":"crayon-setting-selected","changed":"crayon-setting-changed","special":"crayon-setting-special","orig_value":"data-orig-value","debug":""}; 73var CrayonSyntaxStrings = {"copy":"Press %s to Copy, %s to Paste","minimize":"Click To Expand Code"}; 74//# sourceURL=crayon_js-js-extra 75</script>
75 76 77<link rel="https://api.w.org/" href="https://oracleplsql.ru/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://oracleplsql.ru/wp-json/wp/v2/posts/2402" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://oracleplsql.ru/xmlrpc.php?rsd" /> 78<meta name="generator" content="WordPress 7.1.2" /> 79<link rel='shortlink' href='https://oracleplsql.ru/?p=2402' /> 80<!-- Customized F2 styles --> 81<style type="text/css"> 82/*div frontpage*/ 83 84/*div{display:box}*/ 85.row{margin-right:-10px;margin-left:-10px;} 86 87.col-md-4, .col-xs-6, .col-sm-4{ 88 float: left; 89 min-height:1px; 90 position:relative;} 91 92.list-grp { 93 border:0; 94 border-radius:0; 95 box-shadow:0 0 0; 96 margin:0;} 97.list-grp { 98 margin-bottom:20px; 99 padding-left:0; 100} 101 102.list-grp a { 103 border-radius:0; 104} 105 106.list-grp-itm { 107 background-color:#FFFFFF; 108 border:1px solid #DDDDDD; 109 display:block; 110 margin-bottom:-1px; 111 padding:5px 20px; 112 position:relative; 113} 114.list-grp-itm:first-child { 115 border-top-left-radius:4px; 116 border-top-right-radius:4px; 117} 118/*END div frontpage*/ 119.sintax{ 120 background:#EEEEEE; 121 border:1px solid #E6E6E6; 122 border-radius:5px; 123 box-shadow:#6D97B7 1px 1px 1px; 124 border-collapse:collapse; 125 border-spacing:0; 126 font-family:Consolas, 'Courier New', Courier, monospace; 127 font-size:1em; 128 margin:0 0 20px; 129 padding:5px; 130 white-space:pre-wrap; 131 word-wrap:break-word; 132} 133.arg{ 134 background:#EEEEEE; 135 border:1px solid #E6E6E6; 136 border-radius:4px; 137 box-shadow:#6D97B7 1px 1px 1px; 138 padding-right:1px; 139 padding-left:1px; 140} 141 142.crayon-syntax{border-radius:4px;box-shadow:#6D97B7 1px 1px 1px;} 143 144/*.tbfunc td{width:33%;}*/ 145 146 147li.list{background:none;} 148 149.rel_1, .rel_2 {float:left;position:relative;width:45.3%;background-color:#fff;} 150/*.rel_2 {float:left;position:relative;width:45.3%;background-color:#fff;}*/ 151 152.gt_ct{margin-top:10px;display:block;} 153 154#text-2{margin-left:6.6rem;display:block;} 155 156/*.entry-content p {font-family: 'PT Serif Caption', serif;}*/ 157.list-grp-itm, .menu-item, .entry-content p {font-family: 'PT Serif', serif;} 158 159/*google search*/ 160 161input.gsc-input, .gsc-input-box, .gsc-input-box-hover, .gsc-input-box-focus { 162 height:3.2rem; 163} 164 165table.gsc-search-box, 166.gsc-search-box td, 167.gsc-search-box tr, 168.gsc-input-box tr, 169.gsc-input-box td{ 170border-style: none; 171box-shadow: none; 172-moz-box-shadow: none; 173-webkit-box-shadow: none; 174} 175 176/* ââ GOOGLE CSE ÐÐÐСРââ */ 177 178/* ÐбÑÑÑка виджеÑа */ 179.widget .gsc-search-box, 180.widget .gsc-input-box, 181.gcse-search, 182.gcse-searchbox { 183 border: none !important; 184 box-shadow: none !important; 185 padding: 0 !important; 186 background: transparent !important; 187} 188 189/* Само поле ввода */ 190.widget input.gsc-input, 191input.gsc-input, 192.gsc-input-box input[type="text"] { 193 background: #fff !important; 194 /* border: 1.5px solid #dde3ec !important;*/ 195 border-radius: 8px !important; 196/* box-shadow: 0 1px 4px rgba(0,0,0,.06) !important;*/ 197 padding: 8px 12px 8px 38px !important; 198 font-family: 'Inter', sans-serif !important; 199 font-size: 1.35rem !important; 200 color: #1a2535 !important; 201 width: 97% !important; 202 height: auto !important; 203 transition: border-color .15s, box-shadow .15s !important; 204 outline: none !important; 205} 206 207.widget input.gsc-input:focus, 208input.gsc-input:focus { 209 border-color: #1a5296 !important; 210 box-shadow: 0 0 0 3px rgba(26,82,150,.12) !important; 211} 212 213/* УбиÑаем Ñон-ÑаблиÑÑ ÐºÐ¾ÑоÑÑÑ ÑиÑÑÐµÑ Google */ 214.gsc-input-box { 215 background: transparent !important; 216 border: none !important; 217 padding: 0 !important; 218} 219 220table.gsc-search-box, 221table.gsc-search-box td { 222 border: none !important; 223 padding: 0 !important; 224 margin: 0 !important; 225 background: transparent !important; 226} 227 228/* Ðнопка поиÑка â ÑкÑÑваем ÑÑандаÑÑнÑÑ Google */ 229.widget .gsc-search-button, 230.gsc-search-button { 231 display: none !important; 232} 233 234/* Ðконка лÑÐ¿Ñ ÑеÑез CSS (пÑевдоÑÐ»ÐµÐ¼ÐµÐ½Ñ Ð½Ð° обÑÑÑке) */ 235.widget .gsc-input-box-hover, 236.widget .gsc-input-box { 237 position: relative !important; 238} 239 240.widget .gsc-input-box::before { 241 content: ''; 242 display: block; 243 position: absolute; 244 left: 12px; 245 top: 50%; 246 transform: translateY(-50%); 247 width: 16px; 248 height: 16px; 249 background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='16' height='16' viewB
249ox='0 0 24 24' fill='none' stroke='%236b7a90' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Ccircle cx='11' cy='11' r='8'/%3E%3Cline x1='21' y1='21' x2='16.65' y2='16.65'/%3E%3C/svg%3E"); 250 background-repeat: no-repeat; 251 background-size: contain; 252 pointer-events: none; 253 z-index: 1; 254} 255 256/* РезÑлÑÑаÑÑ Ð¿Ð¾Ð¸Ñка */ 257.gsc-results-wrapper-overlay { 258 border-radius: 8px !important; 259 box-shadow: 0 8px 24px rgba(0,0,0,.15) !important; 260} 261 262.gsc-result { 263 border-bottom: 1px solid #dde3ec !important; 264 padding: 12px 0 !important; 265} 266 267.gs-title, .gs-title * { 268 color: #1a5296 !important; 269 font-family: 'Inter', sans-serif !important; 270 font-size: 1.4rem !important; 271} 272 273.gs-snippet { 274 color: #445566 !important; 275 font-family: 'Inter', sans-serif !important; 276 font-size: 1.3rem !important; 277}</style> 278<link rel="icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" sizes="32x32" /> 279<link rel="icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" sizes="192x192" /> 280<link rel="apple-touch-icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" /> 281<meta name="msapplication-TileImage" content="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" /> 282<noscript><style id="rocket-lazyload-nojs-css">.rll-youtube-player, [data-lazy-src]{display:none !important;}</style></noscript></head> 283 284<body class="wp-singular post-template-default single single-post postid-2402 single-format-standard wp-theme-f2 one-sidebar-left medium-sidebar large-font-sidebar large-font-content"> 285 <amp-auto-ads type="adsense" 286 data-ad-client="ca-pub-8777261894857145"> 287</amp-auto-ads> 288<div style="display:table;margin: 0 auto;"> 289<!-- orclplsql_adapt_mobile_top --> 290<style type="text/css"> 291.mob_top { width: 320px; height: 100px; } 292@media (min-width:500px) { .mob_top { width: 468px; height: 60px; } } 293@media (min-width:800px) { .mob_top { width: 728px; height: 90px; } } 294</style> 295<ins class="adsbygoogle mob_top" 296 style="display:inline-block;" 297 data-full-width-responsive="true" 298 data-ad-client="ca-pub-8777261894857145" 299 data-ad-slot="8026856126" 300 data-full-width-responsive="true"></ins>
301<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
301
302<script> 303 (adsbygoogle = window.adsbygoogle || []).push({}); 304</script>
304 305</div> 306<div id="page" class="hfeed site"> 307 <header id="masthead" class="site-header" role="banner"> 308 <div class="site-branding"> 309 <h1 class="site-title"><a href="https://oracleplsql.ru/" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite" rel="home">Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite</a></h1> 310 <h2 class="site-description">ÐÐ°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ </h2> 311 </div><!-- .site-branding --> 312 313 <nav role="navigation" class="site-navigation main-navigation"> 314 <h1 class="assistive-text">Menu</h1> 315 <div class="assistive-text skip-link"><a href="#content" title="Skip to content">Skip to content</a></div> 316 317 <div class="menu-sql-container"><ul id="menu-sql" class="menu"><li id="menu-item-2533" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item menu-item-2533"><a href="https://oracleplsql.ru/sql-language.html" aria-current="page">SQL</a></li> 318<li id="menu-item-7341" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7341"><a href="https://oracleplsql.ru/contents-oracle-plsql.html">Oracle PL/SQL</a></li> 319<li id="menu-item-3192" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3192"><a href="https://oracleplsql.ru/mysql-manual.html">MySQL</a></li> 320<li id="menu-item-7342" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7342"><a href="https://oracleplsql.ru/contents-sql-server.html">SQL Server</a></li> 321<li id="menu-item-7343" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7343"><a href="https://oracleplsql.ru/sqlite-manual.html">SQLite</a></li> 322<li id="menu-item-6422" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-6422"><a href="https://oracleplsql.ru/postgresql-manual.html">PostgreSQL</a></li> 323<li id="menu-item-7201" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7201"><a href="https://oracleplsql.ru/mariadb-manual.html">MariaDB</a></li> 324</ul></div> </nav><!-- .site-navigation .main-navigation --> 325 326 327 </header><!-- #masthead .site-header --> 328 329 <div id="main" class="site-main"> 330 <div id="primary" class="content-area"> 331 <div id="content" class="site-content" role="main"> 332 333 334 335<article id="post-2402" class="post-2402 post type-post status-publish format-standard hentry category-sql-language"> 336 <header class="entry-header"> 337 <h1 class="entry-title">SQL - опиÑание</h1> 338 <div class="entry-meta"> 339 <!-- --> 340 </div><!-- .entry-meta --> 341 </header><!-- .entry-header --> 342 343 <div class="entry-content"> 344 <br /> 345<h2>Ð¢Ð¸Ð¿Ñ SQL-запÑоÑов</h2> 346<table> 347<tbody> 348<tr> 349<td><a href="https://oracleplsql.ru/select-sql.html">SELECT</a></td> 350<td>ÐзвлеÑение запиÑей из ÑаблиÑÑ</td> 351</tr> 352<tr> 353<td><a href="https://oracleplsql.ru/select-limit-sql.html">SELECT LIMIT</a></td> 354<td>ÐзвлеÑение запиÑей из ÑаблиÑÑ Ð¸ огÑаниÑение ÑезÑлÑÑаÑов</td> 355</tr> 356<tr> 357<td><a href="https://oracleplsql.ru/select-top-sql.html">SELECT TOP</a></td> 358<td>ÐзвлеÑение запиÑей из ÑаблиÑÑ Ð¸ огÑаниÑение ÑезÑлÑÑаÑов</td> 359</tr> 360<tr> 361<td><a href="https://oracleplsql.ru/insert-sql.html">INSERT</a></td> 362<td>ÐÑÑавка запиÑей в ÑаблиÑÑ</td> 363</tr> 364<tr> 365<td><a href="https://oracleplsql.ru/update-sql.html">UPDATE</a></td> 366<td>Ðбновление запиÑей в ÑаблиÑе</td> 367</tr> 368<tr> 369<td><a href="https://oracleplsql.ru/delete-sql.html">DELETE</a></td> 370<td>УдалиÑÑ Ð·Ð°Ð¿Ð¸Ñи из ÑаблиÑÑ.</td> 371</tr> 372<tr> 373<td><a href="https://oracleplsql.ru/truncate-table-sql.html">TRUNCATE TABLE</a></td> 374<td>УдалиÑÑ Ð²Ñе запиÑи из ÑаблиÑÑ (без оÑкаÑа)</td> 375</tr> 376<tr> 377<td><a href="https://oracleplsql.ru/union-sql.html">UNION</a></td> 378<td>ÐбÑединÑÐµÑ 2 набоÑа ÑезÑлÑÑаÑов (ÑдалÑÐµÑ Ð´ÑбликаÑÑ)</td> 379</tr> 380<tr> 381<td><a href="https://oracleplsql.ru/union-all-sql.html">UNION ALL</a></td> 382<td>ÐбÑединÑÐµÑ 2 набоÑа ÑезÑлÑÑаÑов (вклÑÑÐ°ÐµÑ Ð´ÑбликаÑÑ)</td> 383</tr> 384<tr> 385<td><a href="https://oracleplsql.ru/intersect-sql.html">INTERSECT</a></td> 386<td>ÐеÑеÑеÑение 2 набоÑов ÑезÑлÑÑаÑов</td> 387</tr> 388<tr> 389<td><a href="https://oracleplsql.ru/minus-sql.html">MINUS</a></td> 390<td>РезÑлÑÑиÑÑÑÑий Ð½Ð°Ð±Ð¾Ñ Ð¾Ð´Ð½Ð¾Ð³Ð¾ минÑÑ ÑезÑлÑÑиÑÑÑÑий Ð½Ð°Ð±Ð¾Ñ Ð´ÑÑгого</td> 391</tr> 392<tr> 393<td><a href="https://oracleplsql.ru/except-sql.html">EXCEPT</a></td> 394<td>ÐÐ°Ð±Ð¾Ñ ÑезÑлÑÑаÑов одного минÑÑ Ð½Ð°Ð±Ð¾Ñ ÑезÑлÑÑаÑов дÑÑгого</td> 395</tr> 396<tr> 397<td><a href="https://oracleplsql.ru/joins-sql.html">JOIN</a></td> 398<td>Соединение ÑаблиÑ</td> 399</tr> 400<tr> 401<td><a href="https://oracleplsql.ru/distinct-sql.html">DISTINCT</a></td> 402<td>ÐолÑÑиÑÑ ÑникалÑнÑе запиÑи</td> 403</tr> 404<tr> 405<td><a href="https://oracleplsql.ru/from-sql.html">FROM</a></td> 406<td>СпиÑок ÑаблиÑÑ Ð¸ JOIN инÑоÑмаÑиÑ</td> 407</tr> 408<tr> 409<td><a href="https://oracleplsql.ru/where-sql.html">WHERE</a></td> 410<td>ФилÑÑÑ ÑезÑлÑÑаÑов</td> 411</tr> 412<tr> 413<td><a href="https://oracleplsql.ru/order-by-sql.html">ORDER BY</a></td> 414<td>СоÑÑиÑоваÑÑ ÑезÑлÑÑаÑÑ Ð·Ð°Ð¿ÑоÑа</td> 415</tr> 416<tr> 417<td><a href="https://oracleplsql.ru/group-by-sql.html">GROUP BY</a></td> 418<td>ÐÑÑппиÑоваÑÑ Ð¿Ð¾ Ð¾Ð´Ð½Ð¾Ð¼Ñ Ð¸Ð»Ð¸ неÑколÑким ÑÑолбÑам</td> 419</tr> 420<tr> 421<td><a href="https://oracleplsql.ru/having-sql.html">HAVING</a></td> 422<td>ÐгÑаниÑиÑÑ Ð³ÑÑÐ¿Ð¿Ñ Ð²Ð¾Ð·Ð²ÑаÑаемÑÑ ÑÑÑок</td> 423</tr> 424</tbody> 425</table> 426<h2>ТаблиÑÑ Ð¸ пÑедÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ SQL</h2> 427<table> 428<tbody> 429<tr> 430<td><a href="https://oracleplsql.ru/create-table-sql.html">CREATE TABLE</a></td> 431<td>СоздаÑÑ ÑаблиÑÑ</td> 432</tr> 433<tr> 434<td><a href="https://oracleplsql.ru/create-table-as-sql.html">CREATE TABLE AS</a></td> 435<td>СоздаÑÑ ÑаблиÑÑ Ð¸Ð· опÑÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ Ð¸ даннÑÑ Ð´ÑÑгой ÑаблиÑÑ</td> 436</tr> 437<tr> 438<td><a href="https://oracleplsql.ru/alter-table-sql.html">ALTER TABLE</a></td> 439<td>ÐобавиÑÑ, измениÑÑ Ð¸Ð»Ð¸ ÑдалиÑÑ ÑÑолбÑÑ Ð² ÑаблиÑе; пеÑеименоваÑÑ ÑаблиÑÑ</td> 440</tr> 441<tr> 442<td><a href="https://oracleplsql.ru/drop-table-sql.html">DROP TABLE</a></td> 443<td>УдалиÑÑ ÑаблиÑÑ</td> 444</tr> 445<tr> 446<td><a href="https://oracleplsql.ru/sql-global-temp-tables.html">GLOBAL TEMP Tables</a></td> 447<td>ТаблиÑÑ, коÑоÑÑе ÑазлиÑÐ½Ñ Ð² ÑÐ°Ð¼ÐºÐ°Ñ ÑеанÑа SQL</td> 448</tr> 449<tr> 450<td><a href="https://oracleplsql.ru/sql-local-temp-tables.html">LOCAL TEMP Tables</a></td> 451<td>ТаблиÑÑ, коÑоÑÑе ÑазлиÑаÑÑÑÑ Ð² модÑлÑÑ Ð¸ вÑÑÑоенной пÑогÑамме SQL</td> 452</tr> 453<tr> 454<td><a href="https://oracleplsql.ru/view-sql.html">SQL VIEW</a></td> 455<td>ÐиÑÑÑалÑнÑе ÑаблиÑÑ (пÑедÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´ÑÑÐ³Ð¸Ñ ÑаблиÑ)</td> 456</tr> 457</tbody> 458</table> 459<h2>SQL клÑÑи, индекÑÑ</h2> 460<table> 461<tbody> 462<tr> 463<td><a href="https://oracleplsql.ru/primary-keys-sql.html">Primary Keys</a></td> 464<td>Создание или Ñдаление пеÑвиÑнÑÑ ÐºÐ»ÑÑей.</td> 465</tr> 466<tr> 467<td>
467<a href="https://oracleplsql.ru/indexes-sql.html">Indexes</a></td> 468<td>Создание и Ñдаление индекÑов (наÑÑÑойка пÑоизводиÑелÑноÑÑи)</td> 469</tr> 470</tbody> 471</table> 472<h2>ÐпеÑаÑоÑÑ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ñ SQL</h2> 473<table> 474<tbody> 475<tr> 476<td><a href="https://oracleplsql.ru/comparison-operators-sql.html">Comparison operators</a></td> 477<td>ÐпеÑаÑоÑÑ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ñ Ñакие как =, !=, <>, >, >=, <, <= и Ñ.д.</td> 478</tr> 479</tbody> 480</table> 481<h2>SQL ÑÑловиÑ</h2> 482<table> 483<tbody> 484<tr> 485<td><a href="https://oracleplsql.ru/and-sql.html">AND</a></td> 486<td>2 или более ÑÑловиÑ, коÑоÑÑе Ð´Ð¾Ð»Ð¶Ð½Ñ Ð±ÑÑÑ Ð²ÑполненÑ</td> 487</tr> 488<tr> 489<td><a href="https://oracleplsql.ru/or-sql.html">OR</a></td> 490<td>ÐÑбое из ÑÑловий вÑполнено</td> 491</tr> 492<tr> 493<td><a href="https://oracleplsql.ru/and-or-sql.html">AND Ð OR</a></td> 494<td>СоÑеÑание ÑÑловий AND Ð OR</td> 495</tr> 496<tr> 497<td><a href="https://oracleplsql.ru/like-sql.html">LIKE</a></td> 498<td>ÐÑполÑзÑйÑе подÑÑановоÑнÑе знаки в пÑедложении WHERE</td> 499</tr> 500<tr> 501<td><a href="https://oracleplsql.ru/in-sql.html">IN</a></td> 502<td>СооÑвеÑÑÑвие вÑÑÐ°Ð¶ÐµÐ½Ð¸Ñ ÑпиÑÐºÑ Ð·Ð½Ð°Ñений</td> 503</tr> 504<tr> 505<td><a href="https://oracleplsql.ru/not-sql.html">NOT</a></td> 506<td>ÐÑÑиÑание </td> 507</tr> 508<tr> 509<td><a href="https://oracleplsql.ru/is-null-sql.html">IS NULL</a></td> 510<td>ÐÑовеÑка знаÑÐµÐ½Ð¸Ñ Ð½Ð° NULL</td> 511</tr> 512<tr> 513<td><a href="https://oracleplsql.ru/is-not-null-sql.html">IS NOT NULL</a></td> 514<td>ÐÑовеÑка знаÑÐµÐ½Ð¸Ñ Ð½Ð° NOT NULL</td> 515</tr> 516<tr> 517<td><a href="https://oracleplsql.ru/between-sql.html">BETWEEN</a></td> 518<td>ÐÑбоÑка в пÑÐµÐ´ÐµÐ»Ð°Ñ Ð´Ð¸Ð°Ð¿Ð°Ð·Ð¾Ð½Ð° (вклÑÑиÑелÑно)</td> 519</tr> 520<tr> 521<td><a href="https://oracleplsql.ru/exists-sql.html">EXISTS</a></td> 522<td>УÑловие вÑполнÑеÑÑÑ, еÑли подзапÑÐ¾Ñ Ð²Ð¾Ð·Ð²ÑаÑÐ°ÐµÑ Ñ Ð¾ÑÑ Ð±Ñ Ð¾Ð´Ð½Ñ ÑÑÑокÑ</td> 523</tr> 524</tbody> 525</table> 526<h2>ÐÑогÑаммиÑование SQL</h2> 527<table> 528<tbody> 529<tr> 530<td><a href="https://oracleplsql.ru/comments-sql.html">Comments</a></td> 531<td>Ðак ÑоздаваÑÑ ÐºÐ¾Ð¼Ð¼ÐµÐ½ÑаÑии в ваÑем коде SQL</td> 532</tr> 533</tbody> 534</table> 535<h2>Ð¢Ð¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ SQL</h2> 536<table> 537<tbody> 538<tr> 539<td><a href="https://oracleplsql.ru/data-types-sql.html">Data Types</a></td> 540<td>Ð¢Ð¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² SQL</td> 541</tr> 542</tbody> 543</table> 544<h2>ÐÑÐµÐ²Ð´Ð¾Ð½Ð¸Ð¼Ñ SQL</h2> 545<table> 546<tbody> 547<tr> 548<td><a href="https://oracleplsql.ru/aliases-sql.html">ALIASES</a></td> 549<td>Создание вÑеменного имени Ð´Ð»Ñ ÑÑолбÑа или ÑаблиÑÑ</td> 550</tr> 551</tbody> 552</table> 553<h2>ÐиÑеÑÐ°Ð»Ñ SQL</h2> 554<table> 555<tbody> 556<tr> 557<td><a href="https://oracleplsql.ru/literals-sql.html">LITERALS</a></td> 558<td>ÐиÑеÑÐ°Ð»Ñ Ñакие как string, integer, decimal и datetime.</td> 559</tr> 560</tbody> 561</table> 562<h2>ФÑнкÑии SQL </h2> 563<table> 564<tbody> 565<tr> 566<td><a href="https://oracleplsql.ru/count-sql.html">COUNT</a></td> 567<td>ÐозвÑаÑÐ°ÐµÑ ÐºÐ¾Ð»Ð¸ÑеÑÑво вÑÑажений</td> 568</tr> 569<tr> 570<td><a href="https://oracleplsql.ru/sum-sql.html">SUM</a></td> 571<td>ÐозвÑаÑÐ°ÐµÑ ÑÑÐ¼Ð¼Ñ Ð²ÑÑажениÑ</td> 572</tr> 573<tr> 574<td><a href="https://oracleplsql.ru/min-sql.html">MIN</a></td> 575<td>ÐозвÑаÑÐ°ÐµÑ Ð¼Ð¸Ð½Ð¸Ð¼Ñм вÑÑажениÑ</td> 576</tr> 577<tr> 578<td><a href="https://oracleplsql.ru/max-sql.html">MAX</a></td> 579<td>ÐозвÑаÑÐ°ÐµÑ Ð¼Ð°ÐºÑимÑм вÑÑажениÑ</td> 580</tr> 581<tr> 582<td><a href="https://oracleplsql.ru/avg-sql.html">AVG</a></td> 583<td>ÐозвÑаÑÐ°ÐµÑ ÑÑеднее знаÑение вÑÑажениÑ</td> 584</tr> 585</tbody> 586</table> 587 </div><!-- .entry-content --> 588 589 <footer class="entry-meta"> 590 <span class="cat-links"> 591 Ð ÑбÑика: <a href="https://oracleplsql.ru/category/sql-language" rel="category tag">SQL - опиÑание</a> </span> 592 593 594 <span class="sep"> | </span> 595 <span class="permalink"><a href="https://oracleplsql.ru/sql-language.html" rel="bookmark" title="ÐÑÑÐ¼Ð°Ñ ÑÑÑлка на SQL - опиÑание">Permalink</a></span> 596 </footer><!-- .entry-meta --> 597<div class="gt_ct">
598<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
598 599<!-- Oracleplsql.ru (низ ÑÑаÑÑÑ) 728 x 90 --> 600<style> 601.orclplsql_adapt_mobile_bottom { width: 320px; height: 100px; } 602@media(min-width: 500px) { .orclplsql_adapt_mobile_bottom { width: 468px; height: 60px; } } 603@media(min-width: 800px) { .orclplsql_adapt_mobile_bottom { width: 728px; height: 90px; } } 604</style> 605<ins class="adsbygoogle orclplsql_adapt_mobile_bottom" 606 style="display:block" 607 data-ad-client="ca-pub-8777261894857145" 608 data-ad-slot="6588458128" 609 data-ad-format="auto" 610 data-full-width-responsive="true"></ins>
611<script> 612 (adsbygoogle = window.adsbygoogle || []).push({}); 613</script>
613 614</div> 615<!--<input type="button" onclick="history.back();" value="Ðазад"/>-->
616<script data-rocketlazyloadscript='//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
616 617<ins class="adsbygoogle" 618 style="display:block" 619 data-ad-format="autorelaxed" 620 data-ad-client="ca-pub-8777261894857145" 621 data-ad-slot="6043257265"></ins>
622<script> 623 (adsbygoogle = window.adsbygoogle || []).push({}); 624</script>
624 625 626</article><!-- #post-2402 --> 627 628 629 630 <nav role="navigation" id="nav-below" class="site-navigation post-navigation"> 631 <h1 class="assistive-text">Post navigation</h1> 632 633 634 <div class="nav-previous"><a href="https://oracleplsql.ru/create-user.html" rel="prev"><span class="meta-nav">«</span> CREATE USER ÐÐÐÐ ÐТÐÐ </a></div> <div class="nav-next"><a href="https://oracleplsql.ru/tables-and-views.html" rel="next">ТаблиÑÑ Ð¸ пÑедÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ <span class="meta-nav">»</span></a></div> 635 636 </nav><!-- #nav-below --> 637 638 639 640 </div><!-- #content .site-content --> 641 </div><!-- #primary .content-area --> 642 643 <div id="secondary" class="widget-area"> 644 <div id="sidebar-1" class="sidebar" role="complementary"> 645 <aside id="custom_html-13" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget">
645<script async src="https://cse.google.com/cse.js?cx=partner-pub-8777261894857145:5121821727"></script>
645 646<div class="gcse-searchbox-only"></div> 647</div></aside><aside id="nav_menu-4" class="widget widget_nav_menu"><h1 class="widget-title">ORACLE PL/SQL</h1><div class="menu-programmirovanie-oracle-plsql-container"><ul id="menu-programmirovanie-oracle-plsql" class="menu"><li id="menu-item-2217" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2217"><a href="https://oracleplsql.ru/procedures.html">ÐÑоÑедÑÑÑ</a></li> 648<li id="menu-item-2218" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2218"><a href="https://oracleplsql.ru/functions.html">ФÑнкÑии</a></li> 649<li id="menu-item-2216" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2216"><a href="https://oracleplsql.ru/triggers.html">ТÑиггеÑÑ</a></li> 650<li id="menu-item-7466" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7466"><a href="https://oracleplsql.ru/collections-and-records-oracle-plsql.html">ÐоллекÑии и запиÑи</a></li> 651<li id="menu-item-2246" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2246"><a href="https://oracleplsql.ru/cursors.html">ÐÑÑÑоÑÑ</a></li> 652<li id="menu-item-7709" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7709"><a href="https://oracleplsql.ru/packages-oracle-plsql.html">ÐакеÑÑ</a></li> 653<li id="menu-item-8217" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-8217"><a href="https://oracleplsql.ru/dynamic-sql.html">ÐинамиÑеÑкий SQL</a></li> 654<li id="menu-item-2353" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2353"><a href="https://oracleplsql.ru/sequences.html">ÐоÑледоваÑелÑноÑÑи</a></li> 655<li id="menu-item-2540" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2540"><a href="https://oracleplsql.ru/tables-and-views.html">ТаблиÑÑ Ð¸ пÑедÑÑавлениÑ</a></li> 656<li id="menu-item-2677" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2677"><a href="https://oracleplsql.ru/datatypes.html">Ð¢Ð¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ </a></li> 657<li id="menu-item-2449" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2449"><a href="https://oracleplsql.ru/transactions.html">ТÑанзакÑии</a></li> 658<li id="menu-item-2316" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2316"><a href="https://oracleplsql.ru/conditional-statements.html">УÑловнÑе опеÑаÑоÑÑ</a></li> 659<li id="menu-item-2340" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2340"><a href="https://oracleplsql.ru/loops.html">ЦиклÑ</a></li> 660<li id="menu-item-8302" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-8302"><a href="https://oracleplsql.ru/anonymous-block-plsql.html">Ðлоки PL/SQL</a></li> 661</ul></div></aside><aside id="nav_menu-2" class="widget widget_nav_menu"><h1 class="widget-title">ФУÐÐЦÐÐ ORACLE/PLSQL</h1><div class="menu-funkczii-oracle-pl-sql-container"><ul id="menu-funkczii-oracle-pl-sql" class="menu"><li id="menu-item-4" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-4"><a href="https://oracleplsql.ru/" title="function category">Ðо каÑегоÑиÑм</a></li> 662<li id="menu-item-7402" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7402"><a href="https://oracleplsql.ru/analytic.html">ÐналиÑиÑеÑкие</a></li> 663<li id="menu-item-7405" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7405"><a href="https://oracleplsql.ru/string-character.html">СимволÑнÑе / ÑÑÑоковÑе</a></li> 664<li id="menu-item-7406" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7406"><a href="https://oracleplsql.ru/numeric-mathematical.html">ЧиÑловÑе / маÑемаÑиÑеÑкие</a></li> 665<li id="menu-item-7403" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7403"><a href="https://oracleplsql.ru/date-time.html">ÐаÑа / вÑемÑ</a></li> 666<li id="menu-item-7407" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7407"><a href="https://oracleplsql.ru/conversion.html">ÐÑеобÑазование</a></li> 667<li id="menu-item-7404" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7404"><a href="https://oracleplsql.ru/advanced-function.html">ÐÑпомогаÑелÑнÑе</a></li> 668</ul></div></aside><aside id="custom_html-14" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget">
668<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
668 669<!-- Oracleplsql.ru боковой 300Ñ 600 --> 670<ins class="adsbygoogle" 671 style="display:block" 672 data-ad-client="ca-pub-8777261894857145" 673 data-ad-slot="1425058522" 674 data-ad-format="auto"></ins>
675<script> 676 (adsbygoogle = window.adsbygoogle || []).push({}); 677</script>
677 678 679<!-- hit.ua --> 680<a href='http://hit.ua/?x=128731' target='_blank'>
681<script language="javascript" type="text/javascript"><!-- 682Cd=document;Cr="&"+Math.random();Cp="&s=1"; 683Cd.cookie="b=b";if(Cd.cookie)Cp+="&c=1"; 684Cp+="&t="+(new Date()).getTimezoneOffset(); 685if(self!=top)Cp+="&f=1"; 686//--></script>
vendor: 2 bytes, line 686
686
687<script language="javascript1.1" type="text/javascript"><!-- 688if(navigator.javaEnabled())Cp+="&j=1"; 689//--></script>
vendor: 2 bytes, line 689
689
690<script language="javascript1.2" type="text/javascript"><!-- 691if(typeof(screen)!='undefined')Cp+="&w="+screen.width+"&h="+ 692screen.height+"&d="+(screen.colorDepth?screen.colorDepth:screen.pixelDepth); 693//--></script>
vendor: 2 bytes, line 693
693
694<script language="javascript" type="text/javascript"><!-- 695Cd.write("<sc"+"ript src='//c.hit.ua/hit?i=128731&g=0&x=3"+Cp+Cr+ 696"&r="+escape(Cd.referrer)+"&u="+escape(window.location.href)+"'></sc"+"ript>"); 697//--></script>
697</a> 698<!-- / hit.ua --> 699 700<!-- Yandex.Metrika counter --> 701 702<noscript><div><img src="https://mc.yandex.ru/watch/26721072" style="position:absolute; left:-9999px;" alt="" /></div></noscript> 703<!-- /Yandex.Metrika counter --> 704</div></aside> </div><!-- #sidebar-right --> 705 706 </div> 707 708 </div><!-- #main .site-main --> 709 710 <footer id="colophon" class="site-footer" role="contentinfo"> 711 <div class="site-info"> 712 <div>© 2014-2026 Oracle PL/SQL</div> </div> 713 </footer><!-- #colophon .site-footer --> 714</div><!-- #page .hfeed .site --> 715
716<script type="speculationrules"> 717{"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/*"},{"not":{"href_matches":["/wp-*.php","/wp-admin/*","/wp-content/uploads/*","/wp-content/*","/wp-content/plugins/*","/wp-content/themes/f2/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]} 718</script>
vendor: 1 bytes, line 718
718
719<script id="rocket-browser-checker-js-after"> 720"use strict";var _createClass=function(){function defineProperties(target,props){for(var i=0;i<props.length;i++){var descriptor=props[i];descriptor.enumerable=descriptor.enumerable||!1,descriptor.configurable=!0,"value"in descriptor&&(descriptor.writable=!0),Object.defineProperty(target,descriptor.key,descriptor)}}return function(Constructor,protoProps,staticProps){return protoProps&&defineProperties(Constructor.prototype,protoProps),staticProps&&defineProperties(Constructor,staticProps),Constructor}}();function _classCallCheck(instance,Constructor){if(!(instance instanceof Constructor))throw new TypeError("Cannot call a class as a function")}var RocketBrowserCompatibilityChecker=function(){function RocketBrowserCompatibilityChecker(options){_classCallCheck(this,RocketBrowserCompatibilityChecker),this.passiveSupported=!1,this._checkPassiveOption(this),this.options=!!this.passiveSupported&&options}return _createClass(RocketBrowserCompatibilityChecker,[{key:"_checkPassiveOption",value:function(self){try{var options={get passive(){return!(self.passiveSupported=!0)}};window.addEventListener("test",null,options),window.removeEventListener("test",null,options)}catch(err){self.passiveSupported=!1}}},{key:"initRequestIdleCallback",value:function(){!1 in window&&(window.requestIdleCallback=function(cb){var start=Date.now();return setTimeout(function(){cb({didTimeout:!1,timeRemaining:function(){return Math.max(0,50-(Date.now()-start))}})},1)}),!1 in window&&(window.cancelIdleCallback=function(id){return clearTimeout(id)})}},{key:"isDataSaverModeOn",value:function(){return"connection"in navigator&&!0===navigator.connection.saveData}},{key:"supportsLinkPrefetch",value:function(){var elem=document.createElement("link");return elem.relList&&elem.relList.supports&&elem.relList.supports("prefetch")&&window.IntersectionObserver&&"isIntersecting"in IntersectionObserverEntry.prototype}},{key:"isSlowConnection",value:function(){return"connection"in navigator&&"effectiveType"in navigator.connection&&("2g"===navigator.connection.effectiveType||"slow-2g"===navigator.connection.effectiveType)}}]),RocketBrowserCompatibilityChecker}(); 721//# sourceURL=rocket-browser-checker-js-after 722</script>
vendor: 1 bytes, line 722
722
723<script id="rocket-delay-js-js-after"> 724(function() { 725"use strict";var e=function(){function n(e,t){for(var r=0;r<t.length;r++){var n=t[r];n.enumerable=n.enumerable||!1,n.configurable=!0,"value"in n&&(n.writable=!0),Object.defineProperty(e,n.key,n)}}return function(e,t,r){return t&&n(e.prototype,t),r&&n(e,r),e}}();function n(e,t){if(!(e instanceof t))throw new TypeError("Cannot call a class as a function")}var t=function(){function r(e,t){n(this,r),this.attrName="data-rocketlazyloadscript",this.browser=t,this.options=this.browser.options,this.triggerEvents=e,this.userEventListener=this.triggerListener.bind(this)}return e(r,[{key:"init",value:function(){this._addEventListener(this)}},{key:"reset",value:function(){this._removeEventListener(this)}},{key:"_addEventListener",value:function(t){this.triggerEvents.forEach(function(e){return window.addEventListener(e,t.userEventListener,t.options)})}},{key:"_removeEventListener",value:function(t){this.triggerEvents.forEach(function(e){return window.removeEventListener(e,t.userEventListener,t.options)})}},{key:"_loadScriptSrc",value:function(){var r=this,e=document.querySelectorAll("script["+this.attrName+"]");0!==e.length&&Array.prototype.slice.call(e).forEach(function(e){var t=e.getAttribute(r.attrName);e.setAttribute("src",t),e.removeAttribute(r.attrName)}),this.reset()}},{key:"triggerListener",value:function(){this._loadScriptSrc(),this._removeEventListener(this)}}],[{key:"run",value:function(){RocketBrowserCompatibilityChecker&&new r(["keydown","mouseover","touchmove","touchstart"],new RocketBrowserCompatibilityChecker({passive:!0})).init()}}]),r}();t.run(); 726}()); 727 728//# sourceURL=rocket-delay-js-js-after 729</script>
729 730 731
732<script>window.lazyLoadOptions={elements_selector:"img[data-lazy-src],.rocket-lazyload",data_src:"lazy-src",data_srcset:"lazy-srcset",data_sizes:"lazy-sizes",class_loading:"lazyloading",class_loaded:"lazyloaded",threshold:300,callback_loaded:function(element){if(element.tagName==="IFRAME"&&element.dataset.rocketLazyload=="fitvidscompatible"){if(element.classList.contains("lazyloaded")){if(typeof window.jQuery!="undefined"){if(jQuery.fn.fitVids){jQuery(element).parent().fitVids()}}}}}};window.addEventListener('LazyLoad::Initialized',function(e){var lazyLoadInstance=e.detail.instance;if(window.MutationObserver){var observer=new MutationObserver(function(mutations){var image_count=0;var iframe_count=0;var rocketlazy_count=0;mutations.forEach(function(mutation){for(i=0;i<mutation.addedNodes.length;i++){if(typeof mutation.addedNodes[i].getElementsByTagName!=='function'){continue} 733if(typeof mutation.addedNodes[i].getElementsByClassName!=='function'){continue} 734images=mutation.addedNodes[i].getElementsByTagName('img');is_image=mutation.addedNodes[i].tagName=="IMG";iframes=mutation.addedNodes[i].getElementsByTagName('iframe');is_iframe=mutation.addedNodes[i].tagName=="IFRAME";rocket_lazy=mutation.addedNodes[i].getElementsByClassName('rocket-lazyload');image_count+=images.length;iframe_count+=iframes.length;rocketlazy_count+=rocket_lazy.length;if(is_image){image_count+=1} 735if(is_iframe){iframe_count+=1}}});if(image_count>0||iframe_count>0||rocketlazy_count>0){lazyLoadInstance.update()}});var b=document.getElementsByTagName("body")[0];var config={childList:!0,subtree:!0};observer.observe(b,config)}},!1)</script>
735<script data-no-minify="1" async src="https://oracleplsql.ru/wp-content/plugins/wp-rocket/assets/js/lazyload/16.1/lazyload.min.js"></script>
vendor: 1 bytes, line 735
735
736<script src="https://oracleplsql.ru/wp-content/cache/min/1/c399ab51200a46594e69f0c96581fa81.js" data-minify="1" defer></script>
736</body> 737</html> 738<!-- This website is like a Rocket, isn't it? Performance optimized by WP Rocket. Learn more: https://wp-rocket.me - Debug: cached@1791179605 -->
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.