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

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 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

ÎÊÒ»¸öoracle»ù´¡ÖªÊ¶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬
 ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9
û¿´¶® replaceô

ÊǵÄÒýÓÃ
û¿´¶® replaceô

replace('FM099','9','ÏëÌæ»»³Éµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ