Question: SQL class homework trouble Write the SQL to CREATE a new table in Oracle XE, then INSERT three rows of data into your table. (Use
SQL class homework trouble
Write the SQL to CREATE a new table in Oracle XE, then INSERT three rows of data into your table. (Use yourself as one row of data.) Table name: STUDENT Primary Key: StudentID Other Attributes: Firstname, Lastname, Street, City, State, Zip, Major, GradeLevel, DateofBirth, Gender Once your table has been successfully created in SQL Developer, copy and paste the SQL command used into a Word Document AND the screenshot of your SQL Developer window The screenshot should include the entire SQL Developer window including your database connection. So it would look something like this
Answer #1: CREATE TABLE REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE CHAR(5), INSERT INTO ORDER_LINE VALUES ('51623','KD34',10.00,13.10); INSERT INTO ORDER_LINE VALUES ('51625','MT03',8.00,45.79); NOTE: This is an incomplete script to save space. You should always include all of the SQL that is requested
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
