用Date字段作为where条件查询oracle数据库

select * from teacher_resource tr where tr.start_date = to_date('2012/07/23','yyyy/mm/dd')
select cola,to_char(rq,'yyyy-mm-dd') from yb3 where rq=sysdate

oracle查询默认表空间:
/* Formatted on 2011/12/19 15:57:48(QP5 v5.185.11230.41888) */
SELECT PROPERTY_VALUE
  FROM database_properties
 WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE'
修改默认表空间:ALTER DATABASE DEFAULT TABLESPACE users;

 

转载于:https://my.oschina.net/zichen/blog/103994