-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathRoughContent.txt
21 lines (18 loc) · 1.29 KB
/
RoughContent.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Performing an SQL query
1. The next few points refer to lab 2.1 from the text.
Note: text StudentConnection is my munro_oracle above.
2. Expand munro_oracle; expand Tables; expand Course.
Investigate Columns, Data, Details
3. To open an SQL Worksheet - select Tools - select SQL Worksheet - note icon.
Note that you created an SQL Worksheet when you opened munro_oracle.
4. Enter SELECT * FROM COURSE. Note the in-line help when you pause typing in the midst..
Press the green triangle.
Do the number of courses match your result from Part A?
5. Compare the data types from the Columns of part C.2 above with the data from the Results of part C.4 above. Report results of comparison.
6. The next few points refer to lab 2.2 from the text.
7. Real ALL of lab 2.2 and try out the features.
8. Perform lab 2.2 exercise a) and b)
[Learning-Oracle-Database-12c](https://www.lynda.com/Oracle-tutorials/Learning-Oracle-Database-12c/513600-2.html)
[SQL-Essential-Training](https://www.lynda.com/SQL-tutorials/SQL-Essential-Training/139988-2.html)
[Database-Fundamentals-Core-Concepts](https://www.lynda.com/SQL-Server-tutorials/Database-Fundamentals-Core-Concepts/385693-2.html)
[Relational-Database-Fundamentals](https://www.lynda.com/Access-tutorials/Relational-Database-Fundamentals/145932-2.html)