CST 363 Week 6

Week 6

The first section of this week covered SQL queries using group by, having, and order by. Last week I didn't know that the reading for this wasn't supposed to be read yet, so I had already done the reading for these by the time this week rolled around. They're pretty basic and extremely useful, but I honestly haven't used having in my regular work and I can see it being very useful in some cases.

We also covered prompting the user for inputs and saving their inputs to variables for use later in the script. These are done by using the keywords "accept" and "prompt". To get entry from the user, you could do something like:

ACCEPT vUserInput PROMPT 'Enter your input: ';

The variables are accessed by prefixing them with an "&":

PROMPT Your input: &vUserInput 

Finally, we covered sub-queries. They're basically all just a query added into a SQL query in parenthesis instead of using variables, like you might in a regular programming language.

I've enjoyed that this week has been more hands-on. All of our assignments this week have allowed me to utilize the new computer I purchased and also use this Oracle database that many of us worked very hard to get installed.