There is no problem with the syntax itself even though your formulation is time sensitive, which means that tomorrow it won't return the ... ... <看更多>

I have a fairly large (10s of millions rows) Oracle 10g table with a date field in it, which in a number of queries is constrained to a ... ... <看更多>