newbie
Im having a format problems Im hacking someone else's script
what does this do ?
I understand the varibles but I do not know what the "position" statement means
begin-progam
#define OCODE_COL 1
#define OPER_COL 10
begin-select
a.oper_id &oper
position (+1,1)
print...
Question: simple maybe ?
I would like too query data for the past 7 days using sysdate
where To_CHAR (Collect_dt 'MM/DD/YYYY' = To_CHAR(sysdate ? 'MM/DD/YYYY')
sysdate-7 returns only data for one day
Thanks
vehto
can any one help ? newbie
I have three table's two have text need.
select text_x from table_x
where ctl_date> '18-aug03'
and seq_num = '123'
union all
select text_y from table_y
where ctl_date> '18-aug03'
and seq_num = '123';
This works! and returns the text I need
now I need to incoporate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.