does anybody know how can i translate the following sybase/SQL command to oracle ?
select XTIME,' | ',MESSAGE from EXCEPTION_ALERTS
where
XTIME >= dateadd (mi,-31,getdate())
and
COMPONENT_TYPE != 0
and
MESSAGE not like '%GCS%Condition=%'
thanks for any help
regards
philmalmaison
sybase to oracle
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France