Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions