Although we discussed spooling in this chapter, a short-cut way to copy, save an

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 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.

Explanation / Answer

1. DESC course

                  SELECT * from rearp.Course;

2.

DESC enrolledDetails

SELECT * from enrolledDetails;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.