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

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¶ÔÓÚSunµÄ²úÆ·²ßÂÔ

Ô­·¢±íÓÚhttp://saharabear.javaeye.com
 ºÍhttp://www.haulynjason.net(Ó¢)
ͬʱ·¢±íÔÚÕâÀï.
´óÔ¼°ëÄêǰ£¬Oracle¹«Ë¾Ðû²¼£¬ËüÏëÊÕ¹ºSun£¬×òÌìµÄʱºò,Oracle¹«Ë¾Ðû²¼Íê³É¶ÔSun΢ϵͳµÄÊÕ¹º¡£×÷ΪJava³ÌÐòÔ±£¬ÎÒÃÇ´ó¼Ò¶¼·Ç³£¹Ø
ÐĵÄÊÇSun²úÆ·£¬°üÀ¨Java£¬Netbeans£¬Glassfish£¬Solaris/
OpenSolaris£¬OpenOffice£¬ ......

ORACLEÎﻯÊÓͼ ¶¨Î»µ¼ÖÂÎﻯÊÓͼÎÞ·¨¿ìËÙˢеÄÔ­Òò


ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......

C# µ÷ÓÃOracle ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ ʵÀý

1. ÔÚoracle Ï´´½¨±í
     t_user(
        ID varchar(20),
        Name varchar(20)
       )
 2.  Ìí¼ÓÊý¾Ý 
         &nb ......

OracleÊý¾ÝÎļþÇ¨ÒÆÖª¶àÉÙ£¿

±¾ÈËÒÔǰÕûÀíµÄÊý¾Ý¿âÎļþÇ¨ÒÆ¹ý³Ì£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú
1¡¢sqlplus "sys/sys@·þÎñÃû as sysdba"
 
2¡¢Ð޸ĿØÖÆÎļþ:
 
    alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
 'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\my ......

Oracle ÈÕÆÚʱ¼äº¯ÊýµÄÓ÷¨

   TO_DATE¸ñʽ 
Day: 
dd number 12 
dy abbreviated fri 
day spelled out friday 
ddspth spelled out, ordinal twelfth 
Month: 
mm number 03 
mon abbreviated mar 
month spelled out march 
Year: 
yy two digits 98  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ