Oracle9i SQL questions

  • Thread starter Thread starter gg70
  • Start date Start date
G

gg70

Please answer the following if you can:

1. What is the SQL command to Describe four Tables:
Publisher, Authors, Books and Bk_Author?

2. What is the SQL command to show a list of books with
each author published? (Showing author's name, book title
and ISBN?

3. What is the SQL command to Alter a BOOKS table by
adding a Publication date column. (Labeling the column
Pub_date with a "date" data type?

4. What is the SQL statement to Update a BOOKS table for
a book with ISBN No. 0-103-45678-9? (Updating Pub_date
column to have the following value 06-Jun-2001?
 
1. This looks like a homework assignment

2. This is not an Oracle newsgroup

3. Good luck!
 
Back
Top