This code isnt working. Please fix it to help create the table. Post the table created after you get it to run. DO NOT USE AI OR CHATGPT! I can tell when you do CREATE TABLE LINE ( INV_NUMBER NUMBER NOT NULL, LINE_NUMBER NUMBER(2,0) NOT NULL, P_CODE VARCHAR(10) NOT NULL, LINE_UNITS NUMBER(9,2) DEFAULT 0.00 NOT NULL, LINE_PRICE NUMBER(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV_NUMBER,LINE_NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));

This code isnt working. Please fix it to help create the table. Post the table created after you get it to run. DO NOT USE AI OR CHATGPT! I can tell when you do CREATE TABLE LINE ( INV_NUMBER NUMBER NOT NULL, LINE_NUMBER NUMBER(2,0) NOT NULL, P_CODE VARCHAR(10) NOT NULL, LINE_UNITS NUMBER(9,2) DEFAULT 0.00 NOT NULL, LINE_PRICE NUMBER(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV_NUMBER,LINE_NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter10: Selected Single-row Functions

Section: Chapter Questions

Problem 2HOA: Create a list of all customer numbers along with text indicating whether the customer has been...

See similar textbooks

Similar questions

Please give me correct solution.
Write an anonymous block which updates the .Physician table.(As you can not update the .Physician Table, you will have to create your own table based on the structure and contents of the Physician Table). Use named parameters to get values for Phys_ID, Phys_name, Phys_phone, and Phys_speciality. If the value for Phys_ID is in the Physician Table, Update the values of the remaining columns. If the Phys_ID is not in the Physician Table, INSERT a row into the Physician Table with those values. - Hint: Use variables for each of the columns above and assign a named parameter to each of them. Then use the variable in the rest of the block. - Write a simple driver to test the block with a Phys_ID that is in the Physician Table and a Phys_ID that is not in the Physician Table. Physician Table Phys_ID Phys_Name Phys_Phone Phys_Specialty ----------- ------------------------…
This code isnt working. Please fix it to help create the table CREATE TABLE LINE ( INV_NUMBER NUMBER NOT NULL, LINE_NUMBER NUMBER(2,0) NOT NULL, P_CODE VARCHAR(10) NOT NULL, LINE_UNITS NUMBER(9,2) DEFAULT 0.00 NOT NULL, LINE_PRICE NUMBER(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV_NUMBER,LINE_NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));
This code isnt working. Please fix it to help create the table. Post the table created after you get it to run. DO NOT USE AI OR CHATGPT! I can tell when you do CREATE TABLE INVOICE ( INV_NUMBER NUMBER PRIMARY KEY, CUS_CODE NUMBER NOT NULL REFERENCES CUSTOMER(CUS_CODE), INV_DATE DATE DEFAULT SYSDATE NOT NULL, CONSTRAINT INV_CK1 CHECK (INV_DATE > TO_DATE('01-JAN-2014','DD-MON-YYYY')));
Hi, The code below is always giving errors. Could you find out and fix it, please? Many Thanks. --Creating a tableCREATE TABLE IF NOT EXISTS Student ( STU_NUM CHAR(6) NOT NULL, STU_SNAME VARCHAR(15) NOT NULL, STU_FNAME VARCHAR(15) NOT NULL, STU_INITIAL CHAR(1) NOT NULL, STU_STARTDATE DATE NOT NULL, COURSE_CODE CHAR(3), PROJ_NUM INT, PRIMARY KEY (STU_NUM)); --Inserting into tableINSERT INTO Student (STU_NUM,STU_SNAME, STU_FNAME, STU_INITIAL, STU_STARTDATE, COURSE_CODE , PROJ_NUM)VALUES ('01', 'Snow', 'John', 'E', '05-Apr-14', '201' , '6'); INSERT INTO Student (STU_NUM,STU_SNAME, STU_FNAME, STU_INITIAL, STU_STARTDATE, COURSE_CODE , PROJ_NUM)VALUES ('02', 'Stark', 'Arya', 'C', '12-jul-17', '305' , '11'); --FILTER STUDENTS WITH COURSE CODE 305SELECT * FROM Student WHERE COURSE_CODE = '305'; --All the records have been addedINSERT OR REPLACE INTO Student (STU_NUM,STU_SNAME, STU_FNAME, STU_INITIAL, STU_STARTDATE, COURSE_CODE ,…
Create table “Cleaner” (cNo varchar2(5), cName varchar2(20), cSalary number(6,2), dNo varchar2(5)). Write a table level trigger which can tell how the restriction on ‘cSalary’ is violated. Whenever the value of ‘cSalary’ is beyond the valid range (0 – 5000), the trigger will generate an error message informing user whether it is greater than 5000 or a negative number
Save the changes permanently to the database.
Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.
Please give me correct solution with explanation. The DATE option of the COLUMN command does not allow a specific format to be applied to date values. True False
Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.
Please read the instrucitons before posting an answer that someone else has already posted. GROUP_CONCAT is not permitted.
PLZ help with the followng: List all painting titles with price greater than 5000$. How many paintings does ‘Ross Georgette’ have? Find the title of paintings that displayed on ‘L. R. Gilliam’ gallery. CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567');INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112');INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456'); /* -- */ CREATE TABLE…