CODEWITHSUNDEEP
sqloracle-databasejoinviewsyntax-error
Claudio Melo
Claudio Melo

Reputation: 23

ORA-00972: identifier is too long creating a view

I have this SQL to create a Oracle View but I came across this error I Already try a lot of approaches and nothing.

SELECT * FROM COM_Company 
WHERE NOT EXISTS
(SELECT NULL  FROM CTM_ServiceCompanySupportGrpAssoc  
WHERE CTM_ServiceCompanySupportGrpAssoc.Company = COM_Company.Company_ID);

Another statement was this: 

select dbms_xmlgen.getxml('SELECT * FROM COM_Company WHERE NOT EXISTS(SELECT NULL  FROM CTM_ServiceCompanySupportGrpAssoc  WHERE CTM_ServiceCompanySupportGrpAssoc.Company = COM_Company.Company_ID)') XML from dual;

I need all companies that doesn't have any support groups.

Upvotes: 1

Views: 5558

Answers (1)

Ori Marko
Ori Marko

Reputation: 58822

Identifier can be up to 30 characters. you defined identifier with 33 characters (CTM_ServiceCompanySupportGrpAssoc) see dba-oracle

Just reduce the length of your identifier name.

From Oracle 12.2 it will be longer see docs

Upvotes: 4

Related Questions