oracle½«×Ö·û´®×ª»»Îª12СʱÓë24Ð¡Ê±ÖÆ£º
oracle½«×Ö·û´®×ª»»Îª12СʱÓë24Ð¡Ê±ÖÆ£º
--12Ð¡Ê±ÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24Ð¡Ê±ÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh24:mi:ss');
Ïà¹ØÎĵµ£º
½ñÌì¼ÌÐøÊÔÑéÊ®·ÖÖÓ¿ÉÒÔ¸Éʲô£¬Ñ¡È¡Á˶ÔOracleË÷ÒýµÄ½éÉÜ£¬½á¹ûÈçÏ£º
´ÓgoogleÉÏѰÕÒ×ÊÁÏ£º1:15Ãë¡£
ÔĶÁ¸ÅÊö²¿·Ö£º3:15Ãë¡£
OracleµÄË÷ÒýÖ÷Òª°üº¬Á½ÀࣺBTreeºÍλͼË÷Òý¡£Ä¬ÈÏÇé¿öÏ´ó¶àʹÓÃBtreeË÷Òý£¬¸ÃË÷Òý¾ÍÊÇͨ³£Ëù¼û ΨһË÷Òý¡¢¾Û´ØË÷ÒýµÈµÈ£¬BtreeÓÃÔÚOLTP£¬¼Ó¿ì²éѯËÙ¶È¡£Î»Í¼Ë÷ÒýÊÇOracleµÄ±È½ÏÒýÈËעĿµÄµØ ......
ÔÚÏµÍ³Ç¨ÒÆ»òÉý¼¶µÄʱºò£¬¿ÉÄÜ»áÓÐoracle JOBÇ¨ÒÆµÄÐèÇó¡£
¶ÔÓÚ10GµÄϵͳºÃ˵¡£¿ÉÒÔÓÃÏÂÃæµÄ°ì·¨£º
userid="/ as sysdba"
directory=EXP_DIR
dumpfile=expdp_job.dmp
logfile=expdp_job.log
include=job
¶ÔÓÚ9i¿âºÃÏóÓе㸴ÔÓ£º
¿ÉÒÔÓÃÏÂÃæµÄ°ì·¨¡£
set echo on
conn sm ---------->JOBËùÔÚµÄÓû§Ãû¡£
set se ......
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......
Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE USER DAVE IDENTIFIED BY pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 5m ON users;
1.2 ÐÞ¸ÄÓû§
......
ºÜ¾Ã²»ÓõÄoralceÊý¾Ý¿â£¬Èç¹ûÍü¼ÇÁËÃÜÂ룬¿ÉÒÔÕâÑù½â¾ö£º
Èç¹ûûÓÐÉèÖû·¾³±äÁ¿£¬ ȥĿ¼C:\oracle\product\10.2.0\db_1\BIN Ö´ÐÐÒÔÏÂÃüÁ
C:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 22 16:00:18
2010 Copyright (c) 1982, 2005, Oracle. All ri ......