SQL Plus
SQL> setsqlprompt"_user _privilege> " ͨ¹ýÒÔÉÏÉèÖã¬ÄãµÄsqlplusÌáʾ±êʶ¾Í³ÉÁËÒÔϸñʽÁË£º SYS AS SYSDBA> Õâ¾Í±íÃ÷µ±Ç°µÄµÇ¼ÕʺÅÊÇSYS£¬Éí·ÝÊÇSYSDBA¡£Çë×¢ÒâÔÚÉÏÃæÓï¾äÖÐʹÓÃÁËÁ½¸öÌØÊâµÄÔ¤¶¨ÒåµÀµÂ±äÁ¿£º_userºÍ_privilege£¬·Ö±ð¶¨ÒåÁ˵±Ç°Óû§ºÍÕâ¸öÓû§µÄµÇ¼Éí·Ý£¨È¨ÏÞ£©¡£ÏÖÔÚÎÒÃÇÔÙÔö¼ÓһЩÆäËûÄÚÈÝ¡£±ÈÈçÎÒ³ýÁËÏëÖªµÀÒÔÉÏÐÅÏ¢Í⣬»¹ÏëÖªµÀµ±Ç°µÄµÇ¼ʱ¼ä£º SQL> setsqlprompt"_user _privilege on _date>" SYS AS SYSDBA on 31-8ÔÂ-05> ÔÙÔö¼ÓÒ»¸öÁ¬½ÓÐÅÏ¢¿´£¬ÕâÑù¾Í¿ÉÒÔÖ¸³öÄãµÇ¼µÄÊÇÄĸö·þÎñÆ÷µÄ£º SQL>setsqlprompt"_user on _date at _connect_identifier>" SYS on 31-8ÔÂ-05 atteng> µ«ÊÇÇ°ÃæµÄµ±Ç°Ê±¼äÐÅÏ¢Ö»ÓÐÈÕÆÚ£¬Èç¹ûÐèÒª¾«È·µ½µ±Ç°µÄÈ·ÇÐʱ¼äÄØ£º SYS on 31-8ÔÂ-05 atteng>alter session setnls_date_format='yyyy-mm-ddhh24:mi:ss'; »á»°ÒѸü¸Ä¡£ -------------- 15:02:59 SQL> SELECT USER ||'@'|| REPLACE (GLOBAL_NAME, '.WORLD', NULL) GLOBAL_NAME from GLOBAL_NAME ·½·¨2£º ¼ÓÔÚlogin.sql»òglogin.sqlÎļþµÄºóÃ棺 DEFINE gname = 'not connected'
COLUMN global_name new_value gname
SET termout off
SELECT USER ||'@'|| REPLACE (GLOBAL_NAME, '.WORLD', NULL) GLOBAL_NAME
from GLOBAL_NAME;
SET termout on
SET sqlprompt '&&gname> ' ÕâÑùÿ´ÎµÇ¼SQLPLUSÌáʾ·û»á×Ô¶¯¸ü¸ÄΪ¡°µ±Ç°Óû§Ãû@È«¾ÖÊý¾Ý¿âÃû> ¡±µÄÐÎʽ¡£ ----------------------------------------------------------------------------------------------- Èç¹ûlogin.sqlµÄµ±Ç°Ä¿Â¼sqlplusµÇ¼£¬Ôò×Ô¶¯¼ÓÔظÃsql¡£Èç¹û²»ÔÚµ±Ç°Ä¿Â¼Ôò@¸Ãsql£¬Ð§¹ûÒ»Ñù¡£ 1. ÏÔʾµ±Ç°ÔÚ´´½¨º¯Êý¡¢´æ´¢¹ý³Ì¡¢´¥·¢Æ÷¡¢°üµÈ¶ÔÏóµÄ´íÎóÐÅÏ¢
Show error
µ±´´½¨Ò»¸öº¯Êý¡¢´æ´¢¹ý³ÌµÈ³ö´íʱ£¬±ä¿ÉÒÔÓøÃÃüÁî²é¿´ÔÚÄǸöµØ·½³ö´í¼°ÏàÓ¦µÄ³ö´íÐÅÏ¢£¬½øÐÐÐ޸ĺóÔٴνøÐбàÒë¡£ 2. ÏÔʾÊý¾Ý¿âµÄ°æ±¾£º
show REL[EASE] 3. ÏÔʾµ±Ç°µÄÓû§Ãû
show user
Ïà¹ØÎĵµ£º
×÷ΪһÃûDBA£¬ËûÃÇ×î³£¼ûµÄÈÕ³£ÈÎÎñÊÇ£º
1£©¶¨ÆÚÍê³ÉÊý¾Ý¿âµÄÍêÈ«±¸·Ý»ò²îÒ챸·Ý¡£
2£©¶¨ÆÚÇåÀí±¸·ÝÎļþ£¬ÒòΪ´æ´¢¿Õ¼äÓÐÏÞ£¬¿ÉÄÜÖ»ÐèÒª±£´æÒ»¸öʱÆÚ¶ÎÄÚµÄÎļþ(±ÈÈçÒ»ÖÜÄÚ»òÒ»ÔÂÄÚ)¡£
¶øÈçºÎ×öµ½ÕâÁ½µãÄØ£¿±ÊÕßÏàÐÅÔÚSQL SERVER2005°æ±¾³öÀ´Ö®Ç°ÒªÊµÏÖÕâÖÖ¹¦ÄÜ£¬ Ò²ÊÇ¿ÉÒÔʵÏֵģ¬Ö»ÊÇʵÏÖ¶¨ÆÚÇåÀí±¸·ÝÎļþÏԵò»ÄÇôֱ ......
ÔÚSQL UPDATEÓï¾äÖУ¬¶Ô»»Á½¸ö±äÁ¿µÄÖµ£¬²»ÐèÒªÁÙʱ±äÁ¿¡£=ÓÒ²àµÄÖµÔÚÕû¸öUPDATEÓï¾äÖж¼ÊÇÒ»Öµģ»ËùÓеĸüÐÂͬʱ·¢Éú£¬¶ø²»ÊÇÒ»¸ö½Ó×ÅÒ»¸ö·¢Éú¡£
ÀýÈ磺
UPDATE offenceTeam
SET goalShooter=wingAttack,
& ......
sql serverµÄ money ÀàÐÍÆäʵ¾ÍÊÇСÊýÀàÐÍ decimal £¬ÎÒ²»Ï²»¶ÓÃËü£¬ÒòΪÓÐÒ»´Îʲô¹¤¾ßÉú³É£¬·¢ÏÖËü×Ô¶¯°ÑmoneyÀàÐÍת»»³ÉÁËdecimalÀàÐÍÁË£¬ÓëÆäÈÃËüת£¬»¹²»Èç×Ô¼ºÉè¼ÆÊý¾Ý¿âʱ½«»õ±ÒÀàÐÍ×Ö¶ÎÉèÖÃΪ decimal ÀàÐͲ»¾ÍµÃÁË£¬·ÏÄÇʸÉÂ ×Ö½ÚÊý ³¤¶È(СÊýµãÇ°.СÊýµãºó) ......
ÕÛÌÚÁËÎÒ°ëÌìÖÕÓڸ㶨ÁË
²Î¿¼ÁËÕâ¸öÎÄÕ£ºhttp://doc.javanb.com/hibernate-reference-3-2-0-zh/ch16.html
final static String querySql = "select {enterprise.*}, {dict.*} ,{balancd.*}, {weightinfo.*} "
+ "from weight_info weightinfo left outer join t_dict dict on {weightinf ......
ͨ¹ýË÷Òý£¬¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËٶȺͼõÉÙϵͳµÄÏìӦʱ¼ä£»¿ÉÒÔʹ±íºÍ±íÖ®¼äµÄÁ¬½ÓËٶȼӿ졣µ«ÊÇ£¬²»ÊÇÔÚÈκÎʱºòʹÓÃË÷Òý¶¼Äܹ»´ïµ½ÕâÖÖЧ¹û¡£ÈôÔÚ²»Ç¡µ±µÄ³¡ºÏÏ£¬Ê¹ÓÃË÷Òý·´¶ø»áÊÂÓëԸΥ¡£ Ë÷ÒýÊÇÒÔ±íÁÐΪ»ù´¡µÄÊý¾Ý¿â¶ÔÏó¡£Ë÷ÒýÖб£´æ×űíÖÐÅÅÐòµÄË÷ÒýÁÐ
¡¡¡¡
ͨ¹ýË÷Òý£¬¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËٶȺͼõÉÙϵͳµÄÏìӦʱ¼ä£ ......