Return
-
Title
Query Builder - Copying the SQL statement and the value of 'last week'. -
Description
User has many SQL's on Query Builder. On SQL statement has where clause with 'last week' he wants to copy value of it.
On Toad v4.7.2 , it won't show value, however, Toad v 5.0.0.512 displays the value when hovering over the word 'last week' . User wants to copy the SQL and also with value of 'last week'.
Example:
select V_CH_CHANGE.BASTATUSDUEDATE
from MXOMART.V_CH_CHANGE V_CH_CHANGE
where (V_CH_CHANGE.BASTATUSDUEDATE =
'' /*Last week*/
)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.