example (SQL)

Sai_kiran_rachakonda · June 27, 2022

CREATE TABLE palette_a (
    id INT ,
    color VARCHAR2 (100),
    favcol VARCHAR2(20)
);

INSERT INTO palette_a 
VALUES (1, 'Red', 'black');

INSERT INTO palette_a 
VALUES (2, 'Green', 'black');

INSERT INTO palette_a 
VALUES (3, 'Blue', 'black');

select color ||  ' '  || favcol from palette_a ;

Output

Comments

Please sign up or log in to contribute to the discussion.