oracleÖØÔØ²Ù×÷·ûµÄÀý×Ó
ת×Ô£ºhttp://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_6004.htm
Creating User-Defined Operators: Example
This example creates a very simple functional implementation of equality and then creates an operator that uses the function:
CREATE FUNCTION eq_f(a VARCHAR2, b VARCHAR2) RETURN NUMBER AS
BEGIN
IF a = b THEN RETURN 1;
ELSE RETURN 0;
END IF;
END;
/
CREATE OPERATOR eq_op
BINDING (VARCHAR2, VARCHAR2)
RETURN NUMBER
USING eq_f;
Ïà¹ØÎĵµ£º
oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189 ......
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ºÍhttp://www.haulynjason.net(Ó¢)
ͬʱ·¢±íÔÚÕâÀï.
´óÔ¼°ëÄêǰ£¬Oracle¹«Ë¾Ðû²¼£¬ËüÏëÊÕ¹ºSun£¬×òÌìµÄʱºò,Oracle¹«Ë¾Ðû²¼Íê³É¶ÔSun΢ϵͳµÄÊÕ¹º¡£×÷ΪJava³ÌÐòÔ±£¬ÎÒÃÇ´ó¼Ò¶¼·Ç³£¹Ø
ÐĵÄÊÇSun²úÆ·£¬°üÀ¨Java£¬Netbeans£¬Glassfish£¬Solaris/
OpenSolaris£¬OpenOffice£¬ ......
http://blog.csdn.net/XIAOHUI_LIAO/archive/2007/08/27/1759990.aspx
create materialized view [view_name]
refresh [fast|complete|force]
[
on [commit|demand] |
start with (start_time) next (next_time)
]
as
{´´½¨ÎﻯÊÓͼÓõIJéѯÓï¾ä}
ÒÔÉÏÊÇ ......
1. ÔÚoracle Ï´´½¨±í
t_user(
ID varchar(20),
Name varchar(20)
)
2. Ìí¼ÓÊý¾Ý
&nb ......
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......