Question
I can run these individual but when I run them all at a time, it only completes a few in oracle. What do I need
I can run these individual but when I run them all at a time, it only completes a few in oracle. What do I need to fix this.
/* 1 */ Select * from PRODUCT where P_DESCRIPT like '%saw%' /* 2 */ Select * from PRODUCT where P_PRICE <20 and p_qoh>100 /* 3 */ Select * from PRODUCT where P_PRICE <20 or p_qoh>100 /* 4 */ Select P_CODE,P_DESCRIPT,P_PRICE FROM PRODUCT WHERE V_CODE = 21344 /* 5 */ SELECT P_CODE, P_DESCRIPT, P_PRICE, (P_PRICE - P_DISCOUNT) AS NewPrice FROM PRODUCT WHERE V_CODE IS NULL; /* 6 */ SELECT P.P_CODE, P.P_DESCRIPT, V.V_NAME FROM PRODUCT P, VENDOR V WHERE P.V_CODE = V.V_CODE AND V.V_State = 'TN' /* 7 */ SELECT EMP_TITLE,EMP_FNAME,EMP_INITIAL FROM EMPLOYEE WHERE EMP_MGR IS NULL /* 8 */ SELECT COUNT(DISTINCT(P_CODE)) FROM LINE /* 9 */ select EMP_MGR,count(EMP_NUM) from employee where EMP_MGR is not null group by EMP_MGR; /* 10 */ select P_DESCRIPT,CUS_LNAME,CUS_FNAME,CUS_INITIAL from product,CUSTOMER,INVOICE ,LINE where product.P_CODE=LINE.P_CODE and Line.INV_NUMBER=INVOICE.INV_NUMBER and INVOICE.CUS_CODE=CUSTOMER.CUS_CODE and CUS_BALANCE between 100.00 and 500.00 order by CUS_LNAME,CUS_FNAME,CUS_INITIAL; /* 11 */ SELECT i.INV_NUMBER, i.INV_DATE,SUM(l.LINE_PRICE) AS TOTAL_PRICE FROM INVOICE i INNER JOIN LINE l ON i.INV_NUMBER = l.INV_NUMBER GROUP BY i.INV_NUMBER,i.INV_DATE ORDER BY i.INV_NUMBER DESC,i.INV_DATE /* 12 */ Select distinct CUS_LNAME from CUSTOMER UNION Select distinct EMP_LNAME from EMPLOYEE; /* 13 */ SELECT CUS_LNAME FROM CUSTOMER UNION ALL SELECT EMP_LNAME FROM EMPLOYEE; /* 14 */ SELECT P_DESCRIPT FROM PRODUCT WHERE V_CODE IN (SELECT V_CODE FROM VENDOR WHERE V_AREACODE = 615); */ 15 */ SELECT P1.P_DESCRIPT from PRODUCT P1 WHERE EXISTS (SELECT 1 FROM VENDOR V INNER JOIN PRODUCT P ON (V.V_CODE = P.V_CODE) WHERE V.V_AREACODE = '904' and P.P_CODE = P1.P_CODE);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started