Create a new scheme called hollywood a. login to system account b. Start the script
Question:
Create a new scheme called hollywood
a. login to system account
b. Start the script hollywoodschema.sql
2. Load DB
a. login to hollywood account with 'password'
b. Start the script hollywoodnorthcreatetables.sql
c. Start the script populatehollywoodnorth.sql
How do you prepare a template? It suppose to look something like this
-- Solution for Question 1
-- Your script for question 1 here
-- Solution for Question 2
-- Your script for question 2 here
They're supposed to be five questions. I know what the questions are going to be about but I don't know what he's going to be asking for.
One question will ask for something for one of these. Can you tell me step by step on how to do each one?
- Simple queries
- Join-based queries
- Single-row functions queries
- Group functions queries
- Subqueries
Basically he will give us a table I do like this
The tables could be small or as big as this and there could be one to three tables for each question. We have to use the three SQL files that he told us to populate to find answers for each of the five topics above. There will be five questions, one question will be asking for one of the five.
Also these are tips for success. How do I use these? Can you show screenshots when using this in Oracle SQL
Tips for Success
1. Use column aliases to create appropriate column headers.
2. Use set linesize xxx, where xxx is a number to set the width for the output.
3. Use a column command to set the size of the columns, e.g.:
column "aliasname" format A40
column "stagename" format A30
"A" means alphanumeric field, with a length of 30 characters in the example above.
4. For number columns use:
column "aliasname" format 9999.99
This will show four digits before the decimal point and two digits after the decimal point.
5. Use clear columns; at the end of each query to reset the column size.
6. Use the following format for breaks:
break on columnname/alias [on columnname/alias]
Systems Analysis and Design in a Changing World
ISBN: 978-1305117204
7th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd