Oracle鎻掑叆鍥炶溅鎹㈣绗

Posted by 楗洅 on 2009骞11鏈13鏃 , No comment
  1. SQL>create TABLE t(abc varchar2(100));
  2.  
  3. 琛ㄥ凡鍒涘缓銆
  4.  
  5. SQL>insert INTO t(abc) VALUES('abcdef'||chr(10)||chr(13)||'hjkml');
  6.  
  7. 宸插垱寤 1 琛屻
  8.  
  9. SQL>select * FROM t;
  10.  
  11. ABC
  12.  
  13. abcdef
  14.  
  15. hjkml

Tags : ,

Filed under : 鏁版嵁搴 | Trackback URI | Comments RSS