oracle±£´æÐ¡ÊýµãǰΪ"0"µÄÎÊÌâ
ÔÚ´¦ÀíÊý¾Ýʱ·¢ÏÖÒ»¸öÎÊÌ⣬Oracle¶ÔÓÚСÓÚ1µÄСÊý£¬Ð¡ÊýµãÇ°ÃæµÄ0ÊDz»ÏÔʾµÄ¡£
SQL> create table t1_number (num number);
Table created
SQL> insert into t1_number values(0.3268);
1 row inserted
SQL> insert into t1_number values(0.57965686);
1 row inserted
SQL> insert into t1_number values(52345234.5686);
1 row inserted
SQL> insert into t1_number values(4.552686);
1 row inserted
SQL> commit;
Commit complete
SQL> column num format 99999999999.9999999999999
SQL> select * from t1_number;
NUM
--------------------------
.3268000000000
.5796568600000
52345234.5686000000000
4.5526860000000
ʹÓÃPL/SQL DEV¹¤¾ß²é¿´Ê±ÊÇÓÐÇ°ÃæµÄ0µÄ
ͨ¹ýcolumn num format 000000000000.99999999999ÉèÖÃÒ²¿ÉÒÔÏÔÊ¾Ç°ÃæµÄ0
µ«ÊÇÕâЩ¶¼Ö»ÊÇÏÔʾµÄ½á¹û£¬¶ø²»ÊÇÊý¾Ý¿â±£´æ½á¹û
SQL> column num format 00000000000.9999999999999
SQL> select * from t1_number;
NUM
--------------------------
00000000000.3268000000000
00000000000.5796568600000
00052345234.5686000000000
00000000004.5526860000000
00000000005.2920000000000
SQL> select substr(num,1,1) from t1_number;
SU
--
.
.
5
4
5
¿ÉÒÔ¿´µ½£¬ÎÞÂÛÇ°Ãæ³öÏÖ¶àÉÙλ£¬Í¨¹ýsubstrº¯Êý»ñÈ¡µÄµÚһλÈÎÈ»ÊÇ'.'
ÎÞÂÛÔõôת»»£¬Ö»Òª×îÖÕÊä³ö½á¹ûÊÇÊýÖµÐ͵ģ¬Ð¡Êýµã
Ïà¹ØÎĵµ£º
oracleÊý¾Ý¿âͨ¹ý¿ØÖÆÎļþ±£³ÖÊý¾Ý¿âµÄÍêÕûÐÔ£¬Ò»µ©¿ØÖÆÎļþ±»ÆÆ»µÊý¾Ý¿â½«ÎÞ·¨Æô¶¯£¬Òò´Ë½¨Òé²ÉÓöà·¿ØÖÆÎļþ»òÕß±¸·Ý¿ØÖÆÎļþµÄ·½·¨¡£
¿ØÖÆÎļþÊÇÊý¾Ý¿â½¨Á¢µÄʱºò×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÎļþ£¬Ö»ÄÜͨ¹ýʵÀý½øÐÐÐ޸ģ¬Èç¹ûÊÖ¶¯Ð޸ĵϰ»áÔì³É¿ØÖÆÎļþÓëÎïÀíÐÅÏ¢²»·ûºÏ£¬´Ó¶øµ¼ÖÂÊý¾Ý¿â²»ÄÜÕý³£¹¤×÷¡£
oracleÊý¾Ý¿âͨ ......
oracle¼¸¸ö³£ÓÃµÄ¼à¿ØÊÓͼ
oracle¼¸¸ö³£ÓÃµÄ¼à¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......
²é¿´±íµÄ´óС£»
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
Ê×ÏÈ
create table TEST_1228 as select * from user_tables;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
i ......
Èç¹ûÔÚÊÂÎñÖÐÖ´ÐÐÁËÒ»Ìõ²»Âú×ãÌõ¼þµÄupdateÓï¾ä£¬ÔòÖ´ÐÐÈ«±íɨÃ裬°ÑÐм¶ËøÉÏÉýΪ±í¼¶Ëø£¬¶à¸öÕâÑùµÄÊÂÎñÖ´Ðк󣬾ͺÜÈÝÒײúÉúËÀËø¡£
ËÀËøÒ»°ãÊÇÒò×¾ÁÓµÄÊÂÎñÉè¼Æ¶ø²úÉú insert, update, delete
1.°´Óû§Óëϵͳ»®·Ö£¬¿ÉÒÔ·ÖΪ×Ô¶¯ËøÓëÏÔÊ¾Ëø
×Ô¶¯Ëø£ºµ±½øÐÐÒ»ÏîÊý¾Ý¿â²Ù×÷ʱ£¬È±Ê¡Çé¿öÏ£¬ÏµÍ³×Ô¶¯Îª´ËÊý¾Ý¿â²Ù×÷»ñµÃËùÓ ......
lob×ֶβ»ÄÜ×ögroup by£¬¶øunionÖÐÐèҪʹÓÃgroup by¹ýÂ˵ôÖØ¸´¼Í¼£¬ËùÒÔ²»ÐÐ ¡£ ÓÃunion all¾Í¿ÉÒÔÁË¡£
Áí£ºunion ºÍ union allÇø±ð£º
UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖØ¸´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖØ¸´µÄ¼Ç¼ÔÙ·µ» ......