oracleÖеÄ4¸öÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
1.ʹÓÃsysµÇ½,ÈçºÎ²é¿´ÄĸöÓû§ÏµĶÔÏóÕ¼ÓõĴÅÅÌ¿Õ¼ä×î´ó?
2.Ö´Ðвéѯʱ±¨´í:ORA-01652:ÎÞ·¨Í¨¹ý128(ÔÚ±í¿Õ¼äTEMPÖÐ)À©Õ¹temp¶Î£¬²»ÖªÊÇʲôÔÒò£¿
3.ÊäÈë:Ò»¸ö×Ö·û´®¡°35,36,380¡±
ÒªÇóÉú³É3ÐÐÊý¾Ý£¬ÈçÏ£º
35
36
380
ÓÃsqlÔõôд£¿
4.ʹÓÃselect * from dba_users; µÃµ½passwordֵȫΪ¿Õ£¬²»ÖªÔÒò?
°ï¶¥£¡³õѧÕߣ¡À´Ñ§Ï°µÄ£¡ºÇºÇ
3.
select substr(regexp_substr(',' || '35,36,380', ',([^,]+)', 1, level), 2) as "item"
from dual
connect by level <= length(regexp_replace('35,36,380', '[^,]', '')) + 1
SQL code:
4.
SQL> select password from dba_users;
PASSWORD
------------------------------
9CC0ECDD8721C8E3
C89E957D620BC4ED
3FB8EF9DB538647C
84B8CBCA4D477FA3
5AC67B98FA46369E
88A2B2C183431F00
B97545C4DD2ABE54
88D8364765FCE6AF
4AA37D1393FD7BB5
4C6D73C3E8B0F0DA
CE4A36B8E06CA59C
ORA-01652ÕâÖÖÎÊÌâÒ»°ãÓÐÁ½ÖÖÔÒò£ºÒ»ÊÇÁÙʱ±í¿Õ¼ä¿Õ¼ä̫С£¬¶þÊDz»ÄÜ×Ô¶¯À©Õ¹£»
3.
SQL code:
select replace('35,36,37',',',chr(10)) from dual
SQL code:
SQL> select
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......