While bord, I read about scientists questioning Einstein's theory of relativity. I found it interesting. I am not smart enough to question such things. I have to accept some subjects to get by.

To scientist, science is not so fragile that they don't question it.

Questioning Einstein excited me because something that I have grown up as settled and accepted science was challanged. I cannot find the article today, but I found something that had a great quote:

"Einstein's right, at least for now," [1]

This leads into the list that scientist once believed from another article titled "Let's Follow the History of Science Instead." [2] [3] The list was a basis for the statement that science and scientist are fallable.

1. That the earth is a flat disk, not a sphere, and that it resides at the center of the solar system and even the entire universe.

2. Said earth was created like 6,000 years ago.

3. Complex life forms spontaneously arise from inanimate matter.

4. Species evolve by inheriting acquired characteristics.

5. That sickness arises from an imbalance of the bodily humors or bad air (miasma!) and in either case is best restored by draining the afflicted person of blood and/or applying massive doses of mercury.

6. Maternal thoughts cause birth defects.

7. Human beings are not all equal but rather composed of races, some of which are superior to others. Just measure their skulls for proof!

8. Phlogiston and caloric exist and explain combustion.

9. If you cultivate an area, rainfall in that area will increase. “Rain follows the plow.”

10. Another ice age was upon us in the 1970s.

I can't entirely agree with everything stated in the article; however, the main point is correct. Science is not always right. Scientists are not monolithic. What makes science less fragile is to have a theory beaten to an inch of it's life and still stand.

Now, for my statement of faith: I believe in currently accepted science, till proven otherwise. I am not willing to treat science as a religion.

References

Just going to say, mime encoding is almost as old as the Internet and is very used.

At work, we have a problem with vendor code. They are using java in Oracle. It works in TEST, but not in PROD. It is a permissions problem. I am no DBA right now.

What I enjoy about Oracle docs, is that there is amost no simple snippets of code to help or give ideas how to do things. AskTom is more the rule than the exception.

This is an example on doing an mime encoded hmac sha256 in oracle.

Pleasae note: dbms_crypt requires permissions.

Returns:

b41G4Q69boaNfRfITrxdIjoytRhjQ+mAou643eDJ9Ow=

The number 3 the same as: DBMS_CRYPTO.HMAC_SH256. Just that if you use DBMS_CRYPTO.HMAC_SH256 you get:

ORA-06553: PLS-221: 'HMAC_SH256' is not a procedure or is undefined
06553. 00000 -  "PLS-%s: %s"

The code above should work in Oracle 12c and above.

Well, this did not go far. Visit to my folks and a 500+ mile round trip road trip in one day does not help with bladder and steps.

Just a daily completion logs. I might not update this daily, but the activity must be.

My rules from 75 hard (my version):

• Exercise: Complete 10,000 steps day. My normal excercise regiment is more than sufficient. My weekly exercise is more than sufficient. Just check my Strava page.

• Drink 12 cups of water or more based on Garmin's hydration with auto increase turned on (today I am expected to drink 18 cups). Only clear water or drinks for the purpose of hydration count.

• going to skip the reading

• Diet: Record food on myfitnesspal and complete entry every day. No food prohibitions. A cheat is not honestly logging comleting the entry.

• Take a progress picture.

• Day ends when I go to bed.

My year in exercise defines the phrase that one cannot out-exercise a body diet or habits. This week on a bloated day, I hit 198 pounds. I have been trying to reboot my diet for the last two years. I am not a big fan of fat acceptance.

I am going to challenge myself to a modified 75 hard.

First off what is 75 hard:

The 75 Hard challenge was created by called Andy Frisella and goes along the lines out of 'challenging' yourself because it will help you figure out who you really are and how mentally tough you are.

The challenge consists of the following tasks, which must be completed every day without exception:

• Two 45-minute workouts (you define what the workouts are)

• Drink 1 gallon of water

• Read 10 pages of a personal development/business/self-help book

• Stick to a diet (you define the diet)

• No alcohol or cheat meals

• Take a progress picture

There are also a few rules:

• You must complete all 75 days in a row; if you miss a single day you fail. Failure means any deviation from your plan, in the strictest sense. No substitutions, no catch-up days, no excuses.

• If you fail, you must start over on day 1

• One of the daily workouts must be outside, no matter what the weather conditions are

• Audiobooks do not count toward the reading goal

• The day ends when you go to bed

Cool, the problem for me, is that most likely I will not be able to get my other tasks done. I have tasks that I falling behind in. I have no plans of doing another 45-minute exercise session if I bike 60 miles to Faria Beach, jog 8 miles, or bike to Gibraltar peak (extreme example). I am in reading burnout from work (more than 10 pages of manuals). Besides, for the most part, metal toughness is not what I need. I need to get back into a routine. I plan to modify the goals along the line of this entry from Hoyle's Fitness.

• Dietary Discipline – Eating well. Only drinking on social occasions, not at home

• Train Every Day – 75 days without a day off. Active recovery counts

• Drink 3 liters of Water per Day – Nothing but clear, plain water counts

• Read 10 Pages per Day – From a non-fiction self-help book or business book

• Take a Progress Picture Every Day – So you can see the progress at the end

• Complete a full 10,000 steps per day

I think it would not hurt to start posting some of the work I do for my employer. Nothing will be company confidential. There is almost nothing company confidential when you work for a public institution with a few exceptions of FERPA, PII, student records, etc.

One of the tasks that I was asked to do is to integrate data from the SBCC BANNER ERP system with Verba's Inclusive Access system. The project was simple.

• Create a population-based on student enrolment

• Create a sample file

• Create key file for sftp

• automate

Currently, I have to do is automate in ISE. This will have to wait till next week when the move Banner to Oracle Cloud project is done.

This is the code that I create (in a procedure for work, this so I can run it manually).

BTW, should this be in a GitHub gist or this good enough? I like GitHub, but there is a part of me that prefers to keep things local.

declare
        --set up output parameters

        gbcn_outfilepath   CONSTANT VARCHAR2(64) := 'SBCC_OUTGOING';
        v_file_name_s      VARCHAR2(64) := 'ia_enrollment' || '.csv';
        v_fh_s             utl_file.file_type;
        v_outbuf           VARCHAR2(4000);
        v_cat_count        INT(2) := 0;


        CURSOR c_students IS SELECT
                sfrstcr_term_code catalog_name,
                ssbsect_subj_code department_name,
                ssbsect_crse_numb course_number,
                sfrstcr_crn section_code,
                gzf_get_id(sfrstcr_pidm) student_identifier,
                gzf_format_name(sfrstcr_pidm,'PREFF') student_first_name,
                gzf_format_name(sfrstcr_pidm,'L') student_last_name,
                gzf_email_addr(sfrstcr_pidm,'SBCC') student_email_address
                                                 FROM
                sfrstcr
                INNER JOIN stvrsts ON sfrstcr_rsts_code = stvrsts_code
                LEFT OUTER JOIN ssbsect ON ( ssbsect_term_code = sfrstcr_term_code
                                                                         AND ssbsect_crn = sfrstcr_crn )
                                                 WHERE
                sfrstcr_term_code IN (
                        SELECT
                                stvterm_code
                        FROM
                                stvterm
                        WHERE
                                stvterm_code <> '999999'
                                AND stvterm_end_date > SYSDATE
                        INTERSECT
                        SELECT
                                goriccr_value
                        FROM
                                goriccr
                        WHERE
                                goriccr_icsn_code = 'ACTIVE_TERM'
                );

BEGIN
        -- open file
        v_fh_s := utl_file.fopen(gbcn_outfilepath,v_file_name_s,'w');

        --header record
        utl_file.put_line(v_fh_s,'"catalog_name","department_name","course_number","section_code","student_identifier","student_first_name","student_last_name","student_email_address"');

        --write data
        FOR v_students IN c_students LOOP
                v_outbuf := '"'
                                        || v_students.catalog_name
                                        || '",'
                                        || '"'
                                        || v_students.department_name
                                        || '",'
                                        || '"'
                                        || v_students.course_number
                                        || '",'
                                        || '"'
                                        || v_students.section_code
                                        || '",'
                                        || '"'
                                        || v_students.student_identifier
                                        || '",'
                                        || '"'
                                        || v_students.student_first_name
                                        || '",'
                                        || '"'
                                        || v_students.student_last_name
                                        || '",'
                                        || '"'
                                        || v_students.student_email_address
                                        || '"';

                utl_file.put_line(v_fh_s,v_outbuf);
        END LOOP;

        --close file
        utl_file.fclose(v_fh_s);
end;

John 8:7 NABRE But when they continued asking him, he straightened up and said to them, “Let the one among you who is without sin be the first to throw a stone at her.”[1]

References