Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÖÐ charºÍvarcharÀàÐͼæÈݵÄÎÊÌâ

  Çë½Ì¸÷λ¸ßÊÖ°ïæ£¡£¡
  ÔÚoracleÊý¾Ý¿âÖУ¬°ÑÒ»¸ö¿âÖбíµÄÄÚÈݵºµ½ÁíÒ»¿âµÄ±íÖУ¨Á½¸ö±íµÄ±íÃûÏàͬ£¬ÀïÃæµÄ×ֶζ¼Ò»Ñù£©£¬µ«ÊÇ×Ö¶ÎÀàÐͲ»Ïàͬ£¬Ò»¸öÊÇcharÀàÐÍ£¨³¤¶È10£©¡¢ÁíÒ»¸öÊÇvarcharÀàÐÍ£¨³¤¶È10£©¡£¾Ù¸öÀý×Ó˵һÏ£¬Èç¡®abc¡¯ÔÚcharÀàÐÍÖбíʾΪ¡®abc      ¡¯ÈçºÎÄÜʵÏÖÔÚ½« ¡®abc      ¡¯×ª»¯ÎªvarcharÀàÐÍʱ°Ñ¿Õ¸ñÈ¥µô°¡£¡

ÔÚµ¼Êý¾ÝµÄͬʱ»¹´¦ÀíÊý¾Ý,ÕæÃ»¸ã¹ý

Èç¹û¿ÉÒÔ²Ù×÷µÄ»°,¹Ø×¢....

selectµÄʱºòÔö¼Ótrimº¯Êý°¡

ÒýÓÃ
selectµÄʱºòÔö¼Ótrimº¯Êý°¡

2Â¥Õý½â

дsqlÓï¾äʱ£¬ÔÚҪȥ¿Õ¸ñµÄ×ֶκóÃæ¼Ótrim¾Í¿ÉÒÔÁË¡£


¹þ¹þ£¬Ð»Ð»¸÷룬µ«ÊÇÎÒµÄSqlÓï¾äÊÇ  select *  from table where  .....  Õâ¸öʱºò±íÖеÄ×Ö¶ÎÔõôÄܼÓÉÏtrimÄØ£¿ÎÒ²»¿ÉÄܰѱíÄÚµÄËùÓÐ×ֶζ¼ÄóöÀ´¼ÓÉÏtrimµÄ

Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨

»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol);

ÒýÓÃ
Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨

»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol);

лл£¬ÎÒÈ¥ÊÔÊÔ£¡


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ