Consultas muy grandes

[[RONPABLO]]

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