Home » RDBMS Server » Server Administration » view error
view error [message #370597] Tue, 04 January 2000 11:29 Go to next message
MAG
Messages: 3
Registered: December 1999
Junior Member
hi, I have this view to compile and It give me this error: ERROR in line 2:
ORA-00972: identifier is too long

Someone can help me ?

create or replace view per_analysis_criteria_2 as
select "ANALYSIS_CRITERIA_ID","REQUEST_ID","PROGRAM_APPLICATION_ID","PROGRAM_ID","PROGRAM_UPDATE_DATE","ID_FLEX_NUM","SUMMARY_FLAG","ENABLED_FLAG","START_DATE_ACTIVE","END_DATE_ACTIVE","SEGMENT1","SEGMENT2","SEGMENT3","SEGMENT4","SEGMENT5","SEGMENT6","SEGMENT7","SEGMENT8","SEGMENT9","(SUBSTR(SEGMENT10,1,3)||DECODE(SUBSTR(SEGMENT10,4,3),'ENE','JAN','ABR','APR','AGO','AUG','DIC','DEC',SUBSTR(SEGMENT10,4,3))||SUBSTR(SEGMENT10,7,5),'DD-MON-YYYY')","SEGMENT11","SEGMENT12","SEGMENT13","SEGMENT14","SEGMENT15","SEGMENT16","SEGMENT17","SEGMENT18","SEGMENT19","SEGMENT20","SEGMENT21","SEGMENT22","SEGMENT23","SEGMENT24","SEGMENT25","SEGMENT26","SEGMENT27","SEGMENT28","SEGMENT29","SEGMENT30","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","CREATED_BY","CREATION_DATE"
from hr.per_analysis_criteria@techint
Re: view error [message #370599 is a reply to message #370597] Tue, 04 January 2000 11:42 Go to previous message
hmg
Messages: 40
Registered: March 1999
Member
don't use the character "

the part
"(SUBSTR(SEGMENT10,1,3)||DECODE(SUBSTR(SEGMENT10,4,3),'ENE','JAN','ABR'...."
is interpreted from SQLPLUS as a alias and not as a expression.
an alias could have a maximum of 30 characters, this part has 162.
Previous Topic: simple select
Next Topic: help me
Goto Forum:
  


Current Time: Fri Oct 30 03:12:41 CDT 2020