ORACLE ÐÐÁÐת»»Í¨Óô洢¹ý³Ì£¬ÒѾת»»µÄMSSQL°æ±¾
ÏÂÃæÊÇORACLEÐÐÁÐת»»Í¨Óô洢¹ý³Ì£º
1¡¢
Function Fun_Split_Str(p_Str Varchar2, p_Division Varchar2, p_Seq Int)
Return Varchar2 Is
v_First Int;
v_Last Int;
Begin
If p_Seq < 1 Then
Return Null;
End If;
If p_Seq = 1 Then
If Instr(p_Str, p_Division, 1, p_Seq) = 0 Then
Return p_Str;
Else
Return Substr(p_Str, 1, Instr(p_Str, p_Division, 1) - 1);
End If;
Else
v_First := Instr(p_Str, p_Division, 1, p_Seq - 1);
v_Last := Instr(p_Str, p_Division, 1, p_Seq);
If (v_Last = 0) Then
If (v_First > 0) Then
Return Substr(p_Str, v_First + 1);
Else
Return Null;
End If;
Else
Return Substr(p_Str, v_First + 1, v_Last - v_First - 1);
End If;
End If;
End Fun_Split_Str;
/*
*/
Procedure Pro_Rows_Column(p_Table In Varchar2,
p_Keep_Cols In Varchar2,
p_Pivot_Cols In Varcha
Ïà¹ØÎĵµ£º
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TE ......
Ò»¡¢Oracle Âß¼½á¹¹¼ò½é
oracleµÄÂß¼½á¹¹°üÀ¨±í¿Õ¼ä(tablespace)£¬¶Î(segment),Êý¾Ý¿é(data block)ÒÔ¼°Ä£Ê½¶ÔÏó(schema)¡£
oracle Êý¾Ý¿âÔÚÂß¼ÉÏÊÇÓɶà¸ö±í¼ä×é³ÉµÄ£¬±í¿Õ¼äÖд洢µÄ¶ÔÏó½Ð¶Î£¬±ÈÈçÊý¾Ý¶Î£¬Ë÷Òý¶Î£¬ºÍ»ØÍ˶Ρ£¶ÎÓÉÇø×é³É£¬ÇøÊÇ´ÅÅÌ·ÖÅäµÄ×îСµ¥Î»¡£ ......
EMP±íÖÐÔ±¹¤ÓëÀϰåµÄ¹ØÏµ
ÄÚÁ¬½Ó£º
ÄÚÁ¬½ÓÒ²½Ð×ÔÈ»Á¬½Ó£¬ËüÊÇ×éºÏÁ½¸ö±íµÄ³£Ó÷½·¨¡£×ÔÈ»Á¬½Ó½«Á½¸ö±íÖеÄÁнøÐбȽϣ¬½«Á½¸ö±íÖÐÂú×ãÁ¬½ÓÌõ¼þµÄÐÐ×éºÏÆðÀ´£¬×÷Ϊ½á¹û¡£×ÔÈ»Á¬½ÓÓÐÁ½ÖÖÐÎʽµÄÓï·¨¡£
select e1.ename,e1.mgr,e2.ename aa from emp e1,emp e2 where e1. ......
Ê×ÏÈ£¬ÐèÒªÖØÐÂÕûÀíÒ»ÏÂÏà¹Ø¸ÅÄoracleÊý¾Ý¿âÖк¯ÊýµÄ×÷Óã¬ÊÇÖ»Äܱ»±ðÈ˵÷Ó㬴洢¹ý³Ì¿ÉÒÔµ¥¶ÀÖ´ÐУ¬²¢ÇÒ¿ÉÒÔµ÷Óô洢¹ý³Ì£¬¶ø°üµÄ×÷Óðü¿ÉÒÔ½«ÈκγöÏÖÔÚ¿éÉùÃ÷µÄÓï¾ä ( ¹ý³Ì , º¯Êý , Óαê , Óαê , ÀàÐÍ , ±äÁ¿ ) ·ÅÓÚ°üÖÐ , Ï൱ÓÚÒ»¸öÈÝÆ÷ . ½«ÉùÃ÷Óï¾ä·ÅÈë°üÖеĺô¦ÊÇ : Óû§¿ÉÒÔ´ÓÆäË ......
oracleµÄlicenseºÍÕý°æÊ¹ÓÃÎÊÌâ
url:http://blog.csdn.net/outget1/archive/2009/10/15/4675028.aspx
2008-06-30 23:42
1, Õý°æOracle ²úÆ·ºÍµÁ°æµÄÇø±ð
Ö±±¼Ö÷Ì⣬ÕâÊÇÐí¶àÑз¢²»×¢ÒâµÄµØ·½¡£¶ÔÓÚÉÌÓ㨾ÍÊÇÄã²»ÊÇÔÚ¼ÒÀ×Ô¼ºÍ棩£¬ÑϸñÀ´Ëµ£¬¾ÍÊÇÒ»ÕÅÐí¿ÉÖ¤Ö½µÄÇø±ð¡£²»¹ÜÊÇʲôʱºò£¬ÏÂÔØµÄ°æ±¾¶¼¿ÉÒÔ½¨Á¢Êý¾Ý¿â²¢ ......