oracleÖеIJ»¿É¼û×Ö·û
½ñÌì×öͳ¼ÆµÄʱºò·¢ÏÖÒ»¸öÊý¾Ý±íÃæÉÏ¿´À´ÊÇ‘920 ’µ«È¥¿Õ¸ñÎÞÂÒÈçºÎ¶¼È¥²»µô£¬×îºó·¢ÏÖÊDz»¿É¼û×Ö·û¡£¡£¡£
ÓÚÊÇÔÚÍøÉÏËѵ½Ò»ÆªÎÄÕ£¬ÈçºÎÀ´ÅжÏÕâ¸ö²»¿É¼û×Ö·ûµÄÎÊÌâ~
°´ÏÂÃæµÄ·½·¨Åжϳö²»¿É¼û×Ö·ûµÄascIIÂëÊÇ10£¬ÓÚÊÇÓÃrtrim('Ô×Ö·û','chr(10)')À´È¥µôÕâ¸ö²»¿É¼û×Ö·û¡£
½ñÌìÓöµ½Ò»Ôò°¸Àý£¬ÎÊÌâÊÇÊý¾Ý¿âÖп´À´ÍêÈ«ÏàͬµÄ×Ö¶ÎÈ´´æÔÚ³¤¶È²îÒì¡£
¡¡¡¡Í¨¹ýlengthbÒÔ¼°dump£¬ÎÒÃÇ¿ÉÒÔÖªµÀÎÊÌâËùÔÚ£º
SQL> select trim(log.sname),dump(log.sname),lengthb(log.sname)
¡¡¡¡2 from st.LIMPORT_LOG log
¡¡¡¡3 where log.dfee > date '2008-06-22'
¡¡¡¡4 and log.dfee < date '2008-06-23'
¡¡¡¡5 and log.sspname like '263%'
¡¡¡¡6 group by log.sname,dump(log.sname);
¡¡¡¡TRIM(LOG.SNAME) DUMP(LOG.SNAME) LENGTHB(LOG.SNAME)
¡¡¡¡------------------- ----------- ----------------------------------------------
¡¡¡¡263ÍøÂçͨÐÅ Typ=1 Len=15: 50,54,51,205,248,194,231,205,168,208,197,0,0,0,0 15
¡¡¡¡263ÍøÂçͨÐÅ Typ=1 Len=11: 50,54,51,205,248,194,231,205,168,208,197 11
¡¡¡¡Ê¹ÓÃDUMPº¯ÊýÎÒÃÇ·¢ÏÖ£¬ÔÚÓÐÎÊÌâµÄÊý¾ÝÖУ¬Êý¾Ýĩβ´æÔÚ¼¸¸ö×Ö·û0,0,0,0£¬Ò²¾ÍÊǶà³öÁ˼¸¸ö×Ö·û¡£
¡¡¡¡ÕýÊÇÕâ¶à³öµÄ¼¸¸ö×Ö·ûµ¼ÖÂÁË´æ´¢Òì³£¡£
¡¡¡¡ÄÇôÕâ¸ö0´ú±íʲô×Ö·ûÄØ?ÔÚASCII±àÂë±íÀïÎÒÃÇ¿ÉÒÔ¿´µ½Õâ¶ÔÓ¦ÁËÒ»¸ö²»¿É¼û×Ö·û£¬ÕâÊÇÊý¾ÝÈë¿âʱµÄÒì³£µ¼Öµģº
¡¡¡¡-The End-
Ïà¹ØÎĵµ£º
×ܽáÁËÒ»ÏÂɾ³ýÖظ´¼Ç¼µÄ·½·¨£¬ÒÔ¼°Ã¿ÖÖ·½·¨µÄÓÅȱµã¡£
¼ÙÉè±íÃûΪTbl£¬±íÖÐÓÐÈýÁÐcol1£¬col2£¬col3£¬ÆäÖÐcol1£¬col2ÊÇÖ÷¼ü£¬²¢ÇÒ£¬col1£¬col2ÉϼÓÁËË÷Òý¡£
1¡¢Í¨¹ý´´½¨ÁÙʱ±í
¿ÉÒÔ°ÑÊý¾ÝÏȵ¼Èëµ½Ò»¸öÁÙʱ±íÖУ¬È»ºóɾ³ýÔ±íµÄÊý¾Ý£¬ÔÙ°ÑÊý¾Ýµ¼»ØÔ±í£¬SQLÓï¾äÈçÏ£º
creat table tbl_tmp (select distinct* from tb ......
OracleË÷Òý·ÖÇøÔÓ̸
<> OracleÊý¾Ý¿âÖУ¬ÓÐÁ½ÖÖÀàÐ͵ķÖÇøË÷Òý£¬È«¾ÖË÷ÒýºÍ±¾µØË÷Òý£¬ÆäÖб¾µØË÷ÒýÓÖ¿ÉÒÔ·ÖΪ±¾µØǰ׺Ë÷ÒýºÍ±¾µØ·Çǰ׺Ë÷Òý¡£ÏÂÃæ¾Í·Ö±ð¿´¿´Ã¿ÖÖÀàÐ͵ÄË÷Òý¸÷×ÔµÄÌص㡣
È«¾ÖË÷ÒýÒÔÕû¸ö±íµÄÊý¾ÝΪ¶ÔÏó½¨Á¢Ë÷Òý£¬Ë÷Òý·ÖÇøÖеÄË÷ÒýÌõÄ¿¼È¿ÉÄÜÊÇ»ùÓÚÏàͬµÄ¼üÖµµ«ÊÇÀ´×Ô²»Í¬µÄ·ÖÇø£¬Ò²¿ÉÄÜÊǶà¸ö²»Í¬¼üÖ ......
Òì³£
Ô¤¶¨ÒåÒì³£
oracleΪ³£¼û´íÎóÔ¤¶¨Òå
ÔÚDBMS_STANDARD³ÌÐò°üÖÐÌṩÁËÕâЩ¶¨Òå
²»ÐèÒªÏÔʾÉùÃ÷
declare
sex student.stu_sex%type;
begin
select stu_sex into sex from student;
dbms_output.put_line('sex:'||sex);
exception
&nbs ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO &nbs ......