|
| |
| 15. 7. 24. TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') |
|
|
|
SQL>
SQL> SELECT owner, object_name, object_type, TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') last_ddl_time
2 FROM dba_objects
3 where rownum<50;
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
OBJECT_TYPE LAST_DDL_TIME
------------------- -----------------
SYS
ICOL$
TABLE 07-feb-2006 22:38
SYS
I_USER1
INDEX 07-feb-2006 22:10
SYS
CON$
TABLE 07-feb-2006 22:38
SYS
UNDO$
TABLE 07-feb-2006 22:10
SYS
C_COBJ#
CLUSTER 07-feb-2006 22:10
SYS
I_OBJ#
INDEX 07-feb-2006 22:10
SYS
PROXY_ROLE_DATA$
TABLE 07-feb-2006 22:10
SYS
I_IND1
INDEX 07-feb-2006 22:10
SYS
I_CDEF2
INDEX 07-feb-2006 22:10
SYS
I_PROXY_ROLE_DATA$_1
INDEX 07-feb-2006 22:10
SYS
FILE$
TABLE 07-feb-2006 22:10
SYS
UET$
TABLE 07-feb-2006 22:10
SYS
I_FILE#_BLOCK#
INDEX 07-feb-2006 22:10
SYS
I_FILE1
INDEX 07-feb-2006 22:10
SYS
I_CON1
INDEX 07-feb-2006 22:10
SYS
I_OBJ3
INDEX 07-feb-2006 22:10
SYS
I_TS#
INDEX 07-feb-2006 22:10
SYS
I_CDEF4
INDEX 07-feb-2006 22:10
SYS
IND$
TABLE 07-feb-2006 22:38
SYS
SEG$
TABLE 07-feb-2006 22:10
SYS
C_TS#
CLUSTER 07-feb-2006 22:10
SYS
I_FILE2
INDEX 07-feb-2006 22:10
SYS
COL$
TABLE 07-feb-2006 22:38
SYS
I_TS1
INDEX 07-feb-2006 22:10
SYS
I_UNDO2
INDEX 07-feb-2006 22:10
SYS
CLU$
TABLE 07-feb-2006 22:10
SYS
PROXY_DATA$
TABLE 07-feb-2006 22:10
SYS
I_PROXY_DATA$
INDEX 07-feb-2006 22:10
SYS
I_OBJ1
INDEX 07-feb-2006 22:10
SYS
I_COL2
INDEX 07-feb-2006 22:10
SYS
I_OBJ2
INDEX 07-feb-2006 22:10
SYS
I_CCOL1
INDEX 07-feb-2006 22:10
SYS
TS$
TABLE 07-feb-2006 22:38
SYS
C_FILE#_BLOCK#
CLUSTER 07-feb-2006 22:10
SYS
C_USER#
CLUSTER 07-feb-2006 22:10
SYS
I_UNDO1
INDEX 07-feb-2006 22:10
SYS
BOOTSTRAP$
TABLE 07-feb-2006 22:10
SYS
FET$
TABLE 07-feb-2006 22:10
SYS
I_TAB1
INDEX 07-feb-2006 22:10
SYS
CCOL$
TABLE 07-feb-2006 22:38
SYS
USER$
TABLE 07-feb-2006 22:52
SYS
I_CON2
INDEX 07-feb-2006 22:10
SYS
I_COBJ#
INDEX 07-feb-2006 22:10
SYS
OBJ$
TABLE 07-feb-2006 22:52
SYS
I_COL3
INDEX 07-feb-2006 22:10
SYS
C_OBJ#
CLUSTER 07-feb-2006 22:10
SYS
TAB$
TABLE 07-feb-2006 22:38
SYS
CDEF$
TABLE 07-feb-2006 22:38
SYS
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
OBJECT_TYPE LAST_DDL_TIME
------------------- -----------------
I_CDEF1
INDEX 07-feb-2006 22:10
49 rows selected.
SQL>
|
|
| 15. 7. TO_CHAR | | 15. 7. 1. | Format Parameters | | | | 15. 7. 2. | TO_CHAR(x [, format]) converts x to a string. | | | | 15. 7. 3. | TO_CHAR() will return a string of pound characters (#) if you try and format a number that contains too many digits for the format you have provided. | | | | 15. 7. 4. | Use TO_CHAR() to convert columns containing numbers to strings. | | | | 15. 7. 5. | TO_CHAR(12345.67, '99,999.99') (1) | | | | 15. 7. 6. | TO_CHAR(12345.67, '99999.99') (2) | | | | 15. 7. 7. | TO_CHAR(-12345.67, '99,999.99') (3) | | | | 15. 7. 8. | TO_CHAR(12345.67, '099,999.99') (4) | | | | 15. 7. 9. | TO_CHAR(12345.67, '99,999.9900') | | | | 15. 7. 10. | TO_CHAR(12345.67, '$99,999.99') | | | | 15. 7. 11. | TO_CHAR(0.67, 'B9.99') | | | | 15. 7. 12. | TO_CHAR(12345.67, 'C99,999.99') | | | | 15. 7. 13. | TO_CHAR(12345.67, '99999D99') | | | | 15. 7. 14. | TO_CHAR(12345.67, '99999.99EEEE') | | | | 15. 7. 15. | TO_CHAR(0012345.6700, 'FM99999.99') | | | | 15. 7. 16. | TO_CHAR(12345.67, '99999G99') | | | | 15. 7. 17. | TO_CHAR(12345.67, 'L99,999.99') | | | | 15. 7. 18. | TO_CHAR(-12345.67, '99,999.99MI') | | | | 15. 7. 19. | TO_CHAR(-12345.67, '99,999.99PR') | | | | 15. 7. 20. | TO_CHAR(2007, 'RN') | | | | 15. 7. 21. | TO_CHAR(12345.67, 'TM') | | | | 15. 7. 22. | TO_CHAR(12345.67, 'U99,999.99') | | | | 15. 7. 23. | TO_CHAR(12345.67, '99999V99') | | | | 15. 7. 24. | TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') | | | | 15. 7. 25. | to_char(sysdate,'hh24:mi:ss') as time | | | | 15. 7. 26. | to_char(to_date('01/01/2006','dd/mm/yyyy'),is on Day') as new_year_2006 | | | | 15. 7. 27. | to_char(sysdate, 'Day', 'nls_date_language=Dutch') | | | | 15. 7. 28. | to_char(sysdate,'DAY dy Dy') | | | | 15. 7. 29. | to_char(sysdate,'MONTH mon') as month | | | | 15. 7. 30. | to_char(bdate,'fmMonth ddth, yyyy') | | | | 15. 7. 31. | use to_char more than once to create long date format | | |
|