1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SQL> WITH ods_zy5l AS
2 (SELECT TO_DATE ('2008-01-05', 'yyyy-mm-dd') zy5l_datale
3 FROM DUAL
4 UNION ALL
5 SELECT TO_DATE ('2007-01-05', 'yyyy-mm-dd')
6 FROM DUAL
7 UNION ALL
8 SELECT TO_DATE ('2006-01-05', 'yyyy-mm-dd')
9 FROM DUAL
10 UNION ALL
11 SELECT TO_DATE ('2005-01-05', 'yyyy-mm-dd')
12 FROM DUAL)
13 SELECT DISTINCT TO_CHAR (ods.zy5l_datale, 'YYYY')
14 FROM ods_zy5l ods
15 WHERE (1 = 1) AND (TO_CHAR (ods.zy5l_datale, 'YYYY') = '2007');
TO_C
----
2007
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL> |
Partager