How to insert data into Oracle by using where not exists?How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerHow do I enumerate an enum in C#?Get list of all tables in Oracle?SQLite - UPSERT *not* INSERT or REPLACEHow to 'insert if not exists' in MySQL?How to insert a value that contains an apostrophe (single quote)?How do I UPDATE from a SELECT in SQL Server?Update statement with inner join on OracleSQL Server SELECT into existing table
Rounding the corners of tcolorbox
Why does C++ have 'Undefined Behaviour' and other languages like C# or Java don't?
Top off gas with old oil, is that bad?
Can my former employer sue me if I don't give them the photos I took (taking pictures was not part of my job description)?
Why is a road bike faster than a city bike with the same effort? How much faster it can be?
Iterating over &Vec<T> and Vec<&T>
Align all symbols in a LaTeX equation
Does "as soon as" imply simultaneity?
Do wheelchair-accessible aircraft exist?
Why are there two fundamental laws of logic?
Why was LOGO created?
New road bike: alloy dual pivot brakes work poorly
Windows 10 deletes lots of tiny files super slowly. Anything that can be done to speed it up?
Beyond Futuristic Technology for an Alien Warship?
How to justify getting additional team member when the current team is doing well?
Why is my abdomen much cooler than the rest of my body after a ride?
Why is volatility skew/smile for long term options flatter compare to short term options?
Hangman Game (YAHG)
Help in drawing resonance structures in case of polybasic acids
Clear text passwords in Unix
What happens to a net with the Returning Weapon artificer infusion after it hits?
Why, even after his imprisonment, people keep calling Hannibal Lecter "Doctor"?
I am not a pleasant sight
How to deal with a Homophobic PC
How to insert data into Oracle by using where not exists?
How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerHow do I enumerate an enum in C#?Get list of all tables in Oracle?SQLite - UPSERT *not* INSERT or REPLACEHow to 'insert if not exists' in MySQL?How to insert a value that contains an apostrophe (single quote)?How do I UPDATE from a SELECT in SQL Server?Update statement with inner join on OracleSQL Server SELECT into existing table
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
When I use this code, it returns an error "SQL command not properly ended" - what am I missing?
cmd.CommandText = "insert into trf_urun_bırım_detay " +
"values ('838', '1198385027', '950', '034') " +
"where not exists(select * from trf_urun_bırım_detay where transfer_no = '838')";
c# sql oracle
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
add a comment
|
When I use this code, it returns an error "SQL command not properly ended" - what am I missing?
cmd.CommandText = "insert into trf_urun_bırım_detay " +
"values ('838', '1198385027', '950', '034') " +
"where not exists(select * from trf_urun_bırım_detay where transfer_no = '838')";
c# sql oracle
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
add a comment
|
When I use this code, it returns an error "SQL command not properly ended" - what am I missing?
cmd.CommandText = "insert into trf_urun_bırım_detay " +
"values ('838', '1198385027', '950', '034') " +
"where not exists(select * from trf_urun_bırım_detay where transfer_no = '838')";
c# sql oracle
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
When I use this code, it returns an error "SQL command not properly ended" - what am I missing?
cmd.CommandText = "insert into trf_urun_bırım_detay " +
"values ('838', '1198385027', '950', '034') " +
"where not exists(select * from trf_urun_bırım_detay where transfer_no = '838')";
c# sql oracle
c# sql oracle
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
edited Mar 28 at 20:53
marc_s
605k137 gold badges1158 silver badges1291 bronze badges
605k137 gold badges1158 silver badges1291 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
asked Mar 28 at 18:24
Bora.OzgurBora.Ozgur
93 bronze badges
93 bronze badges
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
Your SQL Statement is incorrect. You either have to use MERGE statement or change your sql statement to the following:
insert into trf_urun_bırım_detay (transfer_no , Field2, Field3, Field4)
select '838','1198385027','950','034'
from dual where not exists(select * from trf_urun_bırım_detay where transfer_no = '838');
I have used Field2,Field3,Field4 for your fields, because you didn't mentioned their names.
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
add a comment
|
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/4.0/"u003ecc by-sa 4.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%2f55404504%2fhow-to-insert-data-into-oracle-by-using-where-not-exists%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
Your SQL Statement is incorrect. You either have to use MERGE statement or change your sql statement to the following:
insert into trf_urun_bırım_detay (transfer_no , Field2, Field3, Field4)
select '838','1198385027','950','034'
from dual where not exists(select * from trf_urun_bırım_detay where transfer_no = '838');
I have used Field2,Field3,Field4 for your fields, because you didn't mentioned their names.
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
add a comment
|
Your SQL Statement is incorrect. You either have to use MERGE statement or change your sql statement to the following:
insert into trf_urun_bırım_detay (transfer_no , Field2, Field3, Field4)
select '838','1198385027','950','034'
from dual where not exists(select * from trf_urun_bırım_detay where transfer_no = '838');
I have used Field2,Field3,Field4 for your fields, because you didn't mentioned their names.
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
add a comment
|
Your SQL Statement is incorrect. You either have to use MERGE statement or change your sql statement to the following:
insert into trf_urun_bırım_detay (transfer_no , Field2, Field3, Field4)
select '838','1198385027','950','034'
from dual where not exists(select * from trf_urun_bırım_detay where transfer_no = '838');
I have used Field2,Field3,Field4 for your fields, because you didn't mentioned their names.
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
Your SQL Statement is incorrect. You either have to use MERGE statement or change your sql statement to the following:
insert into trf_urun_bırım_detay (transfer_no , Field2, Field3, Field4)
select '838','1198385027','950','034'
from dual where not exists(select * from trf_urun_bırım_detay where transfer_no = '838');
I have used Field2,Field3,Field4 for your fields, because you didn't mentioned their names.
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
edited Mar 28 at 19:03
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
answered Mar 28 at 18:48
Code PopeCode Pope
1,6263 gold badges17 silver badges41 bronze badges
1,6263 gold badges17 silver badges41 bronze badges
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
add a comment
|
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
Yeah it works you could be my savior
– Bora.Ozgur
Mar 28 at 19:01
add a comment
|
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%2f55404504%2fhow-to-insert-data-into-oracle-by-using-where-not-exists%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
