Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PL/SQL ÖÐÎÄÂÒÂë½â¾ö·½°¸

1. ʹÓõÄÊÇ·þÎñÆ÷Éϵģ¬²»ÊDZ¾»úµÄOracle£¬°´ÏÂÃæ×ö¾Í¿ÉÒÔÁË£º
    ÉèÖû·¾³±äÁ¿:NLS_LANG£¬¾ßÌåÖµÓÃÏÂÃæ²éѯµÄÖµ:
SELECT 'AMERICAN_AMERICA.' || PROPERTY_VALUE
from DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'NLS_CHARACTERSET';
2. Èç¹ûÊDZ¾»úµÄOracle¾ÍÐèÒªÔÚOracleµÄ°²×°Ä¿Â¼ÏÂÃæ¸ÄÉèÖãº
ÓÐÒ»¸öÅäÖÃÎļþÃûΪdbappscfg.properties£¬Ð޸ĸÃÎļþ¼´¿É½â¾öÉÏÊöÎÊÌâ¡£Õâ¸öÎļþµÄλÖÃÔÚ$oracle_home\sysman\configĿ¼Ï£¬ÓÃÈκεÄÎı¾±à¼­Æ÷´ò¿ª¸ÃÎļþ£¬ÔÚÕâ¸öÎļþÀïÃ棬ÕÒµ½ÕâÑùÒ»Ï
# sqlplus_nls_lang=american_america.we8iso8859p1
È¥µô×¢ÊÍ·û#£¬Í¬Ê±½«ÆäÐÞ¸ÄΪsqlplus_nls_lang=american_america.zhs16gbk¡£
¶ÔÓÚwindows²Ù×÷ϵͳ£¬»¹ÐèÒªÐÞ¸ÄÒ»ÏÔÚÎļþÖÐÕÒµ½# sqlplus_systemroot=c:\\winnt40£¬È¥µô×¢ÊÍ·û£¬½«ÆäÐÞ¸ÄΪÄãËùÔÚ»úÆ÷µÄ²Ù×÷ϵͳÖ÷Ŀ¼¡£Èç²Ù×÷ϵͳµÄÖ÷Ŀ¼ÔÚdÅ̵ÄwinntÏ£¬Ôò½«ÆäÐÞ¸ÄΪ sqlplus_systemroot=d:\\winnt¡£
¶ÔÓÚºóÃæÒ»ÏîµÄÐÞ¸ÄÖ»¶Ôwindows²Ù×÷ϵͳ½øÐУ¬¶Ôunix²Ù×÷ϵͳÔò²»ÐèÒª¡£Èç¹ûÔÚwindows²Ù×÷ϵͳÖв»Ð޸ĸÃÏÔÚoracle enterprise managerÖУ¬Á¬½Óϵͳʱ£¬»áÌáʾÈçϵĴíÎó£º
ora-12560 tns:protocol adapter error
»òÕß
ora-12545 connect failed because target host or object does not exist
ÐÞ¸ÄÍê³Éºó£¬±£´æÎļþ£¬Í˳ö±à¼­¡£ÖØÐÂÁ¬½Ósql plus worksheet£¬×Ö·û¼¯ÂÒÂëÎÊÌâµÃµ½½â¾ö,ÏÔʾÕýÈ·µÄ¼òÌåÖÐÎÄ×Ö·û¼¯¡£


Ïà¹ØÎĵµ£º

½«Êý¾Ý¿â±íÖеÄÊý¾ÝתΪsqlÖеÄinsertÓï¾ä

 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì ......

SQLÖظ´¼Ç¼²éѯ

1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId  from   people  group  by   peopleId  having  count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......

SQLÓï¾äÖеÄHaving×Ó¾äÓëwhere×Ó¾äÖ®Çø±ð


SQLÓï¾äÖеÄHaving×Ó¾äÓëwhere×Ó¾äÖ®Çø±ð
---WHERE¾ä×Ó×÷ÓÃÓÚ»ù±¾±í»òÊÔͼ£¬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄÔª×é¡£HAVING×÷ÓÃÓÚ×飬´ÓÖÐÑ¡ÔñÂú×ãÌõ¼þµÄ×é---
ÔÚ˵Çø±ð֮ǰ£¬µÃÏȽéÉÜGROUP BYÕâ¸ö×Ӿ䣬¶øÔÚ˵GROUP×Ó¾äÇ°£¬ÓÖµÃÏÈ˵˵“¾ÛºÏº¯Êý”——SQLÓïÑÔÖÐÒ»ÖÖÌØÊâµÄº¯Êý¡£ÀýÈçSUM, COUNT, MAX, AVGµÈ¡£Õâ ......

SQL WHERE 1=1

1=1»òÕß'a'='a'µÈµÈºãµÈʽÊÇT-SQLÖбí´ïtrueµÄ·½·¨¡£ÒòΪÔÚT-SQLÖÐûÓÐtrueÕâÑùµÄ¹Ø¼ü
×Ö»òÖµ£¬ËùÒÔÐèÒª½èÖúÕâЩºãµÈʽÀ´±í´ïtrueµÄ¸ÅÄî¡£
Ïà¶ÔµÄ£¬Í¬Ñù¿ÉÒÔʹÓÃ1<>1»òÕß1=2µÈÀ´±í´ïfalse¡£
ÔÚÓ¦ÓóÌʽµÄ°²È«ÐÔ·½Ã棬ʹÓÃÕâЩʽ×ÓÊÇSQL×¢ÈëµÄ»ù±¾Ô­Àí£¬ËùÒÔÔÚÆ´½ÓSQLÓï¾äµÄʱºòÒª¹ýÂ˸÷ÖÖ¸÷ÑùµÄÃô¸Ð×Ö
·û¡£
µ±È» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ