tal vez me pierdo en algo, pero lo que entiendo es que cuando trata de crear un query muy largo le da un erro?.... sí eso es lo que crees creo que debes buscar por otro lado, yo tengo que soportar de vez en cuando una tabla moustruosa que tiene muchos campos y sobre esa tabala acabo de hacer un query consultando todos sus campos.. miralo acá... y funciona:
Código SQL
[-]select first 1 anananananananana.IDANAMNESIS, anananananananana.IDANAMNESIS_TEXTO,
anananananananana.COMPARACION, anananananananana.FECHA_INGRESO,
anananananananana.FECHA_INGRESO_DATE, anananananananana.NOMBRES,
anananananananana.APELLIDOS, anananananananana.NOMBRE_PACIENTE,
anananananananana.FECHAN_DIA, anananananananana.FECHAN_MES, anananananananana.FECHAN_ANO,
anananananananana.DOCUMENTO_IDENTIDAD, anananananananana.SEXO,
anananananananana.EDAD, anananananananana.EDADMES,
anananananananana.DIRECCION_PACIENTE,
anananananananana.TELF_P, anananananananana.TELF_P_OTRO,
anananananananana.CELULAR_P, anananananananana.NOMBRE_RESPONS,
anananananananana.DIRECCION_RESPONSABLE, anananananananana.TELF_RESP,
anananananananana.TELF_OF_RESP, anananananananana.CELULAR_RESPONSABLE,
anananananananana.BEEPER_RESPONSABLE, anananananananana.COD_BEEPR_RESP,
anananananananana.E_MAIL_RESP, anananananananana.REFERIDO_POR,
anananananananana.TRAT_ODONT_PREV_SI_NO, anananananananana.TRAT_ODONT_PREV_CUALES,
anananananananana.PADC_ENFERM_SI_NO, anananananananana.PADC_ENFERM_CUALES,
anananananananana.RECIBE_ALGUN_MEDIC_SI, anananananananana.RECIBE_ALGUN_MEDIC_CUAL,
anananananananana.PROCED_QUIRUR_SI_NO, anananananananana.PROCED_QUIRUR_CUALES,
anananananananana.REACC_ALERGIC_SI_NO, anananananananana.REACC_ALERGIC_CUALES, anananananananana.ANTECEDENTES_MEDICOS,
anananananananana.ANTECEDENTES_ODONTOLO, anananananananana.OBSERVACIONES, anananananananana.CEDULA_NUMERO,
anananananananana.HIGIENEHORAL, anananananananana.FRECUENCICEPILLADO, anananananananana.USASEDADENTAL,
anananananananana.ENFERMEDAD, anananananananana.CARIES, anananananananana.RECIDIVA, anananananananana.AMALGAMA,
anananananananana.IONOMERO, anananananananana.NOMBREPADRE, anananananananana.TELEFONO_PADRE,
anananananananana.TELEFONOPADRE, anananananananana.NOMBRE_MADRE, anananananananana.TELEFONO_MADRE,
anananananananana.TELEFONOMADRE, anananananananana.NUMEROHERMANOS, anananananananana.RELACIONPADRES,
anananananananana.ENFERMEDADESHERE, anananananananana.ESTADOCIVIL, anananananananana.NIVELESCOLAR,
anananananananana.PESO, anananananananana.ALTURA, anananananananana.SALUDGENERAL, anananananananana.CARDIOP,
anananananananana.PRESION, anananananananana.DIABETES, anananananananana.HEPATITIS, anananananananana.FIEBREREUMATICA,
anananananananana.CONVULCIONES, anananananananana.AMIGDALITIS, anananananananana.ANEMIA, anananananananana.ASMA,
anananananananana.TRAUMAFACIAL, anananananananana.ENFERMEDADESE, anananananananana.HERPES, anananananananana.ALERGIA,
anananananananana.ESTATOMANDO, anananananananana.AESTADOH, anananananananana.AESTADOPORQUE, anananananananana.OTROS,
anananananananana.HPORQUE, anananananananana.ALG_MEDIC_CUALES, anananananananana.A_ESTADO_HOSPIT_MOTIVO,
anananananananana.TIPO_HISTORIA, anananananananana.HEMORRAGIAS, anananananananana.GASTRICOS,
anananananananana.FUMA, anananananananana.EMBARAZO, anananananananana.RADIOTERAPIA, anananananananana.FOTOGRAFIA,
anananananananana.ESTADOCIVILP, anananananananana.PROFESION, anananananananana.NOMBRE_PADRE,
anananananananana.TEL_REMITIDOPOR, anananananananana.ODONTOLOGO, anananananananana.TEL_ODONTOLOGO,
anananananananana.RECOMENDADOPOR, anananananananana.TEL_RECOMENDADOPOR, anananananananana.TRAUMATISMOS,
anananananananana.EMPRESA, anananananananana.TIPO_HISTORIA_ORTODONCIA, anananananananana.TIPO_HISTORIA_ORTOPEDIA,
anananananananana.TERMINOTRAT, anananananananana.DOCTOR, anananananananana.TIPO_PACIENTE,
anananananananana.ESTADO_TRATAMIENTO, anananananananana.RH, anananananananana.CELULAR,
anananananananana.BARRIO, anananananananana.TIPO_USUARIO, anananananananana.CODIGO_EPS,
anananananananana.CODIGO_CIUDAD, anananananananana.CODIGO_DEPARTAMENTO, anananananananana.CODIGO_ZONA,
anananananananana.APELLIDO_SEG, anananananananana.NOMBRE_SEG, anananananananana.ZONA_RECIDENCIAL,
anananananananana.SIDA_SI_NO, anananananananana.TELEFONOACROM, anananananananana.CIRUGIAS,
anananananananana.OBS1, anananananananana.OBS2, anananananananana.OBS3, anananananananana.OBS4,
anananananananana.OBS5, anananananananana.OBS6, anananananananana.OBS7, anananananananana.OBS8,
anananananananana.OBS9, anananananananana.OBS10, anananananananana.OBS11, anananananananana.OBS12,
anananananananana.OBS13, anananananananana.OBS14, anananananananana.OBS15,
anananananananana.CODIGO_EPS_LISTADO, anananananananana.FECHA_AUTORIZADA,
anananananananana.FECHA_INGRESO_REAL, anananananananana.PARENTESCO, anananananananana.NUMERO_AUTORIZACION,
anananananananana.FECHA_NUMERO_AUTORIZACION, anananananananana.HORA_INGRESO, anananananananana.EPS_TELEFONO,
anananananananana.EMERGENCIA, anananananananana.ACOMPANATE, anananananananana.ACOMPANATE_TEL,
anananananananana.PARENTESCO_RESPONSABLE, anananananananana.DOMICILIO, anananananananana.TITULAR,
anananananananana.NUMERO_TTITULAR, anananananananana.FECHA_FINAL, anananananananana.NRO_AFILIACION,
anananananananana.NIVEL_BENEFICIARIO, anananananananana.COD_DOCTOR, anananananananana.ACTIVO,
anananananananana.OBS_ANTESEDENTES, anananananananana.ATENDIDO_POR, anananananananana.CONVENIO,
anananananananana.NOTA_IMPORTANTE, anananananananana.MEDICO, anananananananana.LUGAR,
anananananananana.PROBLE_ESQUE_FACIALES_SN, anananananananana.PROBLE_ESQUE_FACIALES_OBS,
anananananananana.TRAUMA_DENTAL_SN, anananananananana.TRAUMA_DENTAL_OBS, anananananananana.MENARCA_SN,
anananananananana.MENARCA_OBS, anananananananana.MALARES, anananananananana.ASIMETRIAS_SN,
anananananananana.ASIMETRIAS_OBS, anananananananana.IMPORTANTE, anananananananana.DOCUMENTO_RESPONS,
anananananananana.ESTRATO, anananananananana.MOTIVO_DE_CONSULTA, anananananananana.TRAT_ODONT_PREV_CUALES_S,
anananananananana.PADC_ENFERM_CUALES_S, anananananananana.A_ESTADO_HOSPIT_MOTIVO_S,
anananananananana.RECIBE_ALGUN_MEDIC_CUAL_S, anananananananana.REACC_ALERGIC_CUALES_S,
anananananananana.CIRUGIAS_S, anananananananana.CEL_PADRE, anananananananana.CEL_MADRE,
anananananananana.ENFERMEDADESHERE_S, anananananananana.MEDICO_TEL, anananananananana.OCUPACION_PADRE,
anananananananana.OCUPACION_MADRE, anananananananana.TRATAMIENTO_ORTODONCIA_S,
anananananananana.TRATAMIENTO_ORTODONCIA, anananananananana.CIRUGIA_ORAL, anananananananana.CIRUGIA_ORAL_S,
anananananananana.FOTOTERAPIA, anananananananana.FOTOTERAPIA_OBS, anananananananana.REVISION_SISTEMAS,
anananananananana.ENFERMEDAD_TIROIDEA, anananananananana.ENFERMEDAD_TIROIDEA_SN, anananananananana.DISLIPIDEMIA,
anananananananana.DISLIPIDEMIA_SN, anananananananana.OVARIO_POLIQUISTICO,
anananananananana.OVARIO_POLIQUISTICO_SN, anananananananana.ENFERMEDAD_ACTUAL,
anananananananana.EDAD_PADRE, anananananananana.EDAD_MADRE, anananananananana.ACTIVIDAD_ECONOMICA,
anananananananana.ALTERACIONES_HEMATOLOGICAS, anananananananana.COMPLICACIONES_TTO,
anananananananana.TRASTORNO_EMOCIONAL, anananananananana.LUGAR_NACIMIENTO, anananananananana.CORONARIA,
anananananananana.CORONARIA_SN
from TANAMNESIS anananananananana