´®ÐÐfactor oracle , Àà ac
#include"stdio.h"
#include"math.h"
#include"iostream"
//#include"assert.h"
using namespace std;
//#include"conio.h"
//#include"io.h"
#define FAIL -1
#define Init 0
#define N 10101000
#define M 1010
#define ML 11111
#define AS 128
#define INF (int)((unsigned int)(-1)>>2)
#define _max(a,b) (a>b?a:b)
#define _min(a,b) (a<b?a:b)
long lrs[N]={0};
long bk[N]={0};
long belong[N]={0};
int cac[ML][M]={0};
int trans[AS][ML];
long m,n,ml0;
char p[N];
inline int LengthCommonSuffix(int p1, int p2)
{
if (p2 == bk[p1]) return lrs[p1];
while (bk[p1] != bk[p2])
p2 = bk[p2];
return _min(lrs[p1], lrs[p2]);
}
inline int LengthRepeatedSuffix(int p1, int s)
{
if (s == Init) return 0;
return LengthCommonSuffix(p1, s - 1) + 1;
}
void Oracle_on_line(char *p, int n)
{
void Analy(int,int,int);
int k, s, j, u;
char c;
for(j = 0; j < AS;j++)
for(k = 0;k < ML;k++)
trans[j][k]=FAIL;
memset(cac, 0, sizeof cac);
memset(lrs, 0, sizeof lrs);
memset( bk, 0, sizeof bk);
bk[Init] = FAIL;
for (j = 0; j < n; j++) {
c = p[j];
if(belong[j]==0)
trans[c][j] = j + 1;
u = j;
k = bk[j];
//assert(k<ml0);
while (k > FAIL && trans[c][k] == FAIL)
{
if(belong[j]==0)
trans[c][k] = j + 1;
u = k;
k = bk[k];
}
 
Ïà¹ØÎĵµ£º
Oracle±Ê¼Ç
l ¹ØÓÚTRUNCº¯Êý
SELECT
RELATED_ID ,
DOC_ID ,
CAT_ID ,
CAT_CODE ,
RELEASE_DATE ,
&n ......
Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý; ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
µ±Ç°Èκΰ汾µÄORACLE¿Í»§¶ËÔÚÈκΰ汾µÄWINDOWS7É϶¼²»ÄÜÕý³£Íê³É°²×°¡£
Ö÷ÒªÊÇÒòΪORACLE°²×°µÄÏȾöÌõ¼þÀï²Ù×÷ϵͳ°æ±¾²»·ûºÏ£¬µ«ÊÇÕâ¸öÒÉÎÊ¿ÉÒÔÐÞ¸Ärefhost.xml´¦Àí£¬ ¾ßÌåÊÇÔÚrefhost.xmlÖÐÌí¼Ó
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
& ......
ÔÚORACLEÖиø±í¡¢ÁÐÔö¼Ó×¢ÊÍÒÔ¼°¶ÁȡעÊÍ
1¡¢¸ø±íÌî¼Ó×¢ÊÍ£ºSQL>comment on table ±íÃû is '±í×¢ÊÍ";
2¡¢¸øÁмÓ×¢ÊÍ£ºSQL>comment on column ±í.ÁÐ is 'ÁÐ×¢ÊÍ';
3¡¢¶ÁÈ¡±í×¢ÊÍ£ºSQL>select * from user_tab_comments where comments is not null;
4¡¢¶ÁÈ¡ÁÐ×¢ÊÍ£ºSQL>select * from user_col_commnents wh ......
Oracle ´¥·¢Æ÷ÓÐÓï¾ä¼¶´¥·¢Æ÷ºÍÐм¶´¥·¢Æ÷
Óï¾ä¼¶´¥·¢Æ÷ µ±É¾³ý²¿ÃűíÖеIJ¿ÃźÅʱ£¬Í¬Ê±É¾³ýµôÔ±¹¤±íÖв¿ÃźÅΪ£ºold.deptnoµÄ¼Ç¼
create or replace trigger del_dept_id
after delete on dept
for each row
begin
delete from emp where deptno=:old.deptno;
end;
µ±Íù²¿Ãűí²åÈëʱ£¬Í¬Ê±ÔÚÔ±¹¤±íÖ ......