OracleÊÚȨ¸øÓû§ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÓÐÒ»ÕÅѧÉú³É¼¨±í£¬Ö»ÏëÈÃÿ¸öÓû§²éѯ×Ô¼ºµÄ³É¼¨£¬²»Äܲéѯ±ðÈ˵ijɼ¨£¬Ó¦¸ÃÔõôÏÞÖÆ£¿
Õâ¸öÔÚǰ̨×öÊÇ¿ÉÒԵģ¬ ÔÚºóÌìÓÐÀ§ÄÑ¡£ ¼ÙÈçÓÐÒ»ÕÅ±í´æ·ÅѧÉú³É¼¨£¬ ѧÉúA£¬ÔÚǰ̨²éѯ£¬ÄÇô¿ÉÒÔÔÚ²éѯµÄSQLÀï¼ÓÈëAµÄѧºÅ£¬ ÕâÑù·µ»ØµÄ½á¹û¼¯¾ÍÊÇA µÄ³É¼¨¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ÀÏʦ˵¹ý£¬ºÃÏñÊǼÓÉÏÒ»¸öʲô WHERE Óï¾ä£¬USERʲôµÄ£¬µ«ÊÇÎÒÍüÁË¡£¡£¡£ ¶÷ ʹÓÃsqlÓï¾äÀ´¿ØÖÆ¡£ÓÃÒ»ÕÅuser±í Óиöuserid ѧÉúAµÇ¼ Ò³Ãæ¼ÇÏÂËûµÄidºÅ ²éѯ¾Í¼Ó¸öwhere userid='';ÒýÓà ÀÏʦ˵¹ý£¬ºÃÏñÊǼÓÉÏÒ»¸öʲô WHERE Óï¾ä£¬USERʲôµÄ£¬µ«ÊÇÎÒÍüÁË¡£¡£¡£ ÊDz»Ðе쬽¨Òéǰ̨ʵÏÖ¡£¸ù¾Ýÿ¸öÓû§µÄµÇ¼µÄѧÉúID£¬×÷Ϊ²éѯ³É¼¨µÄÌõ¼þ¡£ Äܲ»ÄÜÉèÖÃÖ»Äܲéѯµ±Ç°µÇ¼Óû§µÄ³É¼¨£» ÀýÈ磬³É¼¨±íSC(SNAME,CNAME,SCORE) µ±Ç°µÇ¼Óû§ÊÇAA, È»ºóËûÖ»ÄܲéѯAAµÄ¿Î³ÌµÄ³É¼¨£¿ ÊÇWHERE SNAME=USER µ«ÊÇÕâ¾äÓ¦¸Ã·ÅÔÚÄÄÀ ¿ÉÒÔ½èÖúORCLE POLICYʵÏÖ¡£ ¾ßÌå·½·¨×Ô¼ºGOOGLEÒýÓà Äܲ»ÄÜÉèÖÃÖ»Äܲéѯµ±Ç°µÇ¼Óû§µÄ³É¼¨£» ÀýÈ磬³É¼¨±íSC(SNAME,CNAME,SCORE) µ±Ç°µÇ¼Óû§ÊÇAA, È»ºóËûÖ»Äܲ
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬ ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9 û¿´¶® replaceô ÊǵÄÒýÓà û¿´¶® replaceô replace('FM099','9','ÏëÌæ»»³Éµ ......