Oracle9i SQL questions

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?
 
K

Kevin3NF

1. This looks like a homework assignment

2. This is not an Oracle newsgroup

3. Good luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top