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

OracleÖÐÌí¼ÓJob

OracleÖÐÌí¼ÓJob
 --ÿ15·ÖÖÓ trunc(sysdate+1/96,'MI')/*5:Mins*/ sysdate + 5/(60*24)
SQL> variable jobno number;
SQL> begin
  2  dbms_job.submit(:jobno,'´æ´¢¹ý³ÌÃû;',sysdate,'/*1:Hr*/ sysdate + 1/24' );
  3  commit;
  4  end;
  5  /


Ïà¹ØÎĵµ£º

oracle²éѯÁ·Ï°

empÔ±¹¤±í
(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
------1.Ñ¡Ôñ²¿ÃÅ30ÖеÄËùÓÐÔ±¹¤.
select ename
from emp
where deptno = 30;
------2.ÁгöËùÓаìÊÂÔ±(CLERK)µÄÐÕÃû£¬±àºÅºÍ²¿ÃűàºÅ.
select ename,empno,deptno
from emp
where job='CLERK';
--- ......

´«ÖDz¥¿ÍjavaÅàѵORACLE×ܽá(3)


 
ORACLEµÄѧϰÒѾ­¸æÒ»¶Î茖£¬½ñÌìÒѾ­¿ªÊ¼HIBERNATEµÄѧϰ£¬×ÜÌå¸Ð¾õͦÁ¼ºÃµÄ£¬ËäÈ»ºÜ¶àµÄ֪ʶ²»ÄܼÇס£¬µ«ÊÇÔÚʹÓõÄʱºòÄܹ»Ñ¸ËÙµÄÕÒ¶Ô·½·¨À´½â¾öÏàÓ¦µÄÎÊÌ⣬ֻҪÇÚ¼ÓÁ·Ï°£¬¾Í¿ÉÒÔ¼Çס¡£Ö»²»¹ý£¬Ê±¼äÓÐ珢£¬HIBERNATEµÄ¿Î³ÌÒ²Ö»ÓÐÈýÌìµÄʱ¼ä£¬ËùÒÔÔÚÕâÆÚ¼äÎÒµÄÈÎÎñÊǾ¡Á¿ÎüÒý£¬ÔÚ»¨·Å¼ÙµÄʱºòÀ´¸´Ï° ......

ʹÓÃoracleµÄһЩ¼¼ÇÉ·½·¨

½«²éѯµÄ½á¹ûÉú³Éµ½ÎļþÖУº
set echo on --ÊÇ·ñÏÔʾִÐеÄÃüÁîÄÚÈÝ
set feedback off --ÊÇ·ñÏÔʾ * rows selected
set heading off --ÊÇ·ñÏÔʾ×ֶεÄÃû³Æ
set verify off --ÊÇ·ñÏÔÊ¾Ìæ´ú±äÁ¿±»Ìæ´úǰºóµÄÓï¾ä¡£fil
set trimspool off --È¥×ֶοոñ
set pagesize 1000 ......

oracle ¹ÙÍøÎÞ·¨·ÃÎʵÄÎÊÌâ

×î½üÓöµ½ÔÚwindows 2008ÏÂIEÆäËüµÄÍøÒ³¶¼¿ÉÒÔ·ÃÎÊ,ΨÓÐoracle.com²»ÄÜ·ÃÎÊ,ÕæÓôÃÆÁË,ºóÀ´ÕÒÒ»´úÀí,·ÃÎÊËÙ¶È»¹¿ÉÒÔ,ÅäÖÃÈçÏÂ:
Õâ¸ö´úÀíµÚÒ»´Î·ÃÎʵϰ£¬ÐèÒªÌøµ½ËûµÄÖ÷Ò³£¬¹ý¸öÊ®¼¸ÃëÖоͿÉÒÔÌø×ªµ½OracleµÄ¹Ù·½ÍøÕ¾ÁË¡£
—————————————&md ......

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ