ORACLE´Ó9201Éý¼¶µ½9208ÎÊÌâ
ORACLE´Ó9201Éý¼¶µ½9208Ö®ºó »·¾³±äÁ¿ÖÐORACLE_HOMEûÓÐÉèÖà ÊÖ¹¤Ìí¼Óºó ϵͳ·þÎñÀïËùÓÐORACLE·þÎñ¶¼Æð²»À´ ÃüÁîÐÐÀïÊäÈë EXP»òÕßLSNRCTL±¨ÌáʾÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ ÇëÎÊÊÇʲôÎÊÌâ°¡ ¼± лл´ó¼ÒÁË
ÒýÓà ÄãµÄÉý¼¶Êdzɹ¦Íê³ÉÁËÂ𣿠²¹¶¡ÊÇÌáʾÉý¼¶³É¹¦ SQL code: --¹ØÕìÌý connect /as sysdba; lsnrctl stop; --¹Ø±ÕÊý¾Ý¿â sqlplus /nolog; sql> connect /as sysdba; sql> shutdown immediate; --Æô¶¯Êý¾Ý¿â sql> startup; --Æô¶¯ÕìÌý lsnrctl start; ÒýÓà SQL code--¹ØÕìÌýconnect/as sysdba; lsnrctl stop;--¹Ø±ÕÊý¾Ý¿âsqlplus/nolog; sql> connect/as sysdba; sql>shutdown immediate;--Æô¶¯Êý¾Ý¿âsql> startup;--Æô¶¯ÕìÌýlsnrctl start; ÊÇÔÚWINDOWSÏ嵀 £¬ÏÖÔÚÊÇËùÓÐORACLEµÄ·þÎñ¶¼´ò²»¿ª£¬¶øÇÒconn /as sysdba±¨CONN²»ÊÇÄÚ²¿»òÕßÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¬LSNRCTL,SQLPLUS /NOLOG¶¼±¨ÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ ÇóÖú°¡ ÇóÖú Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£ È磺D:\oracle\ora92\binÒýÓà Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£ È磺D:\oracle\ora92\bin ÔÚBINĿ¼ÏÂÃæ CONN /AS SYSDBA Ò²Ê
Ïà¹ØÎÊ´ð£º
Conn.phpÒ³Ãæ£º [code=php] <?php $con = oci_connect("finaltest","finaltestpw","(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ( ......
orcle Óï¾ä create table book1(name, price) as select book_name, price form book; ¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
Oracle £ºselect grbh from com.eway.vo.Zjxx zj where to_char(zj.jbsj,'yyyymm')='"+ sj + "' ÆäÖÐ sjÊÇ×Ö·û´®²ÎÊý ÏÖÔÚÏë°ÑÉÏÃæµÄSQLÓï¾äת»»ÎªMysqlµÄ Ö÷ÒªÊÇʱ¼ä´«Èë ......
--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM BEFORE UPDATE ON TSTK_IMPORTITEM FOR EACH ROW DECLARE VAR_LIBGOODCOUNT NUMERIC(12,2); BEGIN
......
create or replace function GetWorkBeginTime() return date is myDate date; begin myDate := trunc(sysdate-1)+8/24; return myDate; end; ......