sql - Issue with null values being inserted -

-

so have searched on answer, know it'll basic , silly i've overlooked life of me can't see it.

at insert "" values point, i'm stuck unable insert null values.. need spaces blank. :/

drop table patient; drop table kennel; drop table prescription; create table patient  ( patient_id               number, name                     varchar2(15), dob                      date, primary key(patient_id) ); create table kennel ( kennel_no                varchar2(2), kennel_section           varchar2(1), admission_date           date, patient_id               number,  primary key(kennel_no), foreign key (patient_id) references patient ); create table prescription  ( prescription_date        date, drug_code                varchar2 (5), drug_name                varchar2 (55), dosage                   varchar2 (25), num_days_dosage  number , kennel_no  varchar(255), foreign key (kennel_no) references kennel  ); insert patient values   (1234,'wiggles','12 dec 1996'); insert patient values   ('','',''); insert patient values   (4587, 'woofy', '15 nov 1999'); insert patient values   ('', '',''); insert patient values   ('', '',''); insert patient values   (4692,'hiccup','3 apr 1998'); insert patient values   ('', '',''); insert patient values   ('', '',''); insert patient values   (5432, 'sandy', '2 jun 2002 '); insert patient values   ('', '', ''); insert patient values   ('', '', ''); insert patient values   (2591, 'snoopy', '28 aug 2001'); insert patient values   ('', '', ''); insert patient values   (4563, 'dopey', '1 apr 2004'); insert kennel  values   (23,'a', '20 oct 2005'); insert kennel  values   ('', '', '');  insert kennel  values   (28, 'b', '10 nov 2005'); insert kennel  values   ('', '', ''); insert kennel  values   ('', '', ''); insert kennel  values   (25, 'a', '21 nov 2005'); insert kennel  values   ('', '', ''); insert kennel  values   ('', '', ''); insert kennel  values   (35,'c', '30 nov 2005'); insert kennel  values   ('', '', ''); insert kennel  values   ('', '', ''); insert kennel  values   (34, 'c', '04 dec 2005'); insert kennel  values   ('', '', ''); insert kennel  values   (30, 'b', '06 dec 2005'); insert prescription  values  ('20 oct 2005', 'co156', 'cortisone', '2 pills, 3 times day', 14, 23);   insert prescription  values  ('23 oct 2005', 'ap566','aspirin', '1 pills, 3 times day', 10, 23); insert prescription  values  ('13 nov 2005','pe312', 'penicillin', '1 pill, 3 times day', 5, 28); insert prescription  values  ('14 nov 2005','ap566', 'aspirin', '2 pills, 2 times day', 14, 28);  insert prescription  values  ('15 nov 2005','co156', 'cortisone', '2 pills, 3 times day', 10, 28);  insert prescription  values  ('22 nov 2005','pe312', 'penicillin', '1 pill, 3 times day', 2, 25); insert prescription  values  ('23 nov 2005', 'ap566','aspirin', '2 pills, 2 times day', 10, 25); insert prescription  values  ('24 nov 2005', 'be159', 'benzocaine', '2 pills, 3 times day', 7, 25); insert prescription  values  ('30 nov 2005', 'co156', 'cortisone', '1 pill, 3 times day', 7, 35);   insert prescription  values  ('02 dec 2005', 'ap566', 'aspirin', '2 pills, 2 times day', 12, 35); insert prescription  values  ('03 dec 2005', 'be159', 'benzocaine', '2 pills, 3 times day', 2, 35); insert prescription  values  ('04 nov 2005', 'co156', 'cortisone', '1 pill, 3 times day',10, 34); insert prescription  values  ('05 dec 2005', 'ap566', 'aspirin', '2 pills, 2 times day', 8, 34); insert prescription  values  ('06 nov 2005', 'pe312', 'penicillin', '3 pills, 3 times day',7,30);

your column set allow nulls, and/or have no default value. check settings on table.


Comments

Post a Comment

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

-
i have implement video collection website users of specific isp. site hosted on public web-server movies hosted on local isp server. user of isp + general visitors can see available movies; isp's users able play them. player on site point url of local machine ( http://192.x.x.x/movies/mymovie.mov ) private class (192.x.x.x) accessible isp user. question: possible phpmotion script? or need custom work. if possible, can please suggest available mods? phpmotion require modifications able handle this. uploading, conversion, thumbnail generation, , playback pretty static in phpmotion. really though, rather modding entire upload , conversion process, if created quick custom form add entries phpmotion database (maybe include thumbnail upload), tweaked playback paths, should go on phpmotion side of things. assume had videos in format player handle (such flv or mp4).
Read more

javascript - Using Windows Media Player as video fallback for video tag -

-
getting video play cross platform using example video.js bit of fuss. in days when video should embedded use embed windows media player, work out of box on windows. since it's today old ie on windows doesn't support video tag experimented using windows media player fallback, , work well. what wonder here is, why haven't else solution? have missed something? code small, there's no flash files, cross domain issues or need of server working. works. so before develop further , add custom control , subtitles support wonder say. the code looks this: <video id="myvideo" style="width:640px; height: 360px;" autoplay data-wimpsource="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.mp4"> <source src="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.mp4" type="video/mp4" /> <source src="http://esd.volvocars.com/dc/cdn/video/birds-on-a-wire.webm" type="video/webm" />
Read more

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get
Read more