Oracle鎻掑叆鍥炶溅鎹㈣绗

Posted by 楗洅 on 2009骞11鏈13鏃 , No comment

SQL>create TABLE t(abc varchar2(100));

 

琛ㄥ凡鍒涘缓銆

 

SQL>insert INTO t(abc) VALUES('abcdef'||chr(10)||chr(13)||'hjkml');

 

宸插垱寤 1 琛屻

 

SQL>select * FROM t;

 

ABC

 

abcdef

 

hjkml

Filed under : 鏁版嵁搴