OracleµÄ ¼òµ¥ÐÐתÁÐ
Ó¦¸ö±¨±íÒªÇó×ö¸ö
ʱ¼ä ˫ɫÇò£¬ ʤ¸º²Ê¡£¡£¡£¡£¡£
200905 ÏúÁ¿ ÏúÁ¿
200906 ÏúÁ¿ ÏúÁ¿
200907 ÏúÁ¿ ÏúÁ¿
200908 ÏúÁ¿ ÏúÁ¿
Ò»¸öSQL Óï¾äµÃµ½½á¹ûÊÇ£º
f_yearmonth, lot_name,money
200905 ˫ɫÇò 50
200905 ʤ¸º²Ê 100
200906 ˫ɫÇò 60
200906 ʤ¸º²Ê 70
Select f_yearmonth,
Max(decode(f_lotname,'˫ɫÇò',f_money,0)) As "˫ɫÇò",
Max(decode(f_lotname,'¸£²Ê3D',f_money,0)) as "¸£²Ê3D",
Max(decode(f_lotname,'ʤ¸º²Ê',f_money,0)) as "ʤ¸º²Ê",
Max(decode(f_lotname,'ʱʱ²Ê',f_money,0)) as "ʱʱ²Ê",
Max(decode(f_lotname,'ʱʱÀÖ',f_money,0)) as "ʱʱÀÖ",
from
t_tmp_test_A
Group By f_yearmonth
Order By f_yearmonth
¹Ø¼üÓï¾ä£º
Max(decode(f_lotname,'˫ɫÇò',f_money,0)) As "˫ɫÇò",
Group By f_yearmonth
ӦΪ °´Ê±¼äÖØ×éÖ»ÓÐÒ»Ìõ£¬²¢ÇÒÖ»ÓÐÒ»ÌõÊý¾Ý£º 200905 ˫ɫÇò 50
ÄÇô ÓÃMAXȡһÌõÊý¾Ý ¾ÍÊÇ50
decode Òâ˼˵ Èç¹ûÊǑ˫ɫÇò’ È¡¶ÔÓ¦µÄf_money ²¢ÇÒ·ÅÔÚ ÃüÃûΪ "˫ɫÇò"µÄ ÁÐÉÏ¡£
ºÜÏÔÈ» ÕâÁÐÊǹ̶¨£¡
Ïà¹ØÎĵµ£º
Ò».°´Ó¢ÎÄ×ÖĸÅÅÐò:
select * from table order by nlssort(name,'NLS_SORT=schinese_pinyin_M');
¶þ. дһ¸öSQLÓï¾ä£¬²éѯѡÐÞÁË5Ãſγ̵ÄѧÉúѧºÅºÍÐÕÃû£¨9·ÖÖÓ£©
´ð£ºSQLÓï¾äÈçÏ£º
select stu.sno, stu.sname
from student stu
where (select count(*) from s ......
1¡¢´¥·¢Æ÷µÄ¸ÅÄî
´¥·¢Æ÷Ò²ÊÇÒ»ÖÖ´øÃûµÄPL/SQL¿é¡£´¥·¢Æ÷ÀàËÆÓÚ¹ý³ÌºÍº¯Êý£¬ÒòΪËüÃǶ¼ÊÇÓµÓÐÉùÃ÷¡¢Ö´ÐкÍÒì³£´¦Àí¹ý³ÌµÄ´øÃûPL/SQL¿é¡£Óë°üÀàËÆ£¬´¥·¢Æ÷±ØÐë´æ´¢ÔÚÊý¾Ý¿âÖв¢ÇÒ²»Äܱ»¿é½øÐб¾µØ»¯ÉùÃ÷¡£
¶ÔÓÚ´¥·¢Æ÷¶øÑÔ£¬µ±´¥·¢Ê¼þ·¢ÉúµÄʱºò¾Í»áÏÔʽµØÖ´Ðиô¥·¢Æ÷£¬²¢ÇÒ´¥·¢Æ÷²»½ÓÊܲÎÊý¡£
´´½¨´¥·¢Æ÷µÄÓï·¨È ......
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐзҳµÄÔʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN ......
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂ
ÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVR ......
°¸Àý˵Ã÷£º
ÓÐA,BÁ½Ì¨oracleÊý¾Ý¿â£¬¶¼Îª10g,ÏÖÔÚÓÐÒ»¸öAÊý¾Ý¿âÖÐone±íµÄ¼¸ÌõÊý¾ÝÒª²åÈëµ½BÊý¾Ý¿âÖеÄone±í£¿
ÔÚÍøÉϲéÔÄÁËһϣ¬¿ÉÒÔͨ¹ýÔÚAÉϽ¨Á¢dblink£¬µ±È»ÔÚB»úÉϽ¨Á¢Ò²ÊÇÒ»ÑùµÄ¡£
´ò¿ªsqlplusÖÕ¶Ë£¬»òÕßÈÎÒâµÄoracle¿Í»§¶Ë»·¾³£¬Ö´ÐÐÒÔÏÂSQL
create database link Á´½ÓÃû
¡¡connect t ......