>crea curs mycursor (npk i,nrk i, cit c(5)) >insert into mycursor (npk,nrk,cit) valu (1,1,"A") >insert into mycursor (npk,nrk,cit) valu (2,1,"AA") >insert into mycursor (npk,nrk,cit) valu (3,2,"AAA") >insert into mycursor (npk,nrk,cit) valu (4,4,"a") >insert into mycursor (npk,nrk,cit) valu (5,4,"aa") >insert into mycursor (npk,nrk,cit) valu (6,6,"einar") >insert into mycursor (npk,nrk,cit) valu (7,3,"AAAA") >insert into mycursor (npk,nrk,cit) valu (8,7,"AAAAA") >insert into mycursor (npk,nrk,cit) valu (9,5,"aaa") > >select * from mycursor orde by cit,nrk,npk >