oracle sqlÓï¾äÓÅ»¯»ù´¡
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉԸߡ£µ«¾ßÌåÔÚÑ¡ÔñIN»òEXIST²Ù×÷ʱ£¬Òª¸ù¾ÝÖ÷×Ó±íÊý¾ÝÁ¿´óСÀ´¾ßÌ忼ÂÇ¡£
²»ÓÓ<>”»òÕß“!=”²Ù×÷·û¡£¶Ô²»µÈÓÚ²Ù×÷·ûµÄ´¦Àí»áÔì³ÉÈ«±íɨÃ裬¿ÉÒÔÓÓ<” or
“>”´úÌæ¡£
Where×Ó¾äÖгöÏÖIS NULL»òÕßIS NOT NULLʱ£¬Oracle»áֹͣʹÓÃË÷Òý¶øÖ´ÐÐÈ«±íɨ
Ãè¡£¿ÉÒÔ¿¼ÂÇÔÚÉè¼Æ±íʱ£¬¶ÔË÷ÒýÁÐÉèÖÃΪNOT NULL¡£ÕâÑù¾Í¿ÉÒÔÓÃÆäËû²Ù×÷À´È¡´úÅжÏNULLµÄ²Ù×÷¡£
µ±Í¨Åä·û“%”»òÕß“_”×÷Ϊ²éѯ×Ö·û´®µÄµÚÒ»¸ö×Ö·ûʱ£¬Ë÷Òý²»»á±»Ê¹Óá£
¶ÔÓÚÓÐÁ¬½ÓµÄÁГ||”£¬×îºóÒ»¸öÁ¬½ÓÁÐË÷Òý»áÎÞЧ¡£¾¡Á¿±ÜÃâÁ¬½Ó£¬¿ÉÒÔ·Ö¿ªÁ¬½Ó»ò
ÕßʹÓò»×÷ÓÃÔÚÁÐÉϵĺ¯ÊýÌæ´ú¡£
Èç¹ûË÷Òý²»ÊÇ»ùÓÚº¯ÊýµÄ£¬ÄÇôµ±ÔÚWhere×Ó¾äÖжÔË÷ÒýÁÐʹÓú¯Êýʱ£¬Ë÷Òý²»ÔÙÆð×÷

Where×Ó¾äÖбÜÃâÔÚË÷ÒýÁÐÉÏʹÓüÆË㣬·ñÔò½«µ¼ÖÂË÷ÒýʧЧ¶ø½øÐÐÈ«±íɨÃè¡£
¶ÔÊý¾ÝÀàÐͲ»Í¬µÄÁнøÐбȽÏʱ£¬»áʹË÷ÒýʧЧ¡£
ÓÓ>=”Ìæ´ú“>”¡£
UNION²Ù×÷·û»á¶Ô½á¹û½øÐÐɸѡ£¬Ïû³ýÖØ¸´£¬Êý¾ÝÁ¿´óµÄÇé¿öÏ¿ÉÄÜ»áÒýÆð´ÅÅÌÅÅÐò¡£
Èç¹û²»ÐèҪɾ³ýÖØ¸´¼Ç¼£¬Ó¦¸ÃʹÓÃUNION ALL¡£
Oracle´Óϵ½ÉÏ´¦ÀíWhere×Ó¾äÖжà¸ö²éѯÌõ¼þ£¬ËùÒÔ±íÁ¬½ÓÓï¾äӦдÔÚÆäËûWhere
Ìõ¼þǰ£¬¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐëдÔÚWhere×Ó¾äµÄĩβ¡£
Oracle´ÓÓÒµ½×ó´¦Àífrom×Ó¾äÖеıíÃû£¬ËùÒÔÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬½«
¼Ç¼×îÉٵıí·ÅÔÚ×îºó¡££¨Ö»ÔÚ²ÉÓÃRBOÓÅ»¯Ê±ÓÐЧ£¬ÏÂÎÄÏêÊö£©
Order ByÓï¾äÖеķÇË÷ÒýÁлήµÍÐÔÄÜ£¬¿ÉÒÔͨ¹ýÌí¼ÓË÷ÒýµÄ·½Ê½´¦Àí¡£Ñϸñ¿ØÖÆÔÚ
Order ByÓï¾äÖÐʹÓñí´ïʽ¡£
²»Í¬ÇøÓò³öÏÖµÄÏàͬµÄSqlÓï¾ä£¬Òª±£Ö¤²éѯ×Ö·ûÍêÈ«Ïàͬ£¬ÒÔÀûÓÃSGA¹²Ïí³Ø£¬·ÀÖ¹
ÏàͬµÄSqlÓï¾ä±»¶à´Î·ÖÎö¡£
¶àÀûÓÃÄÚ²¿º¯ÊýÌá¸ßSqlЧÂÊ¡£
µ±ÔÚSqlÓï¾äÖÐÁ¬½Ó¶à¸ö±íʱ£¬Ê¹ÓñíµÄ±ðÃû£¬²¢½«Ö®×÷ΪÿÁеÄǰ׺¡£ÕâÑù¿ÉÒÔ¼õÉÙ
½âÎöʱ¼ä¡£
ÐèҪעÒâµÄÊÇ£¬Ëæ×ÅOracleµÄÉý¼¶£¬²éѯÓÅ»¯Æ÷»á×Ô¶¯¶ÔSqlÓï¾ä½øÐÐÓÅ»¯£¬Ä³Ð©ÏÞÖÆ¿ÉÄÜÔÚа汾µÄOracleϲ»ÔÙÊÇÎÊÌâ¡£ÓÈÆäÊDzÉÓÃCBO£¨Cost-Based Optimization£¬»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½£©
Ïà¹ØÎĵµ£º
oracle¿Í»§¶Ë Á¬½ÓPL/SQL
ÏÂÔØ¿Í»§¶Ëµ½Ä³¸ö·¾¶
ÐÞ¸ÄÅäÖÃÎļþ
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SQLCLUB =
(DESCRIPTION ......
Çë½Ì´ó¼ÒÒ»¸öÓйØSQL½»×¤±¨±í²éѯÎÊÌ⣬»¶Ó¸÷λָ½Ì£¡
ÎÒÏë°Ñͼ1µÄʹÓÃÐÅÏ¢£¬Ê¹ÓÃSQLÓï¾ä£¬ÊµÏÖÈçͼ2µÄ½á¹û¡£
±íÃû
ÐòºÅ
×Ö¶ÎÃû
a
1
c
a
2
d
a
3
e
a
4
f
a
5
g
b
1
h
b
2
i
b
3
j
b
4
k
b
5
l
c
1
m
c
2
n
c
3
o
c
4
p
c
5
q
ͼ1
±íÃû
ÐòºÅ
1
2
3
4
5
......
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_movefile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_movefile]
GO
/*--ÒÆ¶¯·þÎñÆ÷ÉϵÄÎļþ
²»½èÖú xp_cmdshell ,ÒòΪÕâ¸öÔÚ´ó¶àÊýʱºò¶¼±»½ûÓÃÁË
--×Þ½¨ 2004.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)--*/
/*--µ÷ÓÃʾÀý ......
ÄãÊÇ·ñÔÚǧ·½°Ù¼ÆÓÅ»¯SQL Server Êý¾Ý¿âµÄÐÔÄÜ?Èç¹ûÄãµÄÊý¾Ý¿âÖк¬ÓдóÁ¿µÄ±í¸ñ£¬°ÑÕâЩ±í¸ñ·ÖÇø·ÅÈë¶ÀÁ¢µÄÎļþ×é¿ÉÄÜ»áÈÃÄãÊÜÒæ·Ëdz¡£SQL Server 2005ÒýÈëµÄ±í·ÖÇø¼¼Êõ£¬ÈÃÓû§Äܹ»°ÑÊý¾Ý·ÖÉ¢´æ·Åµ½²»Í¬µÄÎïÀí´ÅÅÌÖУ¬Ìá¸ßÕâЩ´ÅÅ̵IJ¢Ðд¦ÀíÐÔÄÜÒÔÓÅ»¯²éѯÐÔÄÜ¡£
¡¡¡¡SQL ServerÊý¾Ý¿â±í·ÖÇø²Ù×÷¹ý³ÌÓÉÈý¸ö²½Öè×é³É£º
¡ ......
sql isnullº¯ÊýµÄʹÓÃ
ISNULL
ʹÓÃÖ¸¶¨µÄÌæ»»ÖµÌæ»» NULL¡£
Óï·¨
ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_value
ÔÚ check_expression Ϊ NULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë chec ......