I'm here to fire a barrage of questions once more.
I want to make a query basing in another query already made. I'd like to do so because the other query could vary and I wouldn't like to change the query everytime the other one change.
Like this:
CODE
with t as (UR_QUERY_DEPENDANT)
select * from (select rownum as Fila,LocalId,State,SenderId,ReceiverId,OriginalSenderId,StartDate,StartTime,Prot
ocolFileName,FileSize,Protocol
from t)
where Fila = 'TrkParameter(Fila)'
select * from (select rownum as Fila,LocalId,State,SenderId,ReceiverId,OriginalSenderId,StartDate,StartTime,Prot
ocolFileName,FileSize,Protocol
from t)
where Fila = 'TrkParameter(Fila)'
Also I'd like to know if I can do this: Select rownum as Fila,*
Regards
