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

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'Â𣬱ä³ÉÕûÊý£¬¶øÇÒÿ´Î²éѯµÃµ½µÄ½á¹û¶¼²»Ò»Ñù


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ