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

Oracle°´×Ö·û½ØÈ¡×Ö·û´®º¯Êý

ÊäÈë²ÎÊý£ºstr ——Òª½ØÈ¡µÄ×Ö·û´®,  ch——Òª²éÕÒµÄ×Ö·û´®
½ØÈ¡ch֮ǰ£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, 0, instr(str, ch) - 1)
½ØÈ¡chÖ®ºó£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, , instr(str, ch) + 1, length(str))


Ïà¹ØÎĵµ£º

ORACLE¸´Ï°(Ò»)

ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢     ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1)        VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......

ORACLE¸´Ï°(¶þ)

Èý¡¢     PL/SQL³ÌÐòµ¥Ôª
1¡¢ÎÞÂÛÊǵ¥¶ÀµÄ¹ý³Ì/º¯Êý£¬»¹ÊÇ°üÖеĹý³Ì/º¯Êý£¬¶¼Í³³ÆΪ×Ó³ÌÐò¡£
2¡¢¹ý³Ì
 
1)       Òì³£´¦Àí²¿·ÖÊÇ¿ÉÑ¡µÄ¡£
2)       ¹ý³ÌÃûÓ¦¸ÃÓö¯´Ê£¬ÒòΪ¹ý³Ìͨ³£ÊÇÖ´ÐÐijÖÖ¶¯×÷¡£¹ý³Ì²¢²»Ò»¶¨¾ßÓвÎÊý¡£µ±´ ......

oracle dg µÄ»ù±¾ÃüÁî

1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
 select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
 select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
 alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØϵ

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØϵ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......

ʹÓÃJavaµ÷ÓÃOracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÀý

Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
1¡¢½¨Á¢´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
2¡¢ÏàÓ¦µÄJAVA³ÌÐò
import java.sql.*;
import java.io.OutputStream;
import java.io.Writer;
import java.sq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ