With this simple SQL,I can retrieve up to a certain point before things explode. If I retrieve 100 or less rows, I seem to be OK, no matter what I do, even with the "Preview CLOB and LONG data" option is checked. Upon approval, Change Control deploys the changes to production Submit the change request for review and approvalĬ. Create a change request packet which includes the required ToDo steps and a recovery plan if the change failsī. Deployment - Currently version control is not part of the flow so, pretty standard handoverĪ. Create and test scripts to populate existing student_history records with historic total credits dataĢ. Update daily_student materialized view query (to include retrieval of total_credits)į. Update daily_student materialized view (source of total credits by student by day, used by several apps)Į. Update the nightly script which the auto-scheduler runs to populate student history from daily_studentĭ. Update student_records package (note: several functions reference the student history table so each function will have to be modified and tested)Ĭ. Add total_credits column to student_history table (note: be sure to retain existing data)ī.
Programming - That ticket would generate the following work effortĪ. Hypothetical Request Ticket: Add Total Credits to the Student History Tableġ. Can you walk me through what I should do and what team coding and version control will be doing? Some areas of uncertainty are table DDL vs table ALTERS, conversion scripts, and the whole deployment thing, like, is our VCS "trunk" Test or is it PROD? If its TEST, then when/how do we "move" changes to "production", VCS speaking, and Oracle speaking?
(FWIW, as I've said other places, we're a small team supporting our in-house systems which are dominated by our academic ERP system). I'd rather have all it somehow safely ensconced in version control but, as you say.Ĭan we put the whole thing together somehow? Here's an example work effort for us. Using check-out status as a reminder of unfinished code could work. Sometimes they make my head ache :\ but I'd rather deal with them now instead of later when we're live! Thanks John, You continue to add insights on making this work.
0 kommentar(er)
