PL/SQLÈçºÎÉèÖÃÊôÐÔ£¬Ê¹ÆäÄÜ×Ô¶¯Ê¶±ð±íÃû
±ÈÈç˵£¬µ±ÎÒÔÚSQL±à¼ÇøÊäÈëYS_£¬ÄÇôPL/SQL×Ô¶¯½«Êý¾Ý¿âÖпɱ»·ÃÎÊÇÒ±íÃûÒÔYS_¿ªÊ¼µÄ±íÈ«²¿ÏÔʾ³öÀ´
ûÉèÖÃ,¾ÍÄÜ´ïµ½ÄãÕâÑùµÄЧ¹û.¹À¼ÆÄ¬ÈÏÉèÖþÍÊÇÕâÑùµÄ ĬÈÏÉèÖþÍÊÇÕâÑùµÄ£¬»á×Ô¶¯µ¯³öÒ»ÁбíÃ÷×ÖÈÃÄãÑ¡ÔñµÄ¡£ ĬÈÏÉèÖþͿÉÒÔ´ïµ½ÄãµÄÒªÇó°ÑÒýÓà ĬÈÏÉèÖþÍÊÇÕâÑùµÄ£¬»á×Ô¶¯µ¯³öÒ»ÁбíÃ÷×ÖÈÃÄãÑ¡ÔñµÄ¡£ ÊÇÕâÑùµÄ F6 SQL code: ĬÈϾÍÊÇÕâÑùµÄЧ¹û¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿ 21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30 Ö¸µ ......
Êý¾Ý±í¡¾biao¡¿£¬ ×ֶΣºid¡¢myname¡¢mytxt mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£© ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
table1 Ãû³Æ Èë¿âÊý CT»ú 3 CT»ú 5 X¹â»ú 4 ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......