Oracle ʱ¼ä±È½Ï
ÔÚWeb¿ª·¢ÖУ¬´ÓÒ³Ãæ×¢ÈëµÄʱ¼äÒ»°ãΪStringÀàÐÍ£¬ÔõôȥºÍOracleÖеÄʱ¼ä½øÐбȽÏ
·½·¨£º
String Time£»
.......// Ò»¶Î´úÂë
¼ÙÉèTimeÎªÒ³Ãæ×¢ÈëStringÀàÐÍÊý¾Ý£¬Îª"2010-10-10 12:02:01"¡£
ÔÚдSQLÓï¾äʱ
String sql="select from mytable where table_time > to_date('"+Time+"','yyyy-mm-dd
hh24:mi:ss')"
;
Èç¹ûÏȰÑTime ת»»³É Date ÀàÐÍ£¬ÔÙÈ¥±È½Ï£¬»á±¨´í¡£
Ïà¹ØÎĵµ£º
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
Q]ÈçºÎ¿ªÆô/¹Ø±Õ¹éµµ
[A]Èç¹û¿ªÆô¹éµµ£¬Çë±£Ö¤log_archive_start=true¿ªÆô×Ô¶¯¹éµµ£¬·ñÔòÖ»ÄÜÊÖ¹¤¹éµµ£¬Èç¹ûÊǹرÕÁ˹鵵£¬ÔòÉèÖøòÎÊýΪfalse
×¢Ò⣺Èç¹ûÊÇOPS/RAC»·¾³£¬ÐèÒªÏȰÑparallel_server = true×¢Ê͵ô£¬È»ºóÖ´ÐÐÈçϲ½Ö裬×îºóÓÃÕâ¸ö²ÎÊýÖØÐÂÆô¶¯
1¡¢¿ªÆô¹éµµ
a. ¹Ø±ÕÊý¾Ý¿âshutdown im ......
--´´½¨ÐòÁÐ
create sequence innerid
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20
order;
--´´½¨±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
select * from users;
insert into users values( ......
ÓÃoracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÏÖ·µ»Ø½á¹û¼¯²¢ÊµÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Óû§´«Èë²ÎÊý
Ò»ÏÂÊÇת±ðÈ˵ĴúÂë
--°üÉùÃ÷
create or replace package p_page is
-- Author : PHARAOHS
-- Created : 2006-4-30 14:14:14
-- Purpose : ·ÖÒ³¹ý³Ì
TYPE type_cur IS REF CURSOR; &n ......
ORACLEÔÚ¹ØÏµÊý¾Ý¿âÍ⣬ÈÚÈëÁËÃæÏò¶ÔÏóµÄÔªËØ£¬±ÈÈç¿ÉÒÔ´´½¨type£¬typeÖ®¼ä¿ÉÒԼ̳У¬type¿ÉÒÔ´ø¹¹Ô캯Êý¡¢ÅÅÐòº¯Êý¡¢¸÷ÖÖ¸÷ÑùµÄ³ÉÔ±º¯Êý¡¢´æ´¢¹ý³ÌµÈµÈ¡£
¶ÔÏó±íÊÇÖ¸¸Ã±íµÄÒ»ÐоÍÊÇÒ»¸ö¶ÔÏó£¬ÓÐÒ»¸öOID(object ID)£¬¶ÔÏó±íÖ®¼äûÓÐÖ÷Íâ¼ü¹ØÁªµÄ¸ÅÄΪÁËÌåÏÖÕâ²ã¹ØÏµ£¬oracleÖÐÓÃÁËref¶ÔÏóÀ´ÊµÏÖ¡£
ÏÂÃæÀý×Ó£¬´´½¨Ò»¸öµ ......
1¡¢ORA£12541£ºTNS£ºÃ»ÓмàÌýÆ÷ ¡¡¡¡
ÔÒò£ºÃ»ÓÐÆô¶¯¼àÌýÆ÷»òÕß¼àÌýÆ÷Ë𻵡£Èç¹ûÊÇǰÕߣ¬Ê¹ÓÃÃüÁînet start OracleOraHome81TNSListener£¨Ãû×Ö¿ÉÄÜÓгöÈ룩¼´¿É£»Èç¹ûÊǺóÕߣ¬ÔòʹÓÓNet8 Configuration Assistant”¹¤¾ßÏòµ¼Ö®“¼àÌý³ÌÐòÅäÖÔÔö¼ÓÒ»¸ö¼àÌýÆ÷¼´¿É£¨»ù±¾²» ......