100·ÖÇó¸öSQLµÄÓï·¨¡£¡£ - Oracle / ¿ª·¢
ÏÖÔÚ Óиö ±í ×Ö¶ÎΪ A1,A2,A3,A4,A5
ÎÒ¶¨ÒåÁ˼¸¸ö±äÁ¿ ÀýÈ磺
v_B1 NUMBER;
v_B2 NUMBER;
v_B3 NUMBER;
ÎÒÒª²é³öÒ»¸ö½á¹û¼¯£»
Õâ¸ö½á¹û¼¯ºÏÒªÇó£º
select SUM(A1)/COUNT(DISTINCT A2) into v_B1 from t_daylog_agentoprinfo;
select SUM(A3)/SUM(A4) into v_B2 from t_daylog_agentoprinfo where a5='2222'
select SUM(A3) into v_B3 from t_daylog_agentoprinfo WHERE a5='234';
Õâ3¸ö±äÁ¿·Ö±ðͨ¹ýÕâ¸ö±íµÄ²»Í¬¼ÆË㷽ʽ¸³Öµ£¡£¡£¡£¡ ÈçºÎ½«Õâ3¸ö±äÁ¿ Æ´½ÓÆðÀ´ ²¢ÇÒ²éѯ³öÒ»¸ö½á¹û¼¯ºÏ¡£¡£ÕâÑùµÄÓï·¨Ôõôд£¿£¿£¿£¿£¿£¿
Çë¸÷λ°ïÏ¡£
²»Ì«Ã÷°×˵µÄʲôÒâ˼
»¹ÓÐÆäËû·½·¨Ã»¡£¡£²»Ð´³ÉÒ»¸öÓï¾ä¡£¡£¡£
ÒòΪ¼ÆËã±È½Ï¸´ÔÓ¡£¡£ÕâÀïÊǾٸöÀý×Ó ¡£¡£ËùÒÔÏȼÆËã±£´æµ½±äÁ¿ ÔÚ ²éѯ½á¹û¼¯ºÏ£¨ÕâÑùÓï·¨Ôõôд£©¡£¡£Â¥É쵀 ÊÇÖ±½Óд£¬ÎÒÏëÕâÑù²»Ì«ºÃ°É¡£¡£¡£
v_sSQL := ' SELECT ''' || v_TmpStr||'''|| TO_CHAR(SYSDATE,''YYMMDDHH24MISS'') || '''|| v_Othid ||''' FILENAME, '
|| ''''||v_TmpStr || ''' ShortName, '
|| ''''||TO_CHAR(v_BeginDate,'YYYYMMDDHH24MISS') ||''' BeginDate, '
|| ''''||TO_CHAR(v_EndDate,'YYYYMMDDHH24MISS') ||''' EndDate, '
|| ' ''000'' UserType, ''000'' SubUserType, '
|| ' a.NetType, '
|| ' a.InCallNum '
|| ' from ICD.t_H1V7_CallBy10011CG a, ICDMAIN.t_H1_Cit
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......