Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ