Oracle²ð·Ö×Ö·û´®º¯Êý
--¶¨ÒåÀàÐÍ
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2(4000);
--´´½¨º¯Êý
CREATE OR REPLACE FUNCTION f_stringsplit (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
RETURN ty_str_split PIPELINED
/*****
****×Ö·û´®²ð·Ö,Ï൱ÓÚjava.lang.StringÀàµÄsplit·½·¨
****×¢Òâ:ÐÂÔötypes:CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (100);
****´´½¨Õߣº
****ʱ¼ä£º
****ÕªÈ¡ÍøÂç×ÊÔ´
***/
IS
j INT := 0;
i INT := 1;
len INT := 0;
len1 INT := 0;
str VARCHAR2 (100);
BEGIN
len := LENGTH (p_str);
len1 := LENGTH (p_delimiter);
WHILE j < len
LOOP
j := INSTR (p_str, p_delimiter, i);
IF j = 0
THEN
j := len;
str := SUBSTR (p_str, i);
PIPE ROW (str);
IF i >= len
THEN
EXIT;
END IF;
ELSE
str := SUBSTR (p_str, i, j - i);
i := j + len1;
PIPE ROW (str);
END IF;
END LOOP;
RETURN;
END f_stringsplit;
--µ÷ÓÃ
select¡¡*¡¡from¡¡t
Ïà¹ØÎĵµ£º
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......
ÔÚWeb¿ª·¢ÖУ¬´ÓÒ³Ãæ×¢ÈëµÄʱ¼äÒ»°ãΪStringÀàÐÍ£¬ÔõôȥºÍOracleÖеÄʱ¼ä½øÐбȽÏ
·½·¨£º
String Time£»
.......// Ò»¶Î´úÂë
¼ÙÉèTimeÎªÒ³Ãæ×¢ÈëStringÀàÐÍÊý¾Ý£¬Îª"2010-10-10 12:02:01"¡£
ÔÚдSQLÓ ......
Linux/UnixÉÏ£¬OracleÊǶà¸ö½ø³ÌʵÏֵģ¬Ã¿Ò»¸öÖ÷Òªº¯Êý¶¼ÊÇÒ»¸ö½ø³Ì£»ÔÚWindowsÉÏ£¬ÔòÊÇÒ»¸öµ¥Ò»½ø³Ì£¬½ø³ÌÖаüº¬¶à¸öÏ̡߳£
Oracle°ÑһϵÁÐÎïÀíÎļþ£¬ÈçÊý¾ÝÎļþ(Data file)¡¢¿ØÖÆÎļþ(Control file)¡¢Áª»úÈÕÖ¾(Redo log file)¡¢²ÎÊýÎļþ(spfile or pfile)µÈÎïÀí½á¹¹¼°ÓëÖ®¶ÔÓ¦µÄÂß¼½á¹¹£¬Èç±í¿Õ¼ä(Tablespace)¡¢¶Î(Seg ......
#!/bin/ksh
#****************************************************************************
#
# (C) Copyright CPIC. 2008
#
# File name: check_db_alert.sh
# Project: Database Alerts Check
#
# Parameter : app_name -- name of db application(=ora ......
oracle dblink µÄÓ¦ÓÃ
url:http://blog.chinaunix.net/u/19820/showart_334013.html
1¡¢ÓÃdblinkÁ´½Óoracle
£¨1£©ÓëÆ½Ì¨Î޹صÄд·¨£º
create public database
link cdt connect to apps
identified by apps using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.205.100)(PORT = 15 ......