create table cjb as
SELECT TRIM(TO_CHAR(REPLACE(STUDENT_CODE, 0, '9'), 'XXXXXXXX')) STUDENT_CODE,
SCHOOL_YEAR,
SEMESTER,
COURSE_CODE,
COURSE_NAME,
SCORE,
REEXAM_SCORE,
RETAKE_SCORE,
CREDIT,
GRADE_POINT,
RETAKE_SEMESTER,
JX0404ID,
TRIM(TO_CHAR(REPLACE(TEACHER_CODE, 9, 0), 'XXXXXXXX')) TEACHER_CODE
FROM IN_JWXT_CJB
之后就报ora-01722错误麻烦大神了
|