oracle »ù´¡ ¿ØÖÆ»ú¹¹+¸³Öµ
--±äÁ¿¸³Öµ
declare
identity :=0;
a varchar2(59,0);
b varchar2(50):='abc';
a :='cba';
-- ¿ØÖÆÓï¾ä
----------------------------------
if a>b then
.........
end if;
------------------------------------
if a>b then
.....
else
.....
end if;
-----------------------------------
if a>b then
........
elsif c>b then
........
else
..........
end if;
-----------------------------------
case variable
when 'tt' then 'value1'
when 'mm' then 'value2'
when 'nn' then 'value3'
else value4
end;
--------------------------------------
while t<10000000 loop
........;
end loop;
--------------------------------------
for 1_counter in 1-10
loop
statements;
end loop;
---------------------------------------
for 1_counter in reverse 1..10
loop
statements;
end loop;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖÆ²úÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......
-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
SQL> create table tt2 as select * from employee;
Table created.
SQL> drop table tt2;
Table dropped.
SQL> select * from tt2;
select * from tt2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table tt2 to before drop;
Flashback comp ......
oracle±í¿Õ¼ä²Ù×÷Ïê½â
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒ ......
OracleÊý¾Ýµ¼³öºÜ¼òµ¥£¬µ«ÎªÁËÌá¸ßËÙ¶È£¬ÎÒÒ»°ã²»Ö±½Óµ¼³ö³ÉDBF£¬¶øÊÇÏȵ¼³ö³ÉCSV¸ñʽµÄÎı¾Îļþ¡£
½ñÌì¾ÍÓöµ½Ò»¸öÎÊÌ⣬µ¼³öµÄcsvÔÚת»»³Édbfʱ³öÏÖÁ˺ܶà¿ÕÐС£¾¹ý²éÕÒÎÊÌ⣬·¢ÏÖÊÇ×Ö¶ÎÖк¬Óл»Ðзûµ¼Ö¡£
ʹÓÃ
select Replace(zsyj,chr(13)||chr(10),'') as SXPD from TableName
½â¾öÎÊÌâ¡£ ......