ÎÒµÄSQL֮·2
ÖÁ½ñδÓгɾͣ¬Éõ¸ÐáÝáå¡£
²¢²»ÊǺÜͻȻµÄÏëѧSQL£¬¶øÊÇÔÚ֮ǰ˵µÄÄÇÑù£¬ÔÚÎÒÈÆÁËÒ»´óȦ֮ºó£¬²ÅÖªµÀ×Ô¼ºÒ²ÊÇÒ»ÎÞËùÖª£¬Í÷ѧÁËÕâô¶àÄê¡£
ÎÒÒ»Ö±ÏëÍÑÀëѧУµÄ½ÌÓýģʽÀ´×Ôѧ£¬È»¶øÎÒ²¢²»³ÐÈÏѧУµÄ½ÌÓý·½Ê½ÊÇÒ»ÎÞËùÓõģ¬ÖÁÉÙѧµ½µÄ¶«Î÷ÊÇʵÔڵġ£´ÓѧУµÄ½Ç¶ÈÀ´¿¼ÂÇ£¬ÕâÑùµÄ°²ÅŵÄÈ·¿´ËÆÍêÃÀ¡£È»¶ø£¬½á¾ÖÒ»Èç¼ÈÍùµÄ±¯¾ç£¬ÎÒÃǽ«³ÉΪ¼¸°ÙÍò±ÏÒµ¼´Ê§ÒµµÄ´ó¾üÖеÄÒ»Ô±¡£
ÎÒ²»ÊÇ·ßÇ࣬²»Ì¸ÂÛÊÇ·Ç¶Ô´í¡£²¢·Ç²»Ïë̸£¬¶øÊÇÎÞ¼ÃÓÚÊ¡£
ÎÒ²»ÊÇÌì²Å£¬µ«ÎÒ²»ÈÏΪÎÒÊÇ´À²Ä¡£
֮ǰµÄ×ÔѧºÜ²»¼û³ÉЧ£¬ÉËÐÄÖ®Óà±¶ÔâA¸¨µ¼Ô±ÍÚ¿à¡£ÎÒÆ½ÉúÍ·´ÎÒ»¸ÄºÃѧÉúÃæ¿×£¬ÔÚ½ÌÊÒÍâ´ó³³Ò»¼Ü£¬Ö®ºó£¬Ö»ÓÐÆ½¾²¡£
ÎÒ¸Ã×öʲô£¬²»¸Ã×öʲô£¬ÎÒ¸ÃÔõô×ö£¬ÎÒ»áºÃºÃµÄÏëÒ»Ïë…
Ïà¹ØÎĵµ£º
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
&nbs ......
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ
1. ......
ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
1.ÏÂÔØOracle Client Package
.
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
Client Package – Basic
°ü
(
±ê×¢
:All files
required to run OCI, OCCI, and JDBC-OC ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäËü° ......
1£ºµ± SQL Óï¾äÒýÓ÷ÇË÷ÒýÊÓͼʱ£¬·ÖÎöÆ÷ºÍ²éѯÓÅ»¯Æ÷½«·ÖÎö SQL Óï¾äµÄÔ´ºÍÊÓͼµÄÔ´£¬È»ºó½«ËüÃǽâÎöΪµ¥¸öÖ´Ðмƻ®¡£Ã»Óе¥¶ÀÓÃÓÚ SQL Óï¾ä»òÊÓͼµÄ¼Æ»®¡£
2£ºË÷ÒýÊÓͼµÄÐÐÒÔ±íµÄ¸ñʽ´æ´¢ÔÚÊý¾Ý¿âÖС£Èç¹û²éѯÓÅ»¯Æ÷¾ö¶¨Ê¹Óòéѯ¼Æ»®µÄË÷ÒýÊÓͼ£¬ÔòË÷ÒýÊÓͼ½«°´ÕÕ»ù±íµÄ´¦Àí·½Ê½½øÐд¦Àí ......