oracleÊý¾Ý¿â²åÈëÊý¾ÝµÄ¼òµ¥ÎÊÌâ
ÎÒ°²×°ÁËÒ»¸öOracleÊý¾Ý¿â×ÀÃæÏµÍ³¡£ ½¨Á¢ÁËÒ»¸ö±ítuser£¬°üº¬ÁУº Óû§Ãû yhm£¨varcha2£©¡¢¿ÚÁî kl£¨varcha2£©¡¢ÕæÊµÐÕÃû zsxm£¨varcha2£©¡¢¹¤×÷µ¥Î» gzdw£¨varcha2£©¡¢×¢²áÈÕÆÚ zcrq£¨date£© Ó¦ÓóÌÐòÖеÄsql²åÈëÓï¾ä£º insert into tuser(yhm,kl,zsxm,gzdw,zcrq) values('zs','1qaz','ÕÅÈý','ÎÄÐù¼¯ÍÅ',to_date('2010-01-23 11:52:51','YYYY-MM-DD HH24:MI:SS')) ÏÖÔÚ±íÖÐÖ»²åÈëÁËÕâÒ»ÌõÊý¾Ý¡£ ʹÓòéѯÓï¾ä£ºselect * from tuser °´Àí˵£¬µÃµ½µÄ²éѯ½á¹ûÓ¦¸ÃÊÇ£º yhm kl zsxm gzdw zcrq zs 1qaz ÕÅÈý ÎÄÐù¼¯ÍÅ 2010-01-23 11£º52£º51 ʵ¼ÊµÃµ½µÄ½á¹ûÊÇ£º yhm kl zsxm gzdw zcrq 23 1qaz ÕÅÈý ÎÄÐù¼¯ÍÅ 23-1Ô -10 ÎÒͨ¹ý¼¸´ÎʵÑ飬·¢ÏÖyhmÖеÄÖµÊÇÕûÊý£¬Ò»Ö±µÝÔö¡£ Ϊʲô£¿£¿£¿Çë¸ßÊÖÖ¸µã£¬Ð»Ð»£¡
Ò»Ö±µÝÔö£¿ÊÇʲôÒâ˼£¬ÕÅÈýyhm×Ö¶ÎÖµ²»ÊÇ'zs'Â𣬱ä³ÉÕûÊý£¬¶øÇÒÿ´Î²éѯµÃµ½µÄ½á¹û¶¼²»Ò»Ñù£¿ ¿´¿´Ç°Ì¨³ÌÐòÊÇ·ñÓжÔyhm½øÐиüвÙ×÷ »¹ÓÐÊÇ·ñ´íÎóʹÓÃÁËÐòÁÐ ÓÐÕâÖÖÊ£¿ÊµÔÚ²»Ðеϰ£¬ÔÙ½¨Ò»ÕűíÁíÍâµÄ±í£¬¿´¿´ÓÐûÓÐÀàËÆµÄÇé¿ö.ÒýÓà һֱµÝÔö£¿ÊÇʲôÒâ˼£¬ÕÅÈýyhm×Ö¶ÎÖµ²»ÊÇ'zs'Â𣬱ä³ÉÕûÊý£¬¶øÇÒÿ´Î²éѯµÃµ½µÄ½á¹û¶¼²»Ò»Ñù
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......