sql - ORA-00917: missing comma when insert not exist in oracle -


i have query :

insert kontak (idkontak, nama, nohp, alamat, groupkontak_fk) values  (sq_idkontak.nextval, 'andika pratama', '+6285226202202', 'jpr', '' not exists (select * kontak nama = 'amin'))

i want insert data kontak table based on values not exist in kontak nama='amin'.

when ran got error :

ora-00917: missing comma

any suggestion?

if trying conditional insert, can either use merge, or use this, assuming want insert 'andika pratama' if 'amin' not there (which doesn't make sense me, seems goal):

insert table1(id1, col1, col2)   select sequence1.nextval, 'val1', 'val2'     dual     not exists (select 1 table1 col1 = 'amin')

http://docs.oracle.com/cd/b19306_01/server.102/b14200/statements_9014.htm


-

Comments

Post a Comment

Popular posts from this blog

c# - SharpDX Toolkit models rendering inside out -

a little while ago decided switch xna sharpdx toolkit actively being supported , quite similar xna. while i've had no trouble @ creating 2d games decided attempt basic 3d game. can both model , it's texture load when renders shows texture on side facing away camera doesn't show @ in between. this code using set environment. vector3 cameraposition = new vector3(0, 0, -10f * 2.5f); vector3 cameratarget = vector3.zero; boundingsphere modelbounds = model.calculatebounds(); float fovangle = mathutil.degreestoradians(45); float aspectratio = (float)graphicsdevice.backbuffer.width / graphicsdevice.backbuffer.height; float near = 0.01f; float far = 100f; float scaling = 10f / modelbounds.radius; matrix translation = matrix.scaling(scaling) * matrix.rotationy((float)gametime.totalgametime.totalseconds) * matrix.translation(0, -modelbounds.center.y * scaling, 0); matrix lookat = matrix.lookatlh(cameraposition, cameratarget, vector3.u...
Read more

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more