Database Administration (MOSC)

MOSC Banner

ORA-00918: column ambiguously defined

edited Dec 3, 2014 6:48AM in Database Administration (MOSC) 4 commentsAnswered

Hello guys,

Please i need a help:

get this error ORA-00918: column ambiguously defined

When i try;

insert into OSD.OSD_CLIENTE_INSTALACAO

select

old.NUMERO_CLIENTE,

old.ANO,

11,

MES,

old.CODIGO_INSTALACAO,

old.CODIGO_PEE,

old.EMPRESA,

old.NOME,

old.ENDERECO,

old.POTN,

old.MEDIDOR,

old.SUBESTACAO,

old.CONSUMO,

old.CONJUNTO_ANEEL_PEE

from (select * from osd_cliente_instalacao

where ano = 2014 and mes =11 and empresa = 'BANDEIRANTE') new,

(select * from osd.osd_cliente_instalacao

where ano = 2014 and mes =10 and empresa = 'BANDEIRANTE') old

where old.numero_cliente = new.numero_cliente(+)

and new.numero_cliente is null;

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center