Using the SQL Database from Oracle Create a table Movie_Stars, which has the fol

Question

Using the SQL Database from Oracle

Create a table Movie_Stars, which has the following columns:

Movie Number                        numeric

Movie Title                              varying character        25

            Year Released                         date and time              (required)

            First Name                              varying character        15      

            Last Name                               varying character         15

Be sure that the movie_number column is used as a way to uniquely identify a particular movie.

Explanation / Answer

SQL> Create table Movie_Stars( Movie_Number number(15) PRIMARY KEY, Movie_tittle varchar(25), Year_Released Date, First_Name varchar(15), Last_Name varchar(15));

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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