order in names with sql

[mdpandu]

hi all...
here a problem..we have geting names in the order of first name and then lastname.now the requirement is start with last name and first name.with A-Z naming order.plz change this code based on my requirement....

"SELECT DECODE((u.usr_first_name||' '||u. usr_last_name),' ', a.usr_name, " +
"(u.usr_first_name||' '||u. usr_last_name)) user_name1, " +
"(INITCAP(SUBSTR(U.USR_FIRST_NAME,1,1)) || '. ' || U.USR_LAST_NAME)INITIAL_NAME, " +
"U.DEGREE DEGREE, rewr_id, rewr_type_code, attd_meet_flag, voter_flag, " +
"(SELECT COUNT(ar.pr_flag) FROM PTL_ASGN_RVRS ar, AGENDA_LIST al WHERE " +
"ar.rewr_id = a.rewr_id AND ar.panel_id = al.panel_id AND " +
"al.agenda_id = a.agenda_id AND ar.meeting_date = al.meeting_date " +
"AND ar.pr_flag = 'Y')pr_cnt, (SELECT COUNT(ar.pexpert_flag) FROM PTL_ASGN_RVRS ar, " +
"AGENDA_LIST al WHERE ar.rewr_id = a.rewr_id AND ar.panel_id = al.panel_id AND " +
"al.agenda_id = a.agenda_id AND ar.meeting_date = al.meeting_date AND " +
"ar.pexpert_flag = 'Y')pexpert_cnt, (SELECT COUNT(ar.npr_flag) FROM PTL_ASGN_RVRS ar, " +
"AGENDA_LIST al WHERE ar.rewr_id = a.rewr_id AND ar.panel_id = al.panel_id AND " +
"al.agenda_id = a.agenda_id AND ar.meeting_date = al.meeting_date AND " +
"ar.npr_flag = 'Y')npr_cnt, (SELECT COUNT(ar.presenter_flag) FROM PTL_ASGN_RVRS ar, " +
"AGENDA_LIST al WHERE ar.rewr_id = a.rewr_id AND ar.panel_id = al.panel_id AND " +
"al.agenda_id = a.agenda_id AND ar.meeting_date = al.meeting_date AND " +
"ar.presenter_flag = 'Y')presenter_cnt, mail_flag, arr_time_hours, arr_time_mins, " +
"left_time_hours, left_time_mins,alternate_to, attended_meet_flag, u.usr_last_name FROM " +
"USR u, USR_ROLE_PRIVS ur, AGENDA_REWR_LIST a WHERE a.rewr_id = u.usr_id(+) AND " +
"u.usr_id = ur.usr_id AND ur.rp_id != 1 AND agenda_id = ? ORDER BY rewr_type_code DESC, " +
"u.usr_last_name";