12,665
回編集
差分
ナビゲーションに移動
検索に移動
ページの作成:「==Oracle ゼロ埋め== [Oracle]{{category 書式}} *[http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/functions.html#92770 to_ch…」
==Oracle ゼロ埋め==
[Oracle]{{category 書式}}
*[http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/functions.html#92770 to_char]
*[http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/sql_elements.html#44268 書式]
SQL> select to_char(1, '0000000000') from dual;
TO_CHAR(1,'0000000000'
----------------------
0000000001
*SQL Server ゼロ埋め
[Oracle]{{category 書式}}
*[http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/functions.html#92770 to_char]
*[http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19201-02/sql_elements.html#44268 書式]
SQL> select to_char(1, '0000000000') from dual;
TO_CHAR(1,'0000000000'
----------------------
0000000001
*SQL Server ゼロ埋め
© 2006 矢木浩人
