Create the CUSTOMERtable structure illustrated in Figure P8.16. The customer number should store integer values. The CUST_FNAME and CUST_LNAME attributes should support variable length character data up to 30 characters each. CUST_BALANCE should support up to eight digits on the left of the decimal place and two digits to the right of the decimal place. Use CUST_NUM as the primary key. Receives error: ERROR 1050 (42S01) at line 1: Table 'CUSTOMER' already exists

Create the CUSTOMERtable structure illustrated in Figure P8.16. The customer number should store integer values. The CUST_FNAME and CUST_LNAME attributes should support variable length character data up to 30 characters each. CUST_BALANCE should support up to eight digits on the left of the decimal place and two digits to the right of the decimal place. Use CUST_NUM as the primary key. Receives error: ERROR 1050 (42S01) at line 1: Table 'CUSTOMER' already exists

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 1HOA: Create a new table containing the category code and description for the categories of books sold by...

See similar textbooks

Similar questions

Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters.
With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write the mySQL statement that will insert the following PRODUCT into the table: PRODUCT_NUMBER: ‘67832’ DESCRIPTION: ‘KRAZY CAT CEREAL’ PURCHASE_DATE: 2023-11-14 CATEGORY: ‘CPG’ Write the mySQL statement that will insert that product but without a description.
You have been instructed to add a new student information to the students table. Because the student is new, he has no marks before, you should not add an amount to the CGPA. The Students table contains these columns: Student_id NUMBER(10) Student_name VARCHAR2(30) Student phone NUMBER(10) CGPA NUMBER(2,2) Which INSERT statements will accomplish your objective? O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 ) O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' ) O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL ) O d. INSERT INTO students VALUES (365, 'Khalil',99554721) Which line of code has an error? 1. CREATE TABLE FRUITS VEGETABLES 2. FRUIT TYPE VARCHAR2, 3. FRUIT NAME CHAR (20), 4. QUANTITY NUMBER (4)); O a. 1 O b. 2 O c. 3
9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12 Notes: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code. In another lab that creates the Horse table, RegisteredName is NOT NULL. In this l
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
3. In Customers, display cust_name followed by the last four digits of cust_id, with the alias shown below. Display in alphabetical order by cust_name. CUST_NAME Fun4All Fun4All Kids Place The Toy Store Village Toys 5 rows returned in 0.00 seconds Download 0003 0004 0002 0005 0001 ID (Last 4 Digits)
insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname | city | +---------+---------------+--------+ | ch01 | Omni Shoreham | London | | ch02 | Phoenix Park | London | | dc01 | Latham | Berlin | | fb01 | Grosvenor | London | | fb02 | Watergate | Paris | +---------+---------------+--------+ mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type | price | +--------+---------+--------+-------+ | 501 | fb01 | single | 19.00 | | 601 | fb01 | double | 29.00 | | 701 | ch02 | single | 10.00 | | 701 | fb01 | family | 39.00 | | 801 | ch02 | double | 15.00 | | 901 | dc01 | single | 18.00 | | 1001 | ch01 | single | 29.99 | | 1001 | dc01 | double | 30.00 | | 1001 | fb02…
The InstantRide Finance team wants to know the average discount amounts for each car in the InstantRide. Calculate the average discount amount as monetary value for the travels where a discount is applied. You need to create a subquery over the TRAVELS table to retrieve CAR_ID and DISCOUNT_AMOUNT, calculated with 2 decimals using the ROUND function. To calculate the DISCOUNT_AMOUNT, multiply the TRAVEL_PRICE by the TRAVEL_DISCOUNT where the TRAVEL_DISCOUNT value is not NULL. Round the result to 2 decimals. Then you can use this subquery to get the CAR_ID and AVG of DISCOUNT_AMOUNT values, once again using the ROUND function on the average results. Group the results by the CAR_ID. Use CAR_ID and DISCOUNT_AMOUNT as column aliases and return it back to the Finance team.
1. ID Last Name First Name Create the My Employee table with the following fields: Not Null Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) Userid Salary 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali 1 2 3 4 5 AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed 4. Select all the data in the table. Userid raptel bdancs bbiri cnewman aropebur I Salary 795 860 1100 750 1550
The pg2.np_2016traffic table contains monthly traffic statistics from the National Park Service for parks. Create a table using sas programming language that contains the monthly traffic statistics from the pg2.np_2016traffic table and adds a column for the park name. Park name values can be found in the matching pg2.np_codelookup table.
Q11: After mapping the following ERD, choose the correct SQL statement that will insert a single row to the Vertebrates Table AID weight Vertebrates vertrebraLength Animal AName Disjoint ISA Invertebrates locations Eats amountPerDay type Food FID a. Insert into Vertebrates (VertebratesLength) values (1.5') b. Insert into Vertebrates (AID, AName, Weight) values (101', 'Salmon', '30') c. Insert into Vertebrates (AID, AName, Weight, VertebratesLength) values (101, 'Salmon', '30','1.5) d. Insert into Vertebrates (AID, Vertebrates Length) values (101', '1.5')