Consultas MYSQL
estimados su apoyo Al realizar la consulta :
select * from sys.`x$statement_analysis`
Resultado:
'SELECT `iopmessage0_` . `MESSAGE_ID` AS `MESSAGE_1_1_` , `iopmessage0_` . `ATTACHMENT_URL` AS `ATTACHME2_1_` , `iopmessage0_` . `CERT_TYPE` AS `CERT_TYP3_1_` , `iopmessage0_` . `DESTINATION_CODE` AS `DESTINAT4_1_` , `iopmessage0_` . `DESTINATION_COUNTRY_CODE` AS `DESTINAT5_1_` , `iopmessage0_` . `DTIOP_MSG_SENT` AS `DTIOP_MS6_1_` , `iopmessage0_` . `DOCUMENT_ID` AS `DOCUMENT7_1_` , `iopmessage0_` . `FILE_NAME` AS `FILE_NAM8_1_` , `iopmessage0_` . `INTERFACE_MSG_SENT` AS `INTERFAC9_1_` , `iopmessage0_` . `IOP_RETRY_COUNT` AS `IOP_RET10_1_` , `iopmessage0_` . `MSG_TYPE` AS `MSG_TYP11_1_` , `iopmessage0_` . `NUMBER_OF_TRANSACTIONS` AS `NUMBER_12_1_` , `iopmessage0_` . `ORIGINAL_TRANSACTION_ID` AS `ORIGINA13_1_` , `iopmessage0_` . `REF_NO` AS `REF_NO14_1_` , `iopmessage0_` . `RESPONSE_REF_NO` AS `RESPONS15_1_` , `iopmessage0_` . `RETRY_COUNT` AS `RETRY_C16_1_` , `iopmessage0_` . `SEW_MSG_SENT` AS `SEW_MSG17_1_` , `iopmessage0_` . `SEW_RETRY_COUNT` AS `SEW_RET18_1_` ,
Nota: el resultado esta incompleto como se puede observar lĂneas arriba.
como puedo o se puede visualizar completo la consulta; he probado varios aplicativos y me dan mismo resultado incompleto.
Subject
Views
Written By
Posted
Consultas MYSQL
552
October 30, 2018 09:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.