Hi All,
create table sortData(id NUMBER, MATRIC_NMBR varchar2(50));
I have created seqence for id as ID_SEQ .
while inserting record error is comming missing right paranthesis
insert into sortData(id,Matric_Nmbr)
values(ID_SEQ.NEXTVAL,
(select MATRIC_NMBR from mae_eid
order by COURSE_CODE,SEX,NATIONALITY));
Pallavi