Oracle°´×Ö·û½ØÈ¡×Ö·û´®º¯Êý
ÊäÈë²ÎÊý£ºstr ——Òª½ØÈ¡µÄ×Ö·û´®, ch——Òª²éÕÒµÄ×Ö·û´®
½ØÈ¡ch֮ǰ£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, 0, instr(str, ch) - 1)
½ØÈ¡chÖ®ºó£¨²»°üÀ¨ch£©µÄ×Ö·û´®£º substr(str, , instr(str, ch) + 1, length(str))
Ïà¹ØÎĵµ£º
ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢ ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1) VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......
Èý¡¢ PL/SQL³ÌÐòµ¥Ôª
1¡¢ÎÞÂÛÊǵ¥¶ÀµÄ¹ý³Ì/º¯Êý£¬»¹ÊÇ°üÖеĹý³Ì/º¯Êý£¬¶¼Í³³ÆΪ×Ó³ÌÐò¡£
2¡¢¹ý³Ì
1) Òì³£´¦Àí²¿·ÖÊÇ¿ÉÑ¡µÄ¡£
2) ¹ý³ÌÃûÓ¦¸ÃÓö¯´Ê£¬ÒòΪ¹ý³Ìͨ³£ÊÇÖ´ÐÐijÖÖ¶¯×÷¡£¹ý³Ì²¢²»Ò»¶¨¾ßÓвÎÊý¡£µ±´ ......
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 Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
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 ......