Since I have data in hebrew (UTF8) in my oracle 9, I would like to display the columns headings in hebrew .
But when I run the sql script below, I get th error:
SP2-0158: unknown COLUMN option "����'"
COL ID FORM A26 HEAD 'פקולטה'
COL LIB FORM A26 HEAD 'זהות'
COL Degree FORM A26 HEAD 'שם'
COL STU_NAME FORM A26 HEAD 'תואר'
select LIBSHEM.LIBNAME LIB,toarname Degree,Z13_AUTHOR
STU_NAME, Z13_USER_DEFINED_3 ID From TEC01.Z13, TOAR, LIBSHEM
where Z13_USER_DEFINED_3 is not null and Z13_USER_DEFINED_5_code = toarcode and Z13_USER_DEFINED_1 = 'HEB'
AND trim(LIBSHEM.LIBCODE) = trim(Z13_USER_DEFINED_5)
union all
select LIBSHEM.LIBNAME LIB,toarname Degree, Z13_USER_DEFINED_2
STU_NAME, Z13_USER_DEFINED_3 ID From TEC01.Z13, TOAR, LIBSHEM
where Z13_USER_DEFINED_3 is not null and Z13_USER_DEFINED_5_code = toarcode and Z13_USER_DEFINED_1 = 'ENG'
AND trim(LIBSHEM.LIBCODE) = trim(Z13_USER_DEFINED_5)
order by LIB