OracleȡǰNλSQL
Ò²Ðí¶ÔSQL ServerÀ´Ëµ,È¡Ç°NλµÄÊý¾ÝÊǺܼòµ¥µÄÊÂÇé,Ò»ÌõTOPÓï¾ä¾Í¸ã¶¨ÁË.
ÔÚOracleÖÐÎÒÃÇÍùÍù»á¸Ð¾õµ½Í·ÌÛ,ƽÈÕÀïÒ²³£»áÓõ½,Ö÷ÒªÊÇʹÓÃpartition by.
Óï·¨ÈçÏÂ:
select emp_card_no,work_date,read_card_date,count(rownum) as cnt
from hra_read_card_day
group by emp_card_no,work_date,read_card_date
having count () <= 10
order by work_date,read_card_date
Ïà¹ØÎĵµ£º
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó ......
ÔڵǼemµÄʱºò¡£
²é¿´Ò»Ï emctl status dbconsole
ÕÒµ½urlµØÖ·
ÔÚÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄʱºò³öÏÖ
oracle 10g remoteoperationexception error wrong password for user
¿ÉÒÔÔÚ
×é²ßÂÔ -- >±¾µØ²ßÂÔ -->Óû§È¨ÀûÖ¸. -- >×÷ΪÅú´¦Àí×÷ÒµµÇ¼ÖмÓÈëÕâ¸öÓû§
¼´¿É. ......
×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞ ......
ÓÃÃüÁîÐÐ(CMD)ÖÐÆô¶¯ºÍ¹Ø±ÕORACLE·þÎñ
¼àÌýÆô¶¯
lsnrctl start
¼àÌýÍ£Ö¹
lsnrctl stop
Æô¶¯Oracle
net start oracleservicesid
Í£Ö¹Oracle
net stop oracleservicesid
netÃüÁîÊÇwinϵͳÃüÁÆäËüµÄ·þÎñÆô¶¯ºÍÉÏÃæµÄÀàËÆ£¡
......
Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØϵÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......