Purposes, I partition name was built according to the date, then I will delete partitions, such as 7 days ago so I have to check out before 7 days of partition
Complete code, the outermost layer on the where condition is an error, without the where condition is not an error,




The subquery results:


First of all, without any conditions, ALL_TAB_PARTITIONS list as a result, some partition name not legitimate, not really date type,
I, however, by the subquery first filtered out,
So, undoubtedly, the outermost layer of the where condition is on the basis of the subquery judgment? Or a full table judgment?

CodePudding user response:

What's the trick, you are the partition name to_date, conversion fails, nature is an error,

CodePudding user response:

If you do you have this fields in data cannot be converted to date

CodePudding user response:

Need to see all the partition_name

CodePudding user response:

Partition the field data has a problem, use to_date error

CodePudding user response:

reference 1st floor wmxcn2000 response:

what's the trick, you put the name of partition to_date, conversion failure, error, naturally

Thank you for your reply, but why conversion failure? Do you see my query results are meet the requirements of the time value,

CodePudding user response:

refer to the second floor baidu_36457652 response:

if you do you have this fields in data cannot be converted to date

Thank you, all values do have illegal, cannot be converted to date, but I am the son of the results of the query (figure 3) are legitimate date format.

CodePudding user response:

reference jdsnhan reply: 3/f

need to see all the partition_name

Thank you, why do you want to see all of the values? I don't by the subquery limits?

CodePudding user response:

The original poster is which version of the library?

CodePudding user response:

refer to the eighth floor wmxcn2000 response:

the original poster is which version of the library?

11.2.0.4