What SQL Query will be useful on this? ( ORACLE)
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I want to get the value of column and set it to the other column but this is the challenge to me.
Both are in the same table
DATA 1 DATA 2
Prev.No = 789 App.No = 789
UserRefNo. = 23 RenewdNo = ?
Question is: what query will I use to set the RenewdNo
of Data 2 from the UserRefNo
of data 1?
There will be a lot of rows to update.
Expected results:
Data 2
App.No = 789
RenewdNo = 23
sql scripting sql-scripts
add a comment |
I want to get the value of column and set it to the other column but this is the challenge to me.
Both are in the same table
DATA 1 DATA 2
Prev.No = 789 App.No = 789
UserRefNo. = 23 RenewdNo = ?
Question is: what query will I use to set the RenewdNo
of Data 2 from the UserRefNo
of data 1?
There will be a lot of rows to update.
Expected results:
Data 2
App.No = 789
RenewdNo = 23
sql scripting sql-scripts
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30
add a comment |
I want to get the value of column and set it to the other column but this is the challenge to me.
Both are in the same table
DATA 1 DATA 2
Prev.No = 789 App.No = 789
UserRefNo. = 23 RenewdNo = ?
Question is: what query will I use to set the RenewdNo
of Data 2 from the UserRefNo
of data 1?
There will be a lot of rows to update.
Expected results:
Data 2
App.No = 789
RenewdNo = 23
sql scripting sql-scripts
I want to get the value of column and set it to the other column but this is the challenge to me.
Both are in the same table
DATA 1 DATA 2
Prev.No = 789 App.No = 789
UserRefNo. = 23 RenewdNo = ?
Question is: what query will I use to set the RenewdNo
of Data 2 from the UserRefNo
of data 1?
There will be a lot of rows to update.
Expected results:
Data 2
App.No = 789
RenewdNo = 23
sql scripting sql-scripts
sql scripting sql-scripts
edited Nov 19 '18 at 3:36
Adrian Manangan
asked Nov 17 '18 at 4:19
Adrian MananganAdrian Manangan
73
73
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30
add a comment |
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30
add a comment |
1 Answer
1
active
oldest
votes
You need an update query like:
Update d2
set d2.RenewdNo = d.UserRefNo
from Data2 d2
inner join Data1 d on d.Prev_no=d2.Appno
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
|
show 2 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53348173%2fwhat-sql-query-will-be-useful-on-this-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need an update query like:
Update d2
set d2.RenewdNo = d.UserRefNo
from Data2 d2
inner join Data1 d on d.Prev_no=d2.Appno
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
|
show 2 more comments
You need an update query like:
Update d2
set d2.RenewdNo = d.UserRefNo
from Data2 d2
inner join Data1 d on d.Prev_no=d2.Appno
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
|
show 2 more comments
You need an update query like:
Update d2
set d2.RenewdNo = d.UserRefNo
from Data2 d2
inner join Data1 d on d.Prev_no=d2.Appno
You need an update query like:
Update d2
set d2.RenewdNo = d.UserRefNo
from Data2 d2
inner join Data1 d on d.Prev_no=d2.Appno
edited Nov 17 '18 at 12:53
answered Nov 17 '18 at 4:20
Eray BalkanliEray Balkanli
4,65852347
4,65852347
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
|
show 2 more comments
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
you can use column from * FROM *? because they are on the same table
– Adrian Manangan
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
You can, try this, it should work.
– Eray Balkanli
Nov 17 '18 at 4:24
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Update (select query) set d2.RenewdNo = d.UserRefNo from (select) inner join Data1 d on d.Prev_no=d2.Prev_no how about this?i try to manage multiple
– Adrian Manangan
Nov 17 '18 at 4:34
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
Do not use "select" keywords here please
– Eray Balkanli
Nov 17 '18 at 4:35
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
ohhh ok ok i understand now thanks sir!
– Adrian Manangan
Nov 17 '18 at 4:39
|
show 2 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53348173%2fwhat-sql-query-will-be-useful-on-this-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Tag your question with the database you are using.
– Gordon Linoff
Nov 17 '18 at 13:30