1、创建测试表,
create table test_second(id varchar2(20),value date);
2、插入测试数据,部分值含回车换行符;
insert into test_second values(1, sysdate);
insert into test_second values(2, sysdate-12/19999);
insert into test_second values(3, sysdate-122/19999);
insert into test_second values(4, sysdate-1000/19999);
commit;
3、查询表中全量数据;select t.*, rowid from test_second t;
4、编写语句,只查询时分秒;
select t.*, to_char(value, 'hh24miss') sec from test_second t;