1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
0
SVL_STATEMENTTEXT is the right place to get full query text. As you rightly noticed, when a single statement contains more than 200 characters, additional rows are created for that statement and a sequence number is assigned for each part. Sequence 0 is the first row, 1 is the second, and so on.
To get full query text from SVL_STATEMENTTEXT, you can use the below sample query
select LISTAGG(CASE WHEN LEN(RTRIM(text)) = 0 THEN text ELSE RTRIM(text) END, '') within group (order by sequence) AS query_statement
from SVL_STATEMENTTEXT where xid=<<your transaction's xid>>
respondido há um ano
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 meses
Wonderful! Thank you for the quick response!