Checked: A, B
Check:
CREATE TABLE COLORS_120
(
RGB_HEX_VALUE VARCHAR2(100)
, COLOR_NAME VARCHAR2(100)
);
CREATE TABLE BRIKS_120
(
BRICK_ID NUMBER
, COLOR_RGB_HEX_VALUE VARCHAR2(100)
);
INSERT INTO COLORS_120
SELECT 'FF0000','red' FROM DUAL
UNION ALL
SELECT '00FF00','green' FROM DUAL
UNION ALL
SELECT '0000FF','blue' FROM DUAL;
INSERT INTO BRIKS_120
SELECT 1,'FF0000' FROM DUAL
UNION ALL
SELECT 2,'00FF00' FROM DUAL
UNION ALL
SELECT 3,'FFFFFF' FROM DUAL;
A;
SELECT *
FROM BRIKS_120 b
RIGHT JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
B;
SELECT *
FROM BRIKS_120 b
FULL JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
C;
SELECT *
FROM c
FULL JOIN BRIKS_120 b
USING(RGB_HEX_VALUE);
D;
SELECT *
FROM COLORS_120 c
LEFT JOIN BRIKS_120 b
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE
WHERE b.brick_id > 0
;
E;
SELECT *
FROM BRIKS_120 b
LEFT JOIN COLORS_120 c
ON b.COLOR_RGB_HEX_VALUE = c.RGB_HEX_VALUE;
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
anzac
Highly Voted 2 years, 1 month agoWingL
1 year, 7 months agoamizh
Most Recent 11 months, 3 weeks agoamizh
11 months, 3 weeks agoArslanAltaf
9 months, 2 weeks agoyaya32
1 year agolucemqy
1 year, 2 months agojm9999
1 year, 4 months agoWingL
1 year, 7 months agoOrxan_H
1 year, 7 months agoa947739
7 months, 1 week agoDarnun
1 year, 10 months agojfc1
2 years agodexdinh91
2 years agocadcadley
2 years agoabdullah_barham
2 years, 1 month ago