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×÷Ϊºó׺
Ïà¹ØÎĵµ£º
´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏʰɣ¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI
ÏÂÃæÊdzÌÐò ......
¡¡ Ö¢×´
¡¡¡¡µ±Äú½«Êý¾Ý¿â±¸·Ý»Ö¸´µ½Áíһ̨·þÎñÆ÷ʱ£¬¿ÉÄÜ»áÓöµ½¹ÂÁ¢Óû§µÄÎÊÌâ¡£SQL Server Áª»ú´ÔÊéÖеĹÂÁ¢Óû§ÒÉÄѽâ´ðÖ÷ÌâÖÐûÓн²Êö½â¾ö´ËÎÊÌâµÄ¾ßÌå²½Öè¡£
¡¡¡¡±¾ÎĽéÉÜÁËÈçºÎ½â¾ö¹ÂÁ¢Óû§ÎÊÌâ¡£
¡¡¡¡×´Ì¬
¡¡¡¡Microsoft ÒѾȷÈÏÕâÊÇÔÚ±¾ÎÄ¿ªÍ·ÁгöµÄ Microsoft ²úÆ·ÖдæÔÚµÄÎÊÌâ¡£
¡¡¡¡¸ü¶àÐÅÏ ......
SQL Server 2000µÄ°²È«ÅäÖÃÔÚ½øÐÐSQL Server 2000Êý¾Ý¿âµÄ°²È«ÅäÖÃ֮ǰ£¬Ê×ÏȱØÐë¶Ô²Ù×÷ϵͳ½øÐа²È«ÅäÖ㬱£Ö¤²Ù×÷ϵͳ´¦ÓÚ°²È«×´Ì¬¡£È»ºó¶ÔҪʹÓõIJÙ×÷Êý¾Ý¿âÈí¼þ(³ÌÐò)½øÐбØÒªµÄ°²È«ÉóºË£¬±ÈÈç¶ÔASP¡¢PHPµÈ½Å±¾£¬ÕâÊǺܶà»ùÓÚÊý¾Ý¿âµÄWebÓ¦Óó£³öÏֵݲȫÒþ»¼£¬¶ÔÓڽű¾Ö÷ÒªÊÇÒ»¸ö¹ýÂËÎÊÌ⣬ÐèÒª¹ýÂËһЩÀàËÆ&ld ......
¹ÂÁ¢ÕÊ»§£¬¾ÍÊÇij¸öÊý¾Ý¿âµÄÕÊ»§Ö»ÓÐÓû§Ãû¶øÃ»ÓеǼÃû£¬ÕâÑùµÄÓû§ÔÚÓû§¿âµÄsysusersϵͳ±íÖдæÔÚ£¬¶øÔÚmasterÊý¾Ý¿âµÄsysloginsÖÐȴûÓжÔÓ¦µÄ¼Ç¼¡£
¹ÂÁ¢ÕÊ»§µÄ²úÉúÒ»°ãÊÇÒÔÏÂÁ½ÖÖ£º
1.½«±¸·ÝµÄÊý¾Ý¿âÔÚÆäËü»úÆ÷ÉÏ»¹Ô£»
2.ÖØ×°ÏµÍ³»òSQL SERVERÖ®ºóÖ»»¹ÔÁËÓû§¿â
½â¾ö·½·¨ÊÇʹÓÃsp_change_users_loginÀ´ÐÞ¸´¡£
......
ÓÉÓÚÊý¾Ý¿â¶ÔxmlÊý¾ÝÖ±½Ó´¦ÀíÓкܶàÓÅÊÆ£¬05Ò²¶ÔÕâ·½Ãæ¼ÓÇ¿Á˹¦ÄÜ¡£
µ«Õâ·½Ãæ×ÊÁÏÉÙ£¬ËùÒÔ×Ô¼º×öÁËһЩ×ܽᣬϣÍû»á¸ø´ó¼Ò´øÀ´°ïÖú
--charry0110(Ïþ·ç²ÐÔÂ)
--×÷Õߣº³Â ......