¹ØÓÚlinuxÏÂoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
1¡£ÔÚlinuxÏ ÎÒµÄoracle OEM½çÃæÎÞ·¨´ò¿ª Ò»Ö±ÌáʾÎÞ·¨Á¬½Ó £¨ÎÒÊäÈëµÄÊÇ http://xxxxx.1156/em£©
2¡£ÊäÈëDBCA ϵͳÌáʾ ÎÞ·¨Á¬½ÓÊý¾Ý¿â
Çë½Ì¸÷λ´óϺ Õâµ½µ×ÊÇʲôÔÒò ÎÒ²éÁ˲»ÉÙ×ÊÁ϶¼ÎÞ·¨½â¾ö
Ò»°ãÇé¿öÏÂĬÈÏΪhttp://xxxxx.1158/em
°²×°µÄʱºòÊÇ·ñÉèÖÃÁËEMµÄ×Ô¶¯Æô¶¯¡£
Èç¹ûÄãÊǸհ²×°µÄoracle¾Í²»ÄÜ´ò¿ªEM£¬ÄÇô¿ÉÄÜÊÇÄã°²×°ÓÐÎÊÌâ¡£
ÎÒ°²×°ºÃÁËÒÔºóÊÇ¿ÉÒÔ´ò¿ªµÄ µ«ÊÇÏÖÔÚÎÞ·¨´ò¿ªÁË ÊǸúÍøÂçÓÐ¹Ø »¹ÊÇʲô ÇëÎÊ´ò¿ªoemÐèÒªÄÄЩÏȾöÌõ¼þ°¡
»¹ÓÐÇë¸÷λ´óϺ°ïÎÒ½â¾öһϵڶþ¸öÎÊÌâ~~~ллÁË~
SQL PLUSÄܹ»Á¬½ÓÊý¾Ý¿â?
Ŷ ²»ºÃÒâ˼ ÊÇÎÞ·¨Á¬½Ó·þÎñÆ÷ ~~~~
·Ç³£¸Ðл ÎÒÈ¥ÊÔÊÔ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
ÔÚubuntuÉϴÁË·þÎñÆ÷£¬¸ùĿ¼Ϊ/var/www£¬Ê¹ÓÃphp½Å±¾ÔÚ/var/www/htmlÎļþ¼ÐÏÂÉú³ÉÁËÎļþ¼ÐºÍÎļþ£¬Éú³ÉµÄ¸ñʽÊÇ/var/www/html/123456/sss.html£¬Éú³Éºó²é¿´htmlÎļþ¼ÐµÄȨÏÞÊÇwww-data£¬ÎÒÖ´ÐÐphpµÄɾ³ý½Å±¾µÄʱ ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ´´½¨µÄ±í£¿
select tname from tab;
SQL code:
--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab;
......