plsql - insert bulk data in oracle with validations -


i want insert bulk data emp table test table in single insert, if 1 column @ least violate constraint i want prevent user insert , return error messgaes. please?

create table test ( c1 nvarchar(50) not null, c2 number, c3 date);

insert test(c1,c2,c3) select (v1,v2,v3)from emp ;

thanks

if have bulk data insert sql loader better route go..

if end users should using stored procedure, package, or function.. haven't given detail of insert code going run..oracle through exception if have constraint in place..


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -