I need a SQL for the following: (Oracle 10g)
I have the following table:
Inside this table I have the following:
INSTANCE VARCHAR2(6 BYTE)
BROKER VARCHAR2(32 BYTE)
ENDPOINT VARCHAR2(32 BYTE)
SOURCETAMP VARCHAR2(20 BYTE)
DATA VARCHAR2(256 BYTE)
The column SOURCETAMP is like this: (from the first one to the latest one)
So I need to delete ALL rows from this table BEFORE the number 1312825636117
NOTE: these numbers are crescent.
What would be the best way to do it?