javarevisited.blogspot.com
Open in
urlscan Pro
2a00:1450:4001:830::2001
Public Scan
Submitted URL: https://go.jetbrains.com/NDI2LVFWRC0xMTQAAAGHPLP_kznmN55bdaJZLxoNYAFBmA_nHuQsc30AicIuAQXnL2pf-cjc8bpoReD9j5E6IqTv96g=
Effective URL: https://javarevisited.blogspot.com/2017/03/difference-between-sql-tsql-and-plsql.html?mkt_tok=NDI2LVFWRC0xMTQAAAGHPLP_kzgtwQmj433e5...
Submission: On October 06 via api from BE — Scanned from DE
Effective URL: https://javarevisited.blogspot.com/2017/03/difference-between-sql-tsql-and-plsql.html?mkt_tok=NDI2LVFWRC0xMTQAAAGHPLP_kzgtwQmj433e5...
Submission: On October 06 via api from BE — Scanned from DE
Form analysis 4 forms found in the DOM
POST https://app.convertkit.com/forms/2154158/subscriptions
<form action="https://app.convertkit.com/forms/2154158/subscriptions" style="background-color:#ffffff;border-radius:10px" class="seva-form formkit-form" method="post" data-sv-form="2154158" data-uid="af4786bced" data-format="inline" data-version="5"
min-width="400 500 600">
<div data-style="full">
<div data-element="column" style="background-image:url('https://embed.filekitcdn.com/e/kFeARw9Z6Loq6RFhVkpEfT/jTQqyWF1nYP7pQ8aXM3Shv');opacity:0.94" class="formkit-background"></div>
<div data-element="column" class="formkit-column">
<div class="formkit-header" style="color:#373F45;font-weight:700;font-size:29px" data-element="header">
<h2 style="text-align:left">Preparing for Java Developer Interviews?</h2>
</div>
<ul class="formkit-alert formkit-alert-error" data-element="errors" data-group="alert"></ul>
<div data-element="fields" class="seva-fields formkit-fields">
<div class="formkit-field"><input type="text" class="formkit-input" name="email_address" style="color:#697177;background-color:#F3F6F9;border-radius:5px;font-weight:400;border-color:#e3e3e3" aria-label="Email Address"
placeholder="Email Address" required=""></div><button data-element="submit" class="formkit-submit formkit-submit" style="color:#ffffff;background-color:#785EDF;border-radius:5px;font-weight:700">
<div class="formkit-spinner">
<div></div>
<div></div>
<div></div>
</div><span class="">Download Free Questions</span>
</button>
</div>
<div class="formkit-disclaimer" style="color:#697177;font-size:13px" data-element="disclaimer">
<p>We respect your privacy. Unsubscribe at any time.</p>
</div>
<div class="formkit-powered-by-convertkit-container">
<a href="https://convertkit.com?utm_campaign=poweredby&utm_content=form&utm_medium=referral&utm_source=dynamic" data-element="powered-by" class="formkit-powered-by-convertkit" data-variant="dark" target="_blank" rel="noopener noreferrer">Built with ConvertKit</a>
</div>
</div>
</div>
<style>
.formkit-form[data-uid="af4786bced"] * {
box-sizing: border-box;
}
.formkit-form[data-uid="af4786bced"] {
-webkit-font-smoothing: antialiased;
-moz-osx-font-smoothing: grayscale;
}
.formkit-form[data-uid="af4786bced"] legend {
border: none;
font-size: inherit;
margin-bottom: 10px;
padding: 0;
position: relative;
display: table;
}
.formkit-form[data-uid="af4786bced"] fieldset {
border: 0;
padding: 0.01em 0 0 0;
margin: 0;
min-width: 0;
}
.formkit-form[data-uid="af4786bced"] body:not(:-moz-handler-blocked) fieldset {
display: table-cell;
}
.formkit-form[data-uid="af4786bced"] h1,
.formkit-form[data-uid="af4786bced"] h2,
.formkit-form[data-uid="af4786bced"] h3,
.formkit-form[data-uid="af4786bced"] h4,
.formkit-form[data-uid="af4786bced"] h5,
.formkit-form[data-uid="af4786bced"] h6 {
color: inherit;
font-size: inherit;
font-weight: inherit;
}
.formkit-form[data-uid="af4786bced"] p {
color: inherit;
font-size: inherit;
font-weight: inherit;
}
.formkit-form[data-uid="af4786bced"] ol:not([template-default]),
.formkit-form[data-uid="af4786bced"] ul:not([template-default]),
.formkit-form[data-uid="af4786bced"] blockquote:not([template-default]) {
text-align: left;
}
.formkit-form[data-uid="af4786bced"] p:not([template-default]),
.formkit-form[data-uid="af4786bced"] hr:not([template-default]),
.formkit-form[data-uid="af4786bced"] blockquote:not([template-default]),
.formkit-form[data-uid="af4786bced"] ol:not([template-default]),
.formkit-form[data-uid="af4786bced"] ul:not([template-default]) {
color: inherit;
font-style: initial;
}
.formkit-form[data-uid="af4786bced"] .ordered-list,
.formkit-form[data-uid="af4786bced"] .unordered-list {
list-style-position: outside !important;
padding-left: 1em;
}
.formkit-form[data-uid="af4786bced"] .list-item {
padding-left: 0;
}
.formkit-form[data-uid="af4786bced"][data-format="modal"] {
display: none;
}
.formkit-form[data-uid="af4786bced"][data-format="slide in"] {
display: none;
}
.formkit-form[data-uid="af4786bced"][data-format="sticky bar"] {
display: none;
}
.formkit-sticky-bar .formkit-form[data-uid="af4786bced"][data-format="sticky bar"] {
display: block;
}
.formkit-form[data-uid="af4786bced"] .formkit-input,
.formkit-form[data-uid="af4786bced"] .formkit-select,
.formkit-form[data-uid="af4786bced"] .formkit-checkboxes {
width: 100%;
}
.formkit-form[data-uid="af4786bced"] .formkit-button,
.formkit-form[data-uid="af4786bced"] .formkit-submit {
border: 0;
border-radius: 5px;
color: #ffffff;
cursor: pointer;
display: inline-block;
text-align: center;
font-size: 15px;
font-weight: 500;
cursor: pointer;
margin-bottom: 15px;
overflow: hidden;
padding: 0;
position: relative;
vertical-align: middle;
}
.formkit-form[data-uid="af4786bced"] .formkit-button:hover,
.formkit-form[data-uid="af4786bced"] .formkit-submit:hover,
.formkit-form[data-uid="af4786bced"] .formkit-button:focus,
.formkit-form[data-uid="af4786bced"] .formkit-submit:focus {
outline: none;
}
.formkit-form[data-uid="af4786bced"] .formkit-button:hover>span,
.formkit-form[data-uid="af4786bced"] .formkit-submit:hover>span,
.formkit-form[data-uid="af4786bced"] .formkit-button:focus>span,
.formkit-form[data-uid="af4786bced"] .formkit-submit:focus>span {
background-color: rgba(0, 0, 0, 0.1);
}
.formkit-form[data-uid="af4786bced"] .formkit-button>span,
.formkit-form[data-uid="af4786bced"] .formkit-submit>span {
display: block;
-webkit-transition: all 300ms ease-in-out;
transition: all 300ms ease-in-out;
padding: 12px 24px;
}
.formkit-form[data-uid="af4786bced"] .formkit-input {
background: #ffffff;
font-size: 15px;
padding: 12px;
border: 1px solid #e3e3e3;
-webkit-flex: 1 0 auto;
-ms-flex: 1 0 auto;
flex: 1 0 auto;
line-height: 1.4;
margin: 0;
-webkit-transition: border-color ease-out 300ms;
transition: border-color ease-out 300ms;
}
.formkit-form[data-uid="af4786bced"] .formkit-input:focus {
outline: none;
border-color: #1677be;
-webkit-transition: border-color ease 300ms;
transition: border-color ease 300ms;
}
.formkit-form[data-uid="af4786bced"] .formkit-input::-webkit-input-placeholder {
color: inherit;
opacity: 0.8;
}
.formkit-form[data-uid="af4786bced"] .formkit-input::-moz-placeholder {
color: inherit;
opacity: 0.8;
}
.formkit-form[data-uid="af4786bced"] .formkit-input:-ms-input-placeholder {
color: inherit;
opacity: 0.8;
}
.formkit-form[data-uid="af4786bced"] .formkit-input::placeholder {
color: inherit;
opacity: 0.8;
}
.formkit-form[data-uid="af4786bced"] [data-group="dropdown"] {
position: relative;
display: inline-block;
width: 100%;
}
.formkit-form[data-uid="af4786bced"] [data-group="dropdown"]::before {
content: "";
top: calc(50% - 2.5px);
right: 10px;
position: absolute;
pointer-events: none;
border-color: #4f4f4f transparent transparent transparent;
border-style: solid;
border-width: 6px 6px 0 6px;
height: 0;
width: 0;
z-index: 999;
}
.formkit-form[data-uid="af4786bced"] [data-group="dropdown"] select {
height: auto;
width: 100%;
cursor: pointer;
color: #333333;
line-height: 1.4;
margin-bottom: 0;
padding: 0 6px;
-webkit-appearance: none;
-moz-appearance: none;
appearance: none;
font-size: 15px;
padding: 12px;
padding-right: 25px;
border: 1px solid #e3e3e3;
background: #ffffff;
}
.formkit-form[data-uid="af4786bced"] [data-group="dropdown"] select:focus {
outline: none;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] {
text-align: left;
margin: 0;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] {
margin-bottom: 10px;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] * {
cursor: pointer;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"]:last-of-type {
margin-bottom: 0;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"] {
display: none;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]+label::after {
content: none;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked+label::after {
border-color: #ffffff;
content: "";
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked+label::before {
background: #10bf7a;
border-color: #10bf7a;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] label {
position: relative;
display: inline-block;
padding-left: 28px;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] label::before,
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] label::after {
position: absolute;
content: "";
display: inline-block;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] label::before {
height: 16px;
width: 16px;
border: 1px solid #e3e3e3;
background: #ffffff;
left: 0px;
top: 3px;
}
.formkit-form[data-uid="af4786bced"] [data-group="checkboxes"] [data-group="checkbox"] label::after {
height: 4px;
width: 8px;
border-left: 2px solid #4d4d4d;
border-bottom: 2px solid #4d4d4d;
-webkit-transform: rotate(-45deg);
-ms-transform: rotate(-45deg);
transform: rotate(-45deg);
left: 4px;
top: 8px;
}
.formkit-form[data-uid="af4786bced"] .formkit-alert {
background: #f9fafb;
border: 1px solid #e3e3e3;
border-radius: 5px;
-webkit-flex: 1 0 auto;
-ms-flex: 1 0 auto;
flex: 1 0 auto;
list-style: none;
margin: 25px auto;
padding: 12px;
text-align: center;
width: 100%;
}
.formkit-form[data-uid="af4786bced"] .formkit-alert:empty {
display: none;
}
.formkit-form[data-uid="af4786bced"] .formkit-alert-success {
background: #d3fbeb;
border-color: #10bf7a;
color: #0c905c;
}
.formkit-form[data-uid="af4786bced"] .formkit-alert-error {
background: #fde8e2;
border-color: #f2643b;
color: #ea4110;
}
.formkit-form[data-uid="af4786bced"] .formkit-spinner {
display: -webkit-box;
display: -webkit-flex;
display: -ms-flexbox;
display: flex;
height: 0px;
width: 0px;
margin: 0 auto;
position: absolute;
top: 0;
left: 0;
right: 0;
width: 0px;
overflow: hidden;
text-align: center;
-webkit-transition: all 300ms ease-in-out;
transition: all 300ms ease-in-out;
}
.formkit-form[data-uid="af4786bced"] .formkit-spinner>div {
margin: auto;
width: 12px;
height: 12px;
background-color: #fff;
opacity: 0.3;
border-radius: 100%;
display: inline-block;
-webkit-animation: formkit-bouncedelay-formkit-form-data-uid-af4786bced- 1.4s infinite ease-in-out both;
animation: formkit-bouncedelay-formkit-form-data-uid-af4786bced- 1.4s infinite ease-in-out both;
}
.formkit-form[data-uid="af4786bced"] .formkit-spinner>div:nth-child(1) {
-webkit-animation-delay: -0.32s;
animation-delay: -0.32s;
}
.formkit-form[data-uid="af4786bced"] .formkit-spinner>div:nth-child(2) {
-webkit-animation-delay: -0.16s;
animation-delay: -0.16s;
}
.formkit-form[data-uid="af4786bced"] .formkit-submit[data-active] .formkit-spinner {
opacity: 1;
height: 100%;
width: 50px;
}
.formkit-form[data-uid="af4786bced"] .formkit-submit[data-active] .formkit-spinner~span {
opacity: 0;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by[data-active="false"] {
opacity: 0.35;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit-container {
display: -webkit-box;
display: -webkit-flex;
display: -ms-flexbox;
display: flex;
width: 100%;
z-index: 5;
margin: 10px 0;
position: relative;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit-container[data-active="false"] {
opacity: 0.35;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit {
-webkit-align-items: center;
-webkit-box-align: center;
-ms-flex-align: center;
align-items: center;
background-color: #ffffff;
border: 1px solid #dce1e5;
border-radius: 4px;
color: #373f45;
cursor: pointer;
display: block;
height: 36px;
margin: 0 auto;
opacity: 0.95;
padding: 0;
-webkit-text-decoration: none;
text-decoration: none;
text-indent: 100%;
-webkit-transition: ease-in-out all 200ms;
transition: ease-in-out all 200ms;
white-space: nowrap;
overflow: hidden;
-webkit-user-select: none;
-moz-user-select: none;
-ms-user-select: none;
user-select: none;
width: 190px;
background-repeat: no-repeat;
background-position: center;
background-image: url("data:image/svg+xml;charset=utf8,%3Csvg width='162' height='20' viewBox='0 0 162 20' fill='none' xmlns='http://www.w3.org/2000/svg'%3E%3Cpath d='M83.0561 15.2457C86.675 15.2457 89.4722 12.5154 89.4722 9.14749C89.4722 5.99211 86.8443 4.06563 85.1038 4.06563C82.6801 4.06563 80.7373 5.76407 80.4605 8.28551C80.4092 8.75244 80.0387 9.14403 79.5686 9.14069C78.7871 9.13509 77.6507 9.12841 76.9314 9.13092C76.6217 9.13199 76.3658 8.88106 76.381 8.57196C76.4895 6.38513 77.2218 4.3404 78.618 2.76974C80.1695 1.02445 82.4289 0 85.1038 0C89.5979 0 93.8406 4.07791 93.8406 9.14749C93.8406 14.7608 89.1832 19.3113 83.1517 19.3113C78.8502 19.3113 74.5179 16.5041 73.0053 12.5795C72.9999 12.565 72.9986 12.5492 73.0015 12.534C73.0218 12.4179 73.0617 12.3118 73.1011 12.2074C73.1583 12.0555 73.2143 11.907 73.2062 11.7359L73.18 11.1892C73.174 11.0569 73.2075 10.9258 73.2764 10.8127C73.3452 10.6995 73.4463 10.6094 73.5666 10.554L73.7852 10.4523C73.9077 10.3957 74.0148 10.3105 74.0976 10.204C74.1803 10.0974 74.2363 9.97252 74.2608 9.83983C74.3341 9.43894 74.6865 9.14749 75.0979 9.14749C75.7404 9.14749 76.299 9.57412 76.5088 10.1806C77.5188 13.1 79.1245 15.2457 83.0561 15.2457Z' fill='%23373F45'/%3E%3Cpath d='M155.758 6.91365C155.028 6.91365 154.804 6.47916 154.804 5.98857C154.804 5.46997 154.986 5.06348 155.758 5.06348C156.53 5.06348 156.712 5.46997 156.712 5.98857C156.712 6.47905 156.516 6.91365 155.758 6.91365ZM142.441 12.9304V9.32833L141.415 9.32323V8.90392C141.415 8.44719 141.786 8.07758 142.244 8.07986L142.441 8.08095V6.55306L144.082 6.09057V8.08073H145.569V8.50416C145.569 8.61242 145.548 8.71961 145.506 8.81961C145.465 8.91961 145.404 9.01047 145.328 9.08699C145.251 9.16351 145.16 9.2242 145.06 9.26559C144.96 9.30698 144.853 9.32826 144.745 9.32822H144.082V12.7201C144.082 13.2423 144.378 13.4256 144.76 13.4887C145.209 13.5629 145.583 13.888 145.583 14.343V14.9626C144.029 14.9626 142.441 14.8942 142.441 12.9304Z' fill='%23373F45'/%3E%3Cpath d='M110.058 7.92554C108.417 7.88344 106.396 8.92062 106.396 11.5137C106.396 14.0646 108.417 15.0738 110.058 15.0318C111.742 15.0738 113.748 14.0646 113.748 11.5137C113.748 8.92062 111.742 7.88344 110.058 7.92554ZM110.07 13.7586C108.878 13.7586 108.032 12.8905 108.032 11.461C108.032 10.1013 108.878 9.20569 110.071 9.20569C111.263 9.20569 112.101 10.0995 112.101 11.459C112.101 12.8887 111.263 13.7586 110.07 13.7586Z' fill='%23373F45'/%3E%3Cpath d='M118.06 7.94098C119.491 7.94098 120.978 8.33337 120.978 11.1366V14.893H120.063C119.608 14.893 119.238 14.524 119.238 14.0689V10.9965C119.238 9.66506 118.747 9.16047 117.891 9.16047C117.414 9.16047 116.797 9.52486 116.502 9.81915V14.069C116.502 14.1773 116.481 14.2845 116.44 14.3845C116.398 14.4845 116.337 14.5753 116.261 14.6519C116.184 14.7284 116.093 14.7891 115.993 14.8305C115.893 14.8719 115.786 14.8931 115.678 14.8931H114.847V8.10918H115.773C115.932 8.10914 116.087 8.16315 116.212 8.26242C116.337 8.36168 116.424 8.50033 116.46 8.65577C116.881 8.19328 117.428 7.94098 118.06 7.94098ZM122.854 8.09713C123.024 8.09708 123.19 8.1496 123.329 8.2475C123.468 8.34541 123.574 8.48391 123.631 8.64405L125.133 12.8486L126.635 8.64415C126.692 8.48402 126.798 8.34551 126.937 8.2476C127.076 8.1497 127.242 8.09718 127.412 8.09724H128.598L126.152 14.3567C126.091 14.5112 125.986 14.6439 125.849 14.7374C125.711 14.831 125.549 14.881 125.383 14.8809H124.333L121.668 8.09713H122.854Z' fill='%23373F45'/%3E%3Cpath d='M135.085 14.5514C134.566 14.7616 133.513 15.0416 132.418 15.0416C130.496 15.0416 129.024 13.9345 129.024 11.4396C129.024 9.19701 130.451 7.99792 132.191 7.99792C134.338 7.99792 135.254 9.4378 135.158 11.3979C135.139 11.8029 134.786 12.0983 134.38 12.0983H130.679C130.763 13.1916 131.562 13.7662 132.615 13.7662C133.028 13.7662 133.462 13.7452 133.983 13.6481C134.535 13.545 135.085 13.9375 135.085 14.4985V14.5514ZM133.673 10.949C133.785 9.87621 133.061 9.28752 132.191 9.28752C131.321 9.28752 130.734 9.93979 130.679 10.9489L133.673 10.949Z' fill='%23373F45'/%3E%3Cpath d='M137.345 8.11122C137.497 8.11118 137.645 8.16229 137.765 8.25635C137.884 8.35041 137.969 8.48197 138.005 8.62993C138.566 8.20932 139.268 7.94303 139.759 7.94303C139.801 7.94303 140.068 7.94303 140.489 7.99913V8.7265C140.489 9.11748 140.15 9.4147 139.759 9.4147C139.31 9.4147 138.651 9.5829 138.131 9.8773V14.8951H136.462V8.11112L137.345 8.11122ZM156.6 14.0508V8.09104H155.769C155.314 8.09104 154.944 8.45999 154.944 8.9151V14.8748H155.775C156.23 14.8748 156.6 14.5058 156.6 14.0508ZM158.857 12.9447V9.34254H157.749V8.91912C157.749 8.46401 158.118 8.09506 158.574 8.09506H158.857V6.56739L160.499 6.10479V8.09506H161.986V8.51848C161.986 8.97359 161.617 9.34254 161.161 9.34254H160.499V12.7345C160.499 13.2566 160.795 13.44 161.177 13.503C161.626 13.5774 162 13.9024 162 14.3574V14.977C160.446 14.977 158.857 14.9086 158.857 12.9447ZM98.1929 10.1124C98.2033 6.94046 100.598 5.16809 102.895 5.16809C104.171 5.16809 105.342 5.44285 106.304 6.12953L105.914 6.6631C105.654 7.02011 105.16 7.16194 104.749 6.99949C104.169 6.7702 103.622 6.7218 103.215 6.7218C101.335 6.7218 99.9169 7.92849 99.9068 10.1123C99.9169 12.2959 101.335 13.5201 103.215 13.5201C103.622 13.5201 104.169 13.4717 104.749 13.2424C105.16 13.0799 105.654 13.2046 105.914 13.5615L106.304 14.0952C105.342 14.7819 104.171 15.0566 102.895 15.0566C100.598 15.0566 98.2033 13.2842 98.1929 10.1124ZM147.619 5.21768C148.074 5.21768 148.444 5.58663 148.444 6.04174V9.81968L151.82 5.58131C151.897 5.47733 151.997 5.39282 152.112 5.3346C152.227 5.27638 152.355 5.24607 152.484 5.24611H153.984L150.166 10.0615L153.984 14.8749H152.484C152.355 14.8749 152.227 14.8446 152.112 14.7864C151.997 14.7281 151.897 14.6436 151.82 14.5397L148.444 10.3025V14.0508C148.444 14.5059 148.074 14.8749 147.619 14.8749H146.746V5.21768H147.619Z' fill='%23373F45'/%3E%3Cpath d='M0.773438 6.5752H2.68066C3.56543 6.5752 4.2041 6.7041 4.59668 6.96191C4.99219 7.21973 5.18994 7.62695 5.18994 8.18359C5.18994 8.55859 5.09326 8.87061 4.8999 9.11963C4.70654 9.36865 4.42822 9.52539 4.06494 9.58984V9.63379C4.51611 9.71875 4.84717 9.88721 5.05811 10.1392C5.27197 10.3882 5.37891 10.7266 5.37891 11.1543C5.37891 11.7314 5.17676 12.1841 4.77246 12.5122C4.37109 12.8374 3.81152 13 3.09375 13H0.773438V6.5752ZM1.82373 9.22949H2.83447C3.27393 9.22949 3.59473 9.16064 3.79688 9.02295C3.99902 8.88232 4.1001 8.64502 4.1001 8.31104C4.1001 8.00928 3.99023 7.79102 3.77051 7.65625C3.55371 7.52148 3.20801 7.4541 2.7334 7.4541H1.82373V9.22949ZM1.82373 10.082V12.1167H2.93994C3.37939 12.1167 3.71045 12.0332 3.93311 11.8662C4.15869 11.6963 4.27148 11.4297 4.27148 11.0664C4.27148 10.7324 4.15723 10.4849 3.92871 10.3237C3.7002 10.1626 3.35303 10.082 2.88721 10.082H1.82373Z' fill='%23373F45'/%3E%3Cpath d='M13.011 6.5752V10.7324C13.011 11.207 12.9084 11.623 12.7034 11.9805C12.5012 12.335 12.2068 12.6089 11.8201 12.8022C11.4363 12.9927 10.9763 13.0879 10.4402 13.0879C9.6433 13.0879 9.02368 12.877 8.5813 12.4551C8.13892 12.0332 7.91772 11.4531 7.91772 10.7148V6.5752H8.9724V10.6401C8.9724 11.1704 9.09546 11.5615 9.34155 11.8135C9.58765 12.0654 9.96557 12.1914 10.4753 12.1914C11.4656 12.1914 11.9607 11.6714 11.9607 10.6313V6.5752H13.011Z' fill='%23373F45'/%3E%3Cpath d='M15.9146 13V6.5752H16.9649V13H15.9146Z' fill='%23373F45'/%3E%3Cpath d='M19.9255 13V6.5752H20.9758V12.0991H23.696V13H19.9255Z' fill='%23373F45'/%3E%3Cpath d='M28.2828 13H27.2325V7.47607H25.3428V6.5752H30.1724V7.47607H28.2828V13Z' fill='%23373F45'/%3E%3Cpath d='M41.9472 13H40.8046L39.7148 9.16796C39.6679 9.00097 39.6093 8.76074 39.539 8.44727C39.4687 8.13086 39.4262 7.91113 39.4116 7.78809C39.3823 7.97559 39.3339 8.21875 39.2665 8.51758C39.2021 8.81641 39.1479 9.03905 39.1039 9.18554L38.0405 13H36.8979L36.0673 9.7832L35.2236 6.5752H36.2958L37.2143 10.3193C37.3578 10.9199 37.4604 11.4502 37.5219 11.9102C37.5541 11.6611 37.6025 11.3828 37.6669 11.0752C37.7314 10.7676 37.79 10.5186 37.8427 10.3281L38.8886 6.5752H39.9301L41.0024 10.3457C41.1049 10.6943 41.2133 11.2158 41.3276 11.9102C41.3715 11.4912 41.477 10.958 41.644 10.3105L42.558 6.5752H43.6215L41.9472 13Z' fill='%23373F45'/%3E%3Cpath d='M45.7957 13V6.5752H46.846V13H45.7957Z' fill='%23373F45'/%3E%3Cpath d='M52.0258 13H50.9755V7.47607H49.0859V6.5752H53.9155V7.47607H52.0258V13Z' fill='%23373F45'/%3E%3Cpath d='M61.2312 13H60.1765V10.104H57.2146V13H56.1643V6.5752H57.2146V9.20312H60.1765V6.5752H61.2312V13Z' fill='%23373F45'/%3E%3C/svg%3E");
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit:hover,
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit:focus {
background-color: #ffffff;
-webkit-transform: scale(1.025) perspective(1px);
-ms-transform: scale(1.025) perspective(1px);
transform: scale(1.025) perspective(1px);
opacity: 1;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit[data-variant="dark"],
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit[data-variant="light"] {
background-color: transparent;
border-color: transparent;
width: 166px;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit[data-variant="light"] {
color: #ffffff;
background-image: url("data:image/svg+xml;charset=utf8,%3Csvg width='162' height='20' viewBox='0 0 162 20' fill='none' xmlns='http://www.w3.org/2000/svg'%3E%3Cpath d='M83.0561 15.2457C86.675 15.2457 89.4722 12.5154 89.4722 9.14749C89.4722 5.99211 86.8443 4.06563 85.1038 4.06563C82.6801 4.06563 80.7373 5.76407 80.4605 8.28551C80.4092 8.75244 80.0387 9.14403 79.5686 9.14069C78.7871 9.13509 77.6507 9.12841 76.9314 9.13092C76.6217 9.13199 76.3658 8.88106 76.381 8.57196C76.4895 6.38513 77.2218 4.3404 78.618 2.76974C80.1695 1.02445 82.4289 0 85.1038 0C89.5979 0 93.8406 4.07791 93.8406 9.14749C93.8406 14.7608 89.1832 19.3113 83.1517 19.3113C78.8502 19.3113 74.5179 16.5041 73.0053 12.5795C72.9999 12.565 72.9986 12.5492 73.0015 12.534C73.0218 12.4179 73.0617 12.3118 73.1011 12.2074C73.1583 12.0555 73.2143 11.907 73.2062 11.7359L73.18 11.1892C73.174 11.0569 73.2075 10.9258 73.2764 10.8127C73.3452 10.6995 73.4463 10.6094 73.5666 10.554L73.7852 10.4523C73.9077 10.3957 74.0148 10.3105 74.0976 10.204C74.1803 10.0974 74.2363 9.97252 74.2608 9.83983C74.3341 9.43894 74.6865 9.14749 75.0979 9.14749C75.7404 9.14749 76.299 9.57412 76.5088 10.1806C77.5188 13.1 79.1245 15.2457 83.0561 15.2457Z' fill='white'/%3E%3Cpath d='M155.758 6.91365C155.028 6.91365 154.804 6.47916 154.804 5.98857C154.804 5.46997 154.986 5.06348 155.758 5.06348C156.53 5.06348 156.712 5.46997 156.712 5.98857C156.712 6.47905 156.516 6.91365 155.758 6.91365ZM142.441 12.9304V9.32833L141.415 9.32323V8.90392C141.415 8.44719 141.786 8.07758 142.244 8.07986L142.441 8.08095V6.55306L144.082 6.09057V8.08073H145.569V8.50416C145.569 8.61242 145.548 8.71961 145.506 8.81961C145.465 8.91961 145.404 9.01047 145.328 9.08699C145.251 9.16351 145.16 9.2242 145.06 9.26559C144.96 9.30698 144.853 9.32826 144.745 9.32822H144.082V12.7201C144.082 13.2423 144.378 13.4256 144.76 13.4887C145.209 13.5629 145.583 13.888 145.583 14.343V14.9626C144.029 14.9626 142.441 14.8942 142.441 12.9304Z' fill='white'/%3E%3Cpath d='M110.058 7.92554C108.417 7.88344 106.396 8.92062 106.396 11.5137C106.396 14.0646 108.417 15.0738 110.058 15.0318C111.742 15.0738 113.748 14.0646 113.748 11.5137C113.748 8.92062 111.742 7.88344 110.058 7.92554ZM110.07 13.7586C108.878 13.7586 108.032 12.8905 108.032 11.461C108.032 10.1013 108.878 9.20569 110.071 9.20569C111.263 9.20569 112.101 10.0995 112.101 11.459C112.101 12.8887 111.263 13.7586 110.07 13.7586Z' fill='white'/%3E%3Cpath d='M118.06 7.94098C119.491 7.94098 120.978 8.33337 120.978 11.1366V14.893H120.063C119.608 14.893 119.238 14.524 119.238 14.0689V10.9965C119.238 9.66506 118.747 9.16047 117.891 9.16047C117.414 9.16047 116.797 9.52486 116.502 9.81915V14.069C116.502 14.1773 116.481 14.2845 116.44 14.3845C116.398 14.4845 116.337 14.5753 116.261 14.6519C116.184 14.7284 116.093 14.7891 115.993 14.8305C115.893 14.8719 115.786 14.8931 115.678 14.8931H114.847V8.10918H115.773C115.932 8.10914 116.087 8.16315 116.212 8.26242C116.337 8.36168 116.424 8.50033 116.46 8.65577C116.881 8.19328 117.428 7.94098 118.06 7.94098ZM122.854 8.09713C123.024 8.09708 123.19 8.1496 123.329 8.2475C123.468 8.34541 123.574 8.48391 123.631 8.64405L125.133 12.8486L126.635 8.64415C126.692 8.48402 126.798 8.34551 126.937 8.2476C127.076 8.1497 127.242 8.09718 127.412 8.09724H128.598L126.152 14.3567C126.091 14.5112 125.986 14.6439 125.849 14.7374C125.711 14.831 125.549 14.881 125.383 14.8809H124.333L121.668 8.09713H122.854Z' fill='white'/%3E%3Cpath d='M135.085 14.5514C134.566 14.7616 133.513 15.0416 132.418 15.0416C130.496 15.0416 129.024 13.9345 129.024 11.4396C129.024 9.19701 130.451 7.99792 132.191 7.99792C134.338 7.99792 135.254 9.4378 135.158 11.3979C135.139 11.8029 134.786 12.0983 134.38 12.0983H130.679C130.763 13.1916 131.562 13.7662 132.615 13.7662C133.028 13.7662 133.462 13.7452 133.983 13.6481C134.535 13.545 135.085 13.9375 135.085 14.4985V14.5514ZM133.673 10.949C133.785 9.87621 133.061 9.28752 132.191 9.28752C131.321 9.28752 130.734 9.93979 130.679 10.9489L133.673 10.949Z' fill='white'/%3E%3Cpath d='M137.345 8.11122C137.497 8.11118 137.645 8.16229 137.765 8.25635C137.884 8.35041 137.969 8.48197 138.005 8.62993C138.566 8.20932 139.268 7.94303 139.759 7.94303C139.801 7.94303 140.068 7.94303 140.489 7.99913V8.7265C140.489 9.11748 140.15 9.4147 139.759 9.4147C139.31 9.4147 138.651 9.5829 138.131 9.8773V14.8951H136.462V8.11112L137.345 8.11122ZM156.6 14.0508V8.09104H155.769C155.314 8.09104 154.944 8.45999 154.944 8.9151V14.8748H155.775C156.23 14.8748 156.6 14.5058 156.6 14.0508ZM158.857 12.9447V9.34254H157.749V8.91912C157.749 8.46401 158.118 8.09506 158.574 8.09506H158.857V6.56739L160.499 6.10479V8.09506H161.986V8.51848C161.986 8.97359 161.617 9.34254 161.161 9.34254H160.499V12.7345C160.499 13.2566 160.795 13.44 161.177 13.503C161.626 13.5774 162 13.9024 162 14.3574V14.977C160.446 14.977 158.857 14.9086 158.857 12.9447ZM98.1929 10.1124C98.2033 6.94046 100.598 5.16809 102.895 5.16809C104.171 5.16809 105.342 5.44285 106.304 6.12953L105.914 6.6631C105.654 7.02011 105.16 7.16194 104.749 6.99949C104.169 6.7702 103.622 6.7218 103.215 6.7218C101.335 6.7218 99.9169 7.92849 99.9068 10.1123C99.9169 12.2959 101.335 13.5201 103.215 13.5201C103.622 13.5201 104.169 13.4717 104.749 13.2424C105.16 13.0799 105.654 13.2046 105.914 13.5615L106.304 14.0952C105.342 14.7819 104.171 15.0566 102.895 15.0566C100.598 15.0566 98.2033 13.2842 98.1929 10.1124ZM147.619 5.21768C148.074 5.21768 148.444 5.58663 148.444 6.04174V9.81968L151.82 5.58131C151.897 5.47733 151.997 5.39282 152.112 5.3346C152.227 5.27638 152.355 5.24607 152.484 5.24611H153.984L150.166 10.0615L153.984 14.8749H152.484C152.355 14.8749 152.227 14.8446 152.112 14.7864C151.997 14.7281 151.897 14.6436 151.82 14.5397L148.444 10.3025V14.0508C148.444 14.5059 148.074 14.8749 147.619 14.8749H146.746V5.21768H147.619Z' fill='white'/%3E%3Cpath d='M0.773438 6.5752H2.68066C3.56543 6.5752 4.2041 6.7041 4.59668 6.96191C4.99219 7.21973 5.18994 7.62695 5.18994 8.18359C5.18994 8.55859 5.09326 8.87061 4.8999 9.11963C4.70654 9.36865 4.42822 9.52539 4.06494 9.58984V9.63379C4.51611 9.71875 4.84717 9.88721 5.05811 10.1392C5.27197 10.3882 5.37891 10.7266 5.37891 11.1543C5.37891 11.7314 5.17676 12.1841 4.77246 12.5122C4.37109 12.8374 3.81152 13 3.09375 13H0.773438V6.5752ZM1.82373 9.22949H2.83447C3.27393 9.22949 3.59473 9.16064 3.79688 9.02295C3.99902 8.88232 4.1001 8.64502 4.1001 8.31104C4.1001 8.00928 3.99023 7.79102 3.77051 7.65625C3.55371 7.52148 3.20801 7.4541 2.7334 7.4541H1.82373V9.22949ZM1.82373 10.082V12.1167H2.93994C3.37939 12.1167 3.71045 12.0332 3.93311 11.8662C4.15869 11.6963 4.27148 11.4297 4.27148 11.0664C4.27148 10.7324 4.15723 10.4849 3.92871 10.3237C3.7002 10.1626 3.35303 10.082 2.88721 10.082H1.82373Z' fill='white'/%3E%3Cpath d='M13.011 6.5752V10.7324C13.011 11.207 12.9084 11.623 12.7034 11.9805C12.5012 12.335 12.2068 12.6089 11.8201 12.8022C11.4363 12.9927 10.9763 13.0879 10.4402 13.0879C9.6433 13.0879 9.02368 12.877 8.5813 12.4551C8.13892 12.0332 7.91772 11.4531 7.91772 10.7148V6.5752H8.9724V10.6401C8.9724 11.1704 9.09546 11.5615 9.34155 11.8135C9.58765 12.0654 9.96557 12.1914 10.4753 12.1914C11.4656 12.1914 11.9607 11.6714 11.9607 10.6313V6.5752H13.011Z' fill='white'/%3E%3Cpath d='M15.9146 13V6.5752H16.9649V13H15.9146Z' fill='white'/%3E%3Cpath d='M19.9255 13V6.5752H20.9758V12.0991H23.696V13H19.9255Z' fill='white'/%3E%3Cpath d='M28.2828 13H27.2325V7.47607H25.3428V6.5752H30.1724V7.47607H28.2828V13Z' fill='white'/%3E%3Cpath d='M41.9472 13H40.8046L39.7148 9.16796C39.6679 9.00097 39.6093 8.76074 39.539 8.44727C39.4687 8.13086 39.4262 7.91113 39.4116 7.78809C39.3823 7.97559 39.3339 8.21875 39.2665 8.51758C39.2021 8.81641 39.1479 9.03905 39.1039 9.18554L38.0405 13H36.8979L36.0673 9.7832L35.2236 6.5752H36.2958L37.2143 10.3193C37.3578 10.9199 37.4604 11.4502 37.5219 11.9102C37.5541 11.6611 37.6025 11.3828 37.6669 11.0752C37.7314 10.7676 37.79 10.5186 37.8427 10.3281L38.8886 6.5752H39.9301L41.0024 10.3457C41.1049 10.6943 41.2133 11.2158 41.3276 11.9102C41.3715 11.4912 41.477 10.958 41.644 10.3105L42.558 6.5752H43.6215L41.9472 13Z' fill='white'/%3E%3Cpath d='M45.7957 13V6.5752H46.846V13H45.7957Z' fill='white'/%3E%3Cpath d='M52.0258 13H50.9755V7.47607H49.0859V6.5752H53.9155V7.47607H52.0258V13Z' fill='white'/%3E%3Cpath d='M61.2312 13H60.1765V10.104H57.2146V13H56.1643V6.5752H57.2146V9.20312H60.1765V6.5752H61.2312V13Z' fill='white'/%3E%3C/svg%3E");
}
@-webkit-keyframes formkit-bouncedelay-formkit-form-data-uid-af4786bced- {
0%,
80%,
100% {
-webkit-transform: scale(0);
-ms-transform: scale(0);
transform: scale(0);
}
40% {
-webkit-transform: scale(1);
-ms-transform: scale(1);
transform: scale(1);
}
}
@keyframes formkit-bouncedelay-formkit-form-data-uid-af4786bced- {
0%,
80%,
100% {
-webkit-transform: scale(0);
-ms-transform: scale(0);
transform: scale(0);
}
40% {
-webkit-transform: scale(1);
-ms-transform: scale(1);
transform: scale(1);
}
}
.formkit-form[data-uid="af4786bced"] blockquote {
padding: 10px 20px;
margin: 0 0 20px;
border-left: 5px solid #e1e1e1;
}
.formkit-form[data-uid="af4786bced"] .seva-custom-content {
padding: 15px;
font-size: 16px;
color: #fff;
mix-blend-mode: difference;
}
.formkit-form[data-uid="af4786bced"] {
box-shadow: 0 0px 2px rgba(0, 0, 0, 0.15);
max-width: 700px;
overflow: hidden;
}
.formkit-form[data-uid="af4786bced"] [data-style="full"] {
width: 100%;
display: block;
}
.formkit-form[data-uid="af4786bced"] .formkit-background {
background-position: center center;
background-size: cover;
min-height: 200px;
}
.formkit-form[data-uid="af4786bced"] .formkit-column {
padding: 20px;
position: relative;
}
.formkit-form[data-uid="af4786bced"] .formkit-header {
margin-top: 0;
margin-bottom: 20px;
}
.formkit-form[data-uid="af4786bced"] .formkit-field {
margin: 0 0 10px 0;
}
.formkit-form[data-uid="af4786bced"] .formkit-input {
width: 100%;
border-left: none;
border-right: none;
border-top: none;
padding-left: 0;
padding-right: 0;
}
.formkit-form[data-uid="af4786bced"] .formkit-fields .formkit-submit {
margin-top: 15px;
width: 100%;
}
.formkit-form[data-uid="af4786bced"] .formkit-disclaimer {
margin: 0 0 15px 0;
}
.formkit-form[data-uid="af4786bced"] .formkit-disclaimer>p {
margin: 0;
}
.formkit-form[data-uid="af4786bced"] .formkit-powered-by-convertkit-container {
margin-bottom: 0;
margin-top: 20px;
}
.formkit-form[data-uid="af4786bced"][min-width~="600"] [data-style="full"],
.formkit-form[data-uid="af4786bced"][min-width~="700"] [data-style="full"],
.formkit-form[data-uid="af4786bced"][min-width~="800"] [data-style="full"] {
display: grid;
grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
}
.formkit-form[data-uid="af4786bced"][min-width~="600"] .formkit-column,
.formkit-form[data-uid="af4786bced"][min-width~="700"] .formkit-column,
.formkit-form[data-uid="af4786bced"][min-width~="800"] .formkit-column {
padding: 40px;
}
</style>
</form>https://javarevisited.blogspot.com/search
<form action="https://javarevisited.blogspot.com/search" class="gsc-search-box" target="_top">
<table cellpadding="0" cellspacing="0" class="gsc-search-box">
<tbody>
<tr>
<td class="gsc-input">
<input autocomplete="off" class="gsc-input" name="q" size="10" title="search" type="text" value="">
</td>
<td class="gsc-search-button">
<input class="gsc-search-button" title="search" type="submit" value="Search">
</td>
</tr>
</tbody>
</table>
</form>POST https://gumroad.com/follow_from_embed_form
<form action="https://gumroad.com/follow_from_embed_form" class="form gumroad-follow-form-embed" method="post"> <input name="seller_id" type="hidden" value="6381505211250"> <input name="email" placeholder="Your email address" type="email"> <button
data-custom-highlight-color="" type="submit">Follow</button> </form>POST https://api.follow.it/subscription-form/VzM1WnhvV1JaQXZveTZIeFQ0VFlnUjU3ZlZ1QXQ3WkNickFPQmJUWlZHTHpiVVZkaVFNMU9UQWZvdDNkUmJaWU5MZFo2UjRDMkw2bWd5RFRVZ2hieUVwdk9CRzhUK0ZMSFB2d0FVc2tDU3VKSWxPMTJxUys2QlFKUnRyVHRJY3h8TEpRTDl0YTc5MjVDeDdOejl2NWt0U0dIOVJTMWU2S2h0MFpJL3V5L01QYz0=/8
<form data-v-3a89cb67=""
action="https://api.follow.it/subscription-form/VzM1WnhvV1JaQXZveTZIeFQ0VFlnUjU3ZlZ1QXQ3WkNickFPQmJUWlZHTHpiVVZkaVFNMU9UQWZvdDNkUmJaWU5MZFo2UjRDMkw2bWd5RFRVZ2hieUVwdk9CRzhUK0ZMSFB2d0FVc2tDU3VKSWxPMTJxUys2QlFKUnRyVHRJY3h8TEpRTDl0YTc5MjVDeDdOejl2NWt0U0dIOVJTMWU2S2h0MFpJL3V5L01QYz0=/8"
method="post">
<div data-v-3a89cb67="" class="form-preview" style="background-color: rgb(250, 247, 247); border-style: solid; border-width: 2px; border-color: rgb(204, 204, 204); position: relative;">
<div data-v-3a89cb67="" class="preview-heading">
<h5 data-v-3a89cb67="" style="text-transform: none !important; font-family: Montserrat; font-weight: bold; color: rgb(0, 0, 0); font-size: 16px; text-align: center;">Get new posts by email:</h5>
</div>
<div data-v-3a89cb67="" class="preview-input-field"><input data-v-3a89cb67="" type="email" name="email" required="required" placeholder="Enter your email" spellcheck="false"
style="text-transform: none !important; font-family: Montserrat; font-weight: normal; color: rgb(0, 0, 0); font-size: 14px; text-align: center; background-color: rgb(255, 255, 255);"></div>
<div data-v-3a89cb67="" class="preview-submit-button"><button data-v-3a89cb67="" type="submit"
style="text-transform: none !important; font-family: Montserrat; font-weight: bold; color: rgb(255, 255, 255); font-size: 16px; text-align: center; background-color: rgb(0, 0, 0);">Subscribe</button></div>
</div>
</form>Text Content
WE VALUE YOUR PRIVACY
We and our partners store and/or access information on a device, such as cookies
and process personal data, such as unique identifiers and standard information
sent by a device for personalised ads and content, ad and content measurement,
and audience insights, as well as to develop and improve products. With your
permission we and our partners may use precise geolocation data and
identification through device scanning. You may click to consent to our and our
partners’ processing as described above. Alternatively you may access more
detailed information and change your preferences before consenting or to refuse
consenting. Please note that some processing of your personal data may not
require your consent, but you have a right to object to such processing. Your
preferences will apply to this website only. You can change your preferences at
any time by returning to this site or visit our privacy policy.
MORE OPTIONSAGREE
Javarevisited
Learn Java, Programming, Spring, Hibernate throw tutorials, examples, and
interview questions
Flipboard
LinkedIn
TOPICS AND CATEGORIES
* core java
* spring
* hibernate
* collections
* multithreading
* design patterns
* interview questions
* coding
* data structure
* OOP
* java 8
* books
* About Me
* Java Certifications
* JDBC
* jsp-servlet
* JSON
* SQL
* Linux
* Courses
* online resources
* jvm-internals
* REST
* Eclipse
* jQuery
* Java IO
* Java XML
Disclosure: This article may contain affiliate links. When you purchase, we may
earn a small commission.
DIFFERENCE BETWEEN SQL, T-SQL AND PL/SQL?
Hello guys, if you are preparing for SQL and Database Interviews or any Software
engineering interview and looking for difference between T-SQL, SQL, and PL/SQL
then you have come to the right place. Earlier, I have shared 50 SQL Interview
questions and 12 SQL query Examples from interviews and today, we are going to
see another common and interesting SQL interview question, what is the
difference between SQL, T-SQL, and PL/SQL? It is also one of the most common
doubts among SQL beginners. It's common for programmers to think that why there
are many types of SQL languages, why not just single SQL across DB? etc. Well,
let's first understand the difference between SQL, T-SQL, and PL/SQL, and then
we will understand the need for these dialects.
Powered By
Video Player is loading.
Play Video
Play
Unmute
Current Time 0:00
/
Duration 50:39
Loaded: 1.02%
00:00
Stream Type LIVE
Seek to live, currently behind liveLIVE
Remaining Time -50:39
1x
Playback Rate
Chapters
* Chapters
Descriptions
* descriptions off, selected
Captions
* captions settings, opens captions settings dialog
* captions off, selected
Audio Track
* default, selected
Picture-in-PictureFullscreen
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque
Font Size50%75%100%125%150%175%200%300%400%Text Edge
StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional
Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall
Caps
Reset restore all settings to the default valuesDone
Close Modal Dialog
End of dialog window.
Advertisement
SQL is standard for querying, inserting, and modifying data in a relational
database. It is categorized into DDL and DML and is powerful enough to create
database objects e.g. table, view, stored procedure, and can perform CRUD
operation (SELECT, INSERT, UPDATE, and DELETE) query.
On the other hand, T-SQL (Transact-SQL) is a dialect used by Microsoft SQL
Server and Sybase. It is an extension of SQL and provides more functionality
than SQL but at the same time confirming ANSI SQL standard as well. For example,
you can use conditionals and loops in T-SQL to create a more sophisticated
stored procedure that is not available in standard SQL.
Similarly, PL/SQL (Procedural language SEQUEL) is a dialect for Oracle database,
which provides T-SQL like functionality e.g. conditionals, loops, and other
elements for procedural programming. Both T-SQL and PL/SQL are the supersets of
SQL because they not just confirm ANSI SQL standard but also provide additional
functionality that is not available in the ANSI standard but helps a lot in
database programming.
In this article, you will learn a couple of more differences between SQL,
T-SQL, and PL/SQL to understand them better.
1.
2.
3.
4.
Video Player is loading.
Play Video
Pause
Unmute
Current Time 0:00
/
Duration 0:05
Loaded: 100.00%
0:00
Stream Type LIVE
Seek to live, currently behind liveLIVE
Remaining Time -0:05
1x
Playback Rate
Chapters
* Chapters
Descriptions
* descriptions off, selected
Captions
* captions settings, opens captions settings dialog
* captions off, selected
Audio Track
Picture-in-PictureFullscreen
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque
Font Size50%75%100%125%150%175%200%300%400%Text Edge
StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional
Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall
Caps
Reset restore all settings to the default valuesDone
Close Modal Dialog
End of dialog window.
Advertisement
TOP 5 BOOKS TO LEARN DEVOPS FOR DEVELOPERS - BEST OF LOT
10 EXAMPLES OF GREP COMMAND IN UNIX AND LINUX
10 EXAMPLES OF CURL COMMAND IN UNIX AND LINUX
TOP 5 COURSES TO LEARN ECLIPSE IDE FOR JAVA PROGRAMMERS - BEST OF LOT
WHY DO YOU NEED T-SQL OR PL/SQL?
Though standard SQL is enough for inserting, retrieving, and modifying data from
the database, they only provide set-based operations, which means there are a
lot of tasks that you cannot do using plain SQL.
In order to make SQL more powerful and to expand its usage from simple querying
to create complex stored procedures for report generation, XSLT transformation,
and many other functionalities, various database vendors started adding
proprietary features on SQL supported by their platform.
These efforts created different SQL dialects e.g. T-SQL, which is a SQL dialect
for Microsoft SQL Server, and Sybase, PL/SQL which is a SQL dialect for Oracle.
In fact, every database has its own SQL dialect, which comprises features and
keywords only supported in their database e.g. MySQL has the LIMIT keyword which
can be used for pagination or solving problems like second highest salary, but
it will not work on Oracle or Microsoft SQL Server database. Similarly,
PostgreSQL has some features which are not available to other databases.
It's always recommended to use standard ANSI SQL if it serves your purpose
because query written in ANSI SQL is portable across different database vendors
but if you use a proprietary keyword e.g. TOP in Microsoft SQL Server, LIMIT in
MySQL then you need to change your query when your application migrate from one
database to another.
DIFFERENCES BETWEEN SQL, T-SQL AND PL/SQL
Here are a couple of more differences between SQL, PL/SQL, and T-SQL for
interviews:
1. Full form
SQL stands for Structured Query language, T-SQL stands for Transact-SQL and
PL/SQL stands for Procedural Language/SQL.
2. Supported Database
SQL is supported across all database vendors like Oracle, SQL Server, MySQL,
PostgreSQL, IBM DB2, and even lightweight databases like SQLLite, but T-SQL is
only supported in Microsoft SQL Server and Sybase, and PL/SQL is supported only
in Oracle.
3. Performance
Another key difference between SQL and PL/SQL, T-SQL is the performance
improvement by saving database roundtrip. Both PL/SQL and T-SQL allow grouping
of SQL statements which means if your code has 4 SELECT SQL queries then instead
of making four round trips to the database, they can be sent as one single unit
to the database and their result will also come back as one unit.
I suggest joining these best Oracle and PL/SQL online courses to learn more
about PL/SQL programming. It covers versions through Oracle Database 12c.
4. SQL Query Requirement
There is an interesting difference between SQL and T-SQL in terms of minimum
SELECT query requirements. According to standard SQL, a SELECT query must have
at minimum FROM and SELECT clauses, but you can create a SELECT query in T-SQL
with just a SELECT clause, without FROM clause.
For example, the following SQL query is invalid according to SQL standard but it
works fine in T-SQL supported databases like Sybase and MSSQL:
SELECT 'Java' AS Language, 1 AS RANK;
The output of the query is a single row with attributes resulting from the
expression with names assigned using the aliases e.g.
Language Rank
Java 1
If you want to learn more about T-SQL, I suggest joining these Microsoft SQL
Server and T-SQL Fundamentals courses, a great reference to T-SQL but at the
same time a very readable and clear explanation of key SQL concepts.
5. Data Types and Keyword
There are some data types which are supported only by PL/SQL and T-SQL e.g.
TINYINT data type is only available in T-SQL and VARCHAR2 and NUMBER is only
available in PL/SQL or Oracle database. Similarly, there are keywords which are
only available in a particular SQL dialect like the LIMIT keyword which is only
available in MySQL.
If you want to learn more about features, keyword, and data types supported by
different vendors I strongly suggest joining these best SQL courses, it provides
a great cross-platform syntax for SQL. Absolutely must-read for those
programmers who work with multiple databases
That's all on the difference between SQL, T-SQL, and PL/SQL. Just remember that
both T-SQL and PL/SQL are dialects of SQL, which is the standard specified by
ANSI for managing data in relational databases. T-SQL is only supported in
Sybase and SQL Server, while PL/SQL is only supported in the Oracle database.
Though both T-SQL and PL/SQL are more powerful than SQL and provide several
languages construct to do more with database e.g. conditionals, loops,
branching, etc.
Other Database and SQL Interview Questions you may like
* Difference between Primary key and Foreign key in SQL? (answer)
* Difference between row_number, rank, and dense_rank in SQL? (answer)
* Difference between Primary key and Unique key in SQL? (answer)
* When to use truncate vs delete command in SQL? (answer)
* Difference between LEFT and RIGHT Outer Join in SQL? (answer)
* Difference between Clustered and Non-Clustered index in SQL? (answer)
* Top 6 SQL Query Interview Questions for Programmers (list)
* Difference between WHERE and HAVING clause in SQL? (answer)
* Difference between UNION and UNION ALL in SQL? (answer)
* Difference between View and Materialized view in SQL? (answer)
* Difference between Primary key and Candidate key in SQL? (answer)
* Difference between Correlated and Regular Subquery in SQL? (answer)
* Difference between IsNull() and Coalesce() in T-SQL? (answer)
* Difference between GETDATE, SYSDATETIME, and GETUTCDATE in T-SQL? (answer)
* Difference between Self Join and Equi Join in SQL? (answer)
* Difference between close and deallocate cursor in SQL? (answer)
* Difference between CHAR and VARCHAR data type in SQL? (answer)
* 5 SQL Books Every Programmer Should Read (books)
Thank you for reading this article, if you like this tutorial then please share
with your friends and colleagues. If you have any feedback or suggestion then
please drop a comment.
P.S. - If you are new SQL and Database world and looking for some free resources
to start your journey then you can also take a look at this list of Free SQL
Courses for Beginners to start your SQL and Database journey for FREE.
PREPARING FOR JAVA DEVELOPER INTERVIEWS?
Download Free Questions
We respect your privacy. Unsubscribe at any time.
Built with ConvertKit
By javin paul
Email This BlogThis! Share to Twitter Share to Facebook
Labels: interview questions , SQL , SQL Interview Questions
NO COMMENTS :
POST A COMMENT
Newer Post Older Post Home
Subscribe to: Post Comments ( Atom )
SEARCH THIS BLOG
SUBSCRIBE FOR DISCOUNTS AND UPDATES
Follow
INTERVIEW QUESTIONS
* core java interview question (178)
* interview questions (104)
* data structure and algorithm (86)
* Coding Interview Question (79)
* design patterns (38)
* object oriented programming (37)
* SQL Interview Questions (35)
* spring interview questions (32)
* thread interview questions (30)
* collections interview questions (26)
* database interview questions (16)
* servlet interview questions (15)
* Programming interview question (6)
* hibernate interview questions (6)
BEST OF JAVAREVISITED
* How Spring MVC works internally?
* How to design a vending machine in Java?
* How HashMap works in Java?
* Why String is Immutable in Java?
* 10 Articles Every Programmer Must Read
* How to convert lambda expression to method reference in Java 8?
* 10 Tips to improve Programming Skill
* 10 OOP design principles programmer should know
* How Synchronization works in Java?
* 10 tips to work fast in Linux
* 5 Books to improve Coding Skills
JAVA TUTORIALS
* date and time tutorial (24)
* FIX protocol tutorial (15)
* Java Certification OCPJP SCJP (33)
* java collection tutorial (83)
* java IO tutorial (29)
* Java JSON tutorial (15)
* Java multithreading Tutorials (61)
* Java Programming Tutorials (20)
* Java xml tutorial (16)
* JDBC (34)
* jsp-servlet (37)
* online resources (227)
GET NEW BLOG POSTS ON YOUR EMAIL
GET NEW POSTS BY EMAIL:
Subscribe
FOLLOWERS
CATEGORIES
* courses (395)
* SQL (68)
* linux (50)
* database (49)
* Java Certification OCPJP SCJP (33)
* Eclipse (30)
* REST (29)
* JVM Internals (24)
* JQuery (21)
* Testing (19)
* general (18)
* Maven (16)
BLOG ARCHIVE
* ▼ 2022 (699)
* ► October (5)
* ▼ September (37)
* How to create RESTful Web Services in Java using S...
* How to use Lombok in Java? Lombok @Data and @NonNu...
* How to use NamedQuery in Spring Framework JDBC? Ex...
* 10 Data Structures Every Programmer Should Learn
* How to upload/download file in Spring MVC and Spri...
* How to use Mockito to Unit test Java Program with ...
* How to Enable log SQL statements in Spring Boot? E...
* How to choose Collection in Java? List, Set, Map, ...
* Top 10 Matrix Coding Exercises for Programming int...
* How to find first recurring or duplicate character...
* Difference between CAST, CONVERT, and PARSE SQL Se...
* Top 5 Spring MVC Annotations for Developing RESTfu...
* Difference between SQL, T-SQL and PL/SQL?
* How to check Perfect number in Java? Example Tutorial
* 12 SQL Queries Example and Practice Questions for ...
* Why Singleton is Anti Pattern in Java Now and Why ...
* Java Stream + map + flatMap + Collectors.toSet() E...
* Top 16 Lambda Expression and Stream Interview Ques...
* How to Join Two or More Tables in a SQL query? Lef...
* Top 21 GraphQL Interview Questions and Answers for...
* Top 20 CSS Interview Questions and Answers for 1 t...
* Is CodeGym Good Place to Learn Java? Is CodeGym Pr...
* Top 30 Gradle Interview Questions with Answers for...
* How to use Composite Design Pattern in Java? Examp...
* How to use State Design Pattern in Java? Vending M...
* Top 17 Interview Questions to Test debugging Skill...
* Top 12 Locking, Synchronization and Multithreading...
* Top 20 Mockito Interview Questions with Answers fo...
* Top 35 Python Interview Questions with Answers 1 t...
* 10 Reasons to learn JavaScript Programming Languag...
* 3 best ways to learn Web Development in 2022
* Top 20 System Design Interview Questions with Answ...
* 9 Best System Design Interview Courses for Beginne...
* Top 20 Spring Cloud Interview Questions with Answe...
* Top 35 React.js Interview Questions with Answers f...
* Difference between Proxy and State design Pattern ...
* Top 20 Apache Kafka Interview Questions Answers fo...
* ► August (83)
* ► July (144)
* ► June (113)
* ► May (66)
* ► April (126)
* ► March (25)
* ► February (44)
* ► January (56)
* ► 2021 (960)
* ► December (134)
* ► November (88)
* ► October (40)
* ► September (57)
* ► August (224)
* ► July (359)
* ► June (5)
* ► May (7)
* ► April (15)
* ► March (17)
* ► February (8)
* ► January (6)
* ► 2020 (95)
* ► December (13)
* ► November (10)
* ► October (6)
* ► September (4)
* ► August (5)
* ► July (8)
* ► June (2)
* ► May (8)
* ► April (20)
* ► March (11)
* ► February (8)
* ► 2019 (24)
* ► December (3)
* ► November (6)
* ► October (4)
* ► August (1)
* ► July (2)
* ► June (2)
* ► May (1)
* ► April (2)
* ► February (1)
* ► January (2)
* ► 2018 (5)
* ► September (1)
* ► August (1)
* ► July (2)
* ► June (1)
* ► 2017 (22)
* ► December (2)
* ► November (2)
* ► October (4)
* ► September (2)
* ► July (3)
* ► June (5)
* ► May (3)
* ► April (1)
TRANSLATE THIS BLOG
Powered by Google Übersetzer
REFERENCES
1. Oracle's Java Tech Network
2. jQuery Documentation
3. Microsoft SQL Server Documentation
4. Java SE 8 API Documentation
5. Spring Documentation
6. Oracle's JAva Certification
7. Spring Security 5 Documentation
PAGES
* Privacy Policy
* Terms and Conditions
Copyright by Javin Paul 2010-2021. Powered by Blogger.
Diese Website verwendet Cookies von Google, um Dienste anzubieten und Zugriffe
zu analysieren. Deine IP-Adresse und dein User-Agent werden zusammen mit
Messwerten zur Leistung und Sicherheit für Google freigegeben. So können
Nutzungsstatistiken generiert, Missbrauchsfälle erkannt und behoben und die
Qualität des Dienstes gewährleistet werden.Weitere InformationenOk
ORIGINALTEXT
Bessere Übersetzung vorschlagen
--------------------------------------------------------------------------------
×
Want to Learn Spring Boot for FREE?
Yes please!No, Thnaks
AddThis
Show
AddThis What's Next
Recommended for you
How to check if String contains another SubString in Java? contai...
javarevisited.blogspot.com
AddThis
Hide