CODEWITHSUNDEEP
sqlinsert
adarsh naresh
adarsh naresh

Reputation: 1

not sure where the comma is missing

INSERT into manufactures (man_id, man_name, address, social_media_available)
    VALUES (seq_manufactures.NEXTVAL, 'ALLIANCE INC',
    address_type('123 MEYNELL ROAD', 'LEICESTER', 'UK'),
    social_media_varray_type (
        social_media_type ('TWITTER', 'ALLIANCE'),
        social_media_type ('FACEBOOK', 'ALLIANCE'),
        social_media_type ('INSTAGRAM', 'ALLIANCE'));

Upvotes: 0

Views: 32

Answers (1)

Jonathan Lopez
Jonathan Lopez

Reputation: 31

Your'e missing a parenthesis at the end of your statement :

social_media_varray_type ( social_media_type ('TWITTER', 'ALLIANCE'), social_media_type ('FACEBOOK', 'ALLIANCE'), social_media_type ('INSTAGRAM', 'ALLIANCE')));

Upvotes: 3

Related Questions