Variables

[informer30]

Hi All,

I am new to oracle, please can someone tell me what the variables below are doing?

select t.date,
a.acc_id,
t.user_id,
a.curr,
t.amnt
from ods.user_acc t
where t.costcentre = '5432'
and t.acc_id = @variable('A) Enter Account ID')
and t.date >= @variable('B) Enter >= Start Date')
and t.date < @variable('C) Enter < End Date')

Many Thanks

 

[carp]

They are setting the values for your filter. This query will bring back the data that falls between a start and end date for a specified account.

 

[informer30]

Thanks, but how do those filters get populated? Do i change them on the query or they feed into something?

cheers

 

[LKBrwnDBA]

This query does not look like Oracle syntax, better try the T_SQL Forum.

.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb