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

pl/sql´Ê»ãµ¥Ôª

 
2±êʶ·û¹æÔò
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿ ³£Á¿Ê±£¬Ã¿ÐÐÖ»ÄܵÚÒ»Ò»¸ö±êʶ·û
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿£¬³£Á¿Ê±£¬±êʶ·ûÃû³Æ±ØÐëÒªÒÔ°¢À­²®×Ö·û£¨A~Z,a~z£©¿ªÊ¼£¬²¢ÇÒ×î´ó³¤¶ÈΪ30¸ö×Ö·û¡£Èç¹ûÒÔÆäËû×Ö·û¿ªÊ¼£¬ÄÇô±ØÐëҪʹÓÃË«ÒýºÅÒýס¡£
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿³£Á¿Ê±£¬±êʶ·ûÃû³ÆÖ»ÄÜʹÓ÷ûºÅA~Z,a~z£¬0~9£¬_,$ºÍ#¡£Èç¹ûʹÓÃÆäËû×Ö·û£¬ÄÇô±ØÐëҪʹÓÃË«ÒýºÅÒýס.
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿£¬³£Á¿Ê±£¬±êʶ·ûÃû³Æ²»ÄÜʹÓÃOracleµÄ¹Ø¼ü×Ö¡£ÀýÈç²»ÄÜʹÓÃSELECT ,UPDATEµÈ×÷Ϊ±äÁ¿Ãû¡£
Èç¹ûҪʹÓÃOracle¹Ø¼ü×Ö¶¨Òå±äÁ¿£¬³£Á¿ÄÇô±ØÐëʹÓÃË«ÒýºÅÒýס
Îı¾
×¢ÒâµÄµØ·½ ÔÚOracle 10gÖ®ÖÐÈç¹û×Ö·û´®Îı¾°üº¬µ¥ÒýºÅ£¬ÄÇô¼È¿ÉÒÔʹÓÃÔ­Óиñʽ¸³Öµ£¬Ò²¿ÉÒÔʹÓÃÆäËû·Ö¸î·û£¨[]£¬{}£¬<>µÈ£©¸³Öµ¡£ÒªÊ¹ÓÃÉÏÊö·Ö¸ô·ûʱ ²»½öÐèÒªÔÙ·Ö¸ô·ûǰºó¼Óµ¥ÒýºÅ£¬¶øÇÒÐèÒª´øÓÐǰ׺q¡£Ê¾ÀýÈçÏÂ
string_var:=q'[I'm a String , you're a String.]'; 
×¢ÊÍ
µ¥ÐÐ×¢ÊÍÈç
SELECT sai INTO salaryn from emp  --È¡µÃ¹ÍÔ±¹¤×Ê
WHERE empno =emp_id;
¶àÐÐ×¢ÊÍÀýÈç
DECLARE
v_sal emp.sal%TYPE;
BEGIN
/*
*ÒÔÏ´úÂëÓÃÓÚÈ¡µÃ¹ÍÔ±¹¤×Ê
*/
SELECT sal  INTO v_sal from emp
WHERE empno=&no;
dbms_output.put_line(v_sal);
END;
PL/SQL´úÂë±àд¹æÔò
±äÁ¿ÓÃv_×÷Ϊǰ׺
³£Á¿ÓÃc_×÷Ϊǰ׺
Óαê ÓÃ_cursor ×÷Ϊºó׺
ÀýÍâÓà e_×÷Ϊǰ׺
µ±¶¨ÒåPL/SQL±íÀàÐÍʱ£¬½¨ÒéʹÓÃ_table_type×÷Ϊǰ׺
µ±¶¨ÒåPL/SQL±í±äÁ¿Ê± £¬ÓÃ_table×÷Ϊºó׺
ÓÃPL/SQL¼Ç¼ÀàÐÍʱ  ÓÃ_record_type ×÷Ϊºó׺¡¢
ÓÃPL/SQL¼Ç¼±äÁ¿Ê± ÓÃ_record×÷Ϊºó׺


Ïà¹ØÎĵµ£º

perlÀûÓÃÄÚ´æÊ¹ÓÃsqlÓï¾ä

 ´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏʰɣ¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI 
ÏÂÃæÊdzÌÐò ......

SQL¹ÂÁ¢Óû§½â¾ö·½°¸

 ¡¡  Ö¢×´
¡¡¡¡µ±Äú½«Êý¾Ý¿â±¸·Ý»Ö¸´µ½Áíһ̨·þÎñÆ÷ʱ£¬¿ÉÄÜ»áÓöµ½¹ÂÁ¢Óû§µÄÎÊÌâ¡£SQL Server Áª»ú´ÔÊéÖеĹÂÁ¢Óû§ÒÉÄѽâ´ðÖ÷ÌâÖÐûÓн²Êö½â¾ö´ËÎÊÌâµÄ¾ßÌå²½Öè¡£
¡¡¡¡±¾ÎĽéÉÜÁËÈçºÎ½â¾ö¹ÂÁ¢Óû§ÎÊÌâ¡£
¡¡¡¡×´Ì¬
¡¡¡¡Microsoft ÒѾ­È·ÈÏÕâÊÇÔÚ±¾ÎÄ¿ªÍ·ÁгöµÄ Microsoft ²úÆ·ÖдæÔÚµÄÎÊÌâ¡£
¡¡¡¡¸ü¶àÐÅÏ ......

SQLÊý¾Ý¿â·þÎñÆ÷µÄ°²È«²ßÂÔ ±£»¤Êý¾Ý°²È«

 SQL Server 2000µÄ°²È«ÅäÖÃÔÚ½øÐÐSQL Server 2000Êý¾Ý¿âµÄ°²È«ÅäÖÃ֮ǰ£¬Ê×ÏȱØÐë¶Ô²Ù×÷ϵͳ½øÐа²È«ÅäÖ㬱£Ö¤²Ù×÷ϵͳ´¦ÓÚ°²È«×´Ì¬¡£È»ºó¶ÔҪʹÓõIJÙ×÷Êý¾Ý¿âÈí¼þ(³ÌÐò)½øÐбØÒªµÄ°²È«ÉóºË£¬±ÈÈç¶ÔASP¡¢PHPµÈ½Å±¾£¬ÕâÊǺܶà»ùÓÚÊý¾Ý¿âµÄWebÓ¦Óó£³öÏֵݲȫÒþ»¼£¬¶ÔÓڽű¾Ö÷ÒªÊÇÒ»¸ö¹ýÂËÎÊÌ⣬ÐèÒª¹ýÂËһЩÀàËÆ&ld ......

SQL SERVER ´¦Àí¹ÂÁ¢ÕÊ»§

¹ÂÁ¢ÕÊ»§£¬¾ÍÊÇij¸öÊý¾Ý¿âµÄÕÊ»§Ö»ÓÐÓû§Ãû¶øÃ»ÓеǼÃû£¬ÕâÑùµÄÓû§ÔÚÓû§¿âµÄsysusersϵͳ±íÖдæÔÚ£¬¶øÔÚmasterÊý¾Ý¿âµÄsysloginsÖÐȴûÓжÔÓ¦µÄ¼Ç¼¡£
¹ÂÁ¢ÕÊ»§µÄ²úÉúÒ»°ãÊÇÒÔÏÂÁ½ÖÖ£º
1.½«±¸·ÝµÄÊý¾Ý¿âÔÚÆäËü»úÆ÷ÉÏ»¹Ô­£»
2.ÖØ×°ÏµÍ³»òSQL SERVERÖ®ºóÖ»»¹Ô­ÁËÓû§¿â
½â¾ö·½·¨ÊÇʹÓÃsp_change_users_loginÀ´ÐÞ¸´¡£
......

SQL 2005 ¶Ôxml ÎļþÓë xmlÊý¾ÝµÄ²Ù×÷

 ÓÉÓÚÊý¾Ý¿â¶ÔxmlÊý¾ÝÖ±½Ó´¦ÀíÓкܶàÓÅÊÆ£¬05Ò²¶ÔÕâ·½Ãæ¼ÓÇ¿Á˹¦ÄÜ¡£
        µ«Õâ·½Ãæ×ÊÁÏÉÙ£¬ËùÒÔ×Ô¼º×öÁËһЩ×ܽᣬϣÍû»á¸ø´ó¼Ò´øÀ´°ïÖú
        --charry0110(Ïþ·ç²ÐÔÂ)
         --×÷Õߣº³Â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ