sql*plus¸ü¸ÄÓû§ - Oracle / »ù´¡ºÍ¹ÜÀí
¸ü¸ÄÓû§Ê± µÄ conn ºÍconnectÓÐÊ²Ã´Çø±ð£¿£¿
²»ÊǶ¼Ê±¸ü¸ÄÓû§Â£¿
ûÓÐÇø±ð£¬ conn ÊÇconnect µÄ¼òд..
conn¾ÍÊǵ÷ÓÃconnect
Ã»Çø±ðµÄ ¶¼Ò»Ñù
connÊÇconnectµÄËõд£¬Ã»ÓÐÇø±ð¡£
¾ÍÊÇÕâÑù£¡
+1
ÄÇ grant connect to cat with admin option ºÍ
grant conn to cat with admin option
ÓÐÇø±ðÂ£¿£¿£¿£¿£¿£¿
ÎÒÕâÀïûÓÐ×°oracle ±¾Ïë×Ô¼ºÈ¥ÇóöÀ´¿´¿´µÄ
µÚÒ»¾äÊÇÔÚcatȨÏÞ Ö»Óв鿴µÄȨÏÞ
µÚ¶þÄØ£¿£¿£¿ °ÑϵͳȨÏÞ¸øcat £¿£¿£¿ ¿Éconn²»ÊǸü¸ÄÓû§µÄÒâ˼Â£¿
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......