A wield thing in Oracle DB# Database - 数据库
g*l
1 楼
I tried to do such a query against USER_OBJECTS :
SELECT * FROM USER_OBJECTS WHERE CREATED='10/15/2002';
It shows no row selected, but I know there is an object in the view.
If I change the query to :
SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME='thename';
It will show:
OBJECT_NAME: thename
CREATED: 10/15/2002
And if I retrieve data from a user-defined table also based on the date, it is
fine. For example:
SELECT * FROM my_table WHERE enroll_date='10/15/2002';
the type of ENROLL_DATE is DATE too
SELECT * FROM USER_OBJECTS WHERE CREATED='10/15/2002';
It shows no row selected, but I know there is an object in the view.
If I change the query to :
SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME='thename';
It will show:
OBJECT_NAME: thename
CREATED: 10/15/2002
And if I retrieve data from a user-defined table also based on the date, it is
fine. For example:
SELECT * FROM my_table WHERE enroll_date='10/15/2002';
the type of ENROLL_DATE is DATE too
