Handling NULL values.
No. 12
Q: |
The attribute INSERT INTO Friends VALUES
(1, 'Jim', '1991-10-10')
,(2, NULL, '2003-5-24')
,(3, 'Mick', '2001-12-30'); Starting our current application yields: 1, Jim, 1991-10-10 2, null, 2003-05-24 3, Mick, 2001-12-30 This might be confuses with a person having the nickname “null”. Instead we would like to have: 1, Jim, 1991-10-10 2, -Name unknown- , 2003-05-24 3, Mick, 2001-12-30 Extend the current code of
Hint: Read the documentation of wasNull(). |
A: |
A possible implementation is being given in
|