This learning journal will be used for my entire 100 week CS study. It will include a brief description of what I have learned each week, including reading, assignment, discussion, reflection, etc (300-1000 words per week). This learning journal will help me reflect on my learning throughout the program.
17 April 2016
CST363 Week 7
This week we covered sequences (such as used as primary key), alias (temporary name for table or column), text processing (such as concatenation, lower, upper, initcap, ltrim, rtrim, lpad, rpad and substr) and date & time (to_char and sysdate).
For the assignment we built on last weeks lookup script:
set echo offset verify offset heading offset feedback off
accept OtterIDT prompt 'Please enter the OtterID:';
prompt 'Thank you!';
SELECT'Student OtterID: ', substr(OtterID, 0, 3) ||'-'|| substr(OtterID, 3, 2) ||'-'|| substr(OtterID, 5, 4) FROM student WHERE OtterID='&OtterIDT';
SELECT'Name: ', upper(Name) FROM student WHERE OtterID='&OtterIDT';