Question
Although we discussed spooling in this chapter, a short-cut way to copy, save and print your SQL output would be to copy and paste your
Although we discussed spooling in this chapter, a short-cut way to copy, save and print your SQL output would be to copy and paste your SQL output into a word processor, and then save and print your output from there. We suggest you use the short-cut method the copy and paste method to hand in your exercises. To keep a complete record of your work, it would be good idea to copy/paste your query as well as your query result.
Please answer 1.1 and 1.2
1-1. Print a description of the Course table (use DESC Course). Use the SELECT statement to display the actual data. (Just a reminder you will have to use rearp. in front of all the table names, since you are not the owner of these tables. So, you will have to type in rearp.Course instead of just Course in your query).
1-2. Create a synonym for the Student table. Display the table description using the synonym. Display all the data in the Student table using SELECT.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started