t********1 发帖数: 799 | 1 I want to select the file in which the date is a part of name, for example "
rain_08feb11", from "filename" column everyday, now i use
where filename like '%_0_&sysdate';
it doesn't work, &sysdate can not be converted 08feb11, Then how can I do
this?
Thanks. | w*****e 发帖数: 806 | 2 macro processor doesn't resolve macros inside single quotation makrs...
please use double quotation marks.
'%_0_&sysdate'----------"%_0_&sysdate" |
|