SQL*Plus Sequence

I have an ARTIST and MEMBER table. In order to generate ArtistID/ MemberID, I use sequence:

CREATE TABLE Artist
(
ArtistID NUMBER NOT NULL,
ArtistName VARCHAR(20),
Classification VARCHAR(16),
CONSTRAINT PK_AR_Artist PRIMARY KEY(ArtistID)
);

Create Sequence artist_seq
Start with 0300,
Increment by 1;

INSERT INTO ARTIST VALUES(artist_seq.NEXTVAL, 'No Doubt', 'Pop');
INSERT INTO Artist VALUES(artist_seq.NEXTVAL,'Rolling Stones','Rock');

Output:

ARTISTID ARTISTNAME CLASSIFICATION
--------- -------------------- ----------------
300 No Doubt Pop
301 Rolling Stones Rock

I do the same thing for Member table. This table consists of members which are in group band. eg. members in NO DOUBT

CREATE TABLE Member
(
MemberID NUMBER NOT NULL,
MemberName VARCHAR(20),
CONSTRAINT PK_ME_Member PRIMARY KEY(MemberID)
);

CREATE SEQUENCE member_seq
Start with 0100
Increment by 1;

INSERT INTO Member VALUES(member_seq.NEXTVAL,'Gwen Stefani');
INSERT INTO Member VALUES(member_seq.NEXTVAL,'Tony Kanal');

Output:
MEMBERID MEMBERNAME
--------- --------------------
100 Gwen Stefani
101 Tony Kanal


I create an ArtistMember table which only contains (artistID, memberID) as Primary Key. Eg. ArtistID=300(No Doubt) consists of Member ID=100(Gwen Stefani), 101(Tony Kanal).

CREATE TABLE ArtistMember
(
ArtistID NUMBER NOT NULL,
MemberID NUMBER NOT NULL,
CONSTRAINT FK_AM_ArtistID FOREIGN KEY(ArtistID) REFERENCES Artist(ArtistID),
CONSTRAINT FK_AM_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID),
CONSTRAINT PK_AM_ArtMem PRIMARY KEY(ArtistID, MemberID)
);

However, as ArtistID and MemberID are generate by sequence, I dont know how to call MemberID to group in which ArtistID so that the result will be:

ArtistID MemberID
--------- -------------
300 100
300 101


-muinujnik-