Subject mon$sql_text
Author Bogdan Mihalache

Here is an example from the mon$sql_text field from mon$statement table

 

Select aa.mon$timestamp, aa.mon$sql_text, aa.mon$state, ab.mon$remote_address

    From  MON$STATEMENTS aa

    Left Join MON$ATTACHMENTS ab on aa.mon$attachment_id = ab.mon$attachment_id

    Where aa.mon$state <> ? 

 

That question mark represents an variable. My question is from witch table I can extract the value and the name of that variable? It is possible?

 

Thank you for your kind help!

 

Bogdan MIHALACHE