Styjun

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;

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

share|improve this question

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

add a comment
 | 

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

share|improve this question

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 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

share|improve this question

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

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')";

share|improve this question

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

share|improve this question

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

edited Mar 28 at 20:53

marc_s

605k137137 gold badges11581158 silver badges12911291 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

asked Mar 28 at 18:24

Bora.OzgurBora.Ozgur

933 bronze badges

1 Answer
1

active

oldest

votes

1

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.

share|improve this answer

edited Mar 28 at 19:03

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

1

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.

share|improve this answer

edited Mar 28 at 19:03

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah it works you could be my savior
  
  – Bora.Ozgur
  Mar 28 at 19:01
  

  
  
  
  

add a comment
 | 

1

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.

share|improve this answer

edited Mar 28 at 19:03

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 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.

share|improve this answer

edited Mar 28 at 19:03

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 bronze badges

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');

share|improve this answer

edited Mar 28 at 19:03

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 bronze badges

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 bronze badges

answered Mar 28 at 18:48

Code PopeCode Pope

1,62633 gold badges1717 silver badges4141 bronze badges