ת:ORACLE ¶à±í¹ØÁª UPDATE Óï¾ä
ת:ORACLE
¶à±í¹ØÁª UPDATE Óï¾ä
ÔÌû£ºhttp://www.cnblogs.com/miley/archive/2010/04/15/1712617.html
ΪÁË
·½±ãÆð¼û
,½¨Á¢ÁËÒÔϼòµ¥Ä£ÐÍ
,ºÍ¹¹ÔìÁ˲¿·Ö²âÊÔÊý¾Ý
:
ÔÚij¸öÒµ
ÎñÊÜÀí×Óϵͳ
BSSÖУ¬
--¿Í»§×Ê
Áϱí
create table customers
(
customer_id number(8) not null, -- ¿Í»§±êʾ
city_name varchar2(10) not null, -- ËùÔÚ³ÇÊÐ
customer_type char(2) not null, -- ¿Í»§ÀàÐÍ
...
)
create unique index PK_customers on customers
(customer_id)
ÓÉÓÚijЩ
ÔÒò£¬¿Í»§ËùÔÚ³ÇÊÐÕâ¸öÐÅÏ¢²¢²»Ê²Ã´×¼È·£¬µ«ÊÇÔÚ
¿Í»§·þÎñ
²¿µÄ
CRM×ÓϵͳÖУ¬Í¨¹ýÖ÷¶¯·þÎñ»ñÈ¡Á˲¿·Ö
¿Í»§
20%µÄËùÔÚ
³ÇÊеÈ×¼
È·ÐÅÏ¢£¬ÓÚÊÇÄ㽫¸Ã²¿·ÖÐÅÏ¢ÌáÈ¡ÖÁÒ»ÕÅÁÙʱ±íÖУº
create table tmp_cust_city
(
customer_id number(8) not null,
citye_name varchar2(10) not null£¬
customer_type char(2) not null
)
1) ×î¼òµ¥µÄ
ÐÎʽ
--¾È·
ÈÏ
customers±íÖÐËùÓÐ
customer_idСÓÚ
1000¾ùΪ
'±±¾©
'
--1000ÒÔÄڵľùÊǹ«Ë¾×ßÏòÈ«¹ú֮ǰµÄ±¾³ÇÊеÄÀϿͻ§
:)
update customers
set city_name='±±¾©
'
where customer_id<1000
2) Á½±í
(¶à±í
)¹ØÁª
update -- ½öÔÚ
where×Ö¾äÖеÄÁ¬½Ó
--Õâ´Î
ÌáÈ¡µÄÊý¾Ý¶¼ÊÇ
VIP£¬ÇÒ°üÀ¨ÐÂÔöµÄ
,ËùÒÔ˳±ã¸üпͻ§Àà±ð
update customers a -- ʹÓñðÃû
set customer_type='01' --01 Ϊ
vip£¬
00ΪÆÕͨ
where exists (select 1
from tmp_cust_city b
&
Ïà¹ØÎĵµ£º
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§
http://ip:5560/isq ......
http://hi.baidu.com/lu_xinzhong/blog/item/4ff92b1725dec505c83d6d09.html
»Ø¹ö±í¿Õ¼ä´óС
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTE ......