tag:blogger.com,1999:blog-13265058.post2749939554871253002..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: Bullet proofing entire record inserts/updatesSydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-13265058.post-792221491162093452011-05-18T00:15:49.054+10:002011-05-18T00:15:49.054+10:00oops. I'd not see that in the example... Thank...oops. I'd not see that in the example... Thank you.Withttps://www.blogger.com/profile/03335458180441435271noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-70948497738930043792011-05-17T23:28:23.168+10:002011-05-17T23:28:23.168+10:00The column 'B' needs a default value defin...The column 'B' needs a default value defined.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-86762337009857209372011-05-17T22:49:12.144+10:002011-05-17T22:49:12.144+10:00Hello. It doesn't work in my OracleXE environm...Hello. It doesn't work in my OracleXE environment. :(<br /><br /><i><br />create table tmp_ins(a number not null, b number not null);<br /><br />declare<br /> cursor c1 is select a from tmp_ins;<br /> v1 c1%rowtype;<br />begin<br /> v1.a:=1;<br /> insert into (select a from tmp_ins)values v1;<br />end;<br />/<br />select * from tmp_ins;<br /></i><br />results<br /><i><br />table TMP_INS created.<br /><br />Error starting at line 1 in command:<br />declare<br /> cursor c1 is select a from tmp_ins;<br /> v1 c1%rowtype;<br />begin<br /> v1.a:=1;<br /> insert into (select a from tmp_ins)values v1;<br />end;<br />Error report:<br />ORA-01400: cannot insert NULL into ("UANIC_DATA"."TMP_INS"."B")<br />ORA-06512: at line 6<br />01400. 00000 - "cannot insert NULL into (%s)"<br />*Cause: <br />*Action:<br />A B <br />---------------------- ---------------------- <br /><br /></i>Withttps://www.blogger.com/profile/03335458180441435271noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-68310148105461327302011-05-12T22:05:59.164+10:002011-05-12T22:05:59.164+10:00One day, when I've got some spare money, I'...One day, when I've got some spare money, I'll have to try one of those certifiaction examsSydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-56205609342065551282011-05-12T18:03:38.703+10:002011-05-12T18:03:38.703+10:00Hi.
This is used quite a bit in the SQL Expert ce...Hi.<br /><br />This is used quite a bit in the SQL Expert certification exam. :)<br /><br />Cheers<br /><br />Tim...Tim...https://www.blogger.com/profile/17721555946005999179noreply@blogger.com