oracle ÐòÑÔ
¹ØÓÚдÐò£¬È˵ÄÒ»±²×ÓÓкܶàµÄµÚÒ»´Î£¬¸øÊéдÐò£¬¶ÔÎÒÀ´ËµÒ²ÊǵÚÒ»´Î£¬¶øÇÒÊǺÜÄѵõÚÒ»´Î¡£Ò»°ãÈËÊéдÍêÁË£¬¶¼»áÕÒÒ»¸öÓеãÃûÆøµÄÈËÀ´ÎªÖ®×öÐò£¬ÔÚÕâÀïÎÒÖ»ÄܲÑÀ¢Ò»ÏÂ
¡£ÒòΪÎÒ×ܾõµÃ¸øÒ»±¾ÊéдÐòµÄÈË£¬ÔÚÊéµÄÄÚÈÝ·½Ã棬ÖÁÉÙÒ²µÃÊÇ°ë¸öר¼Ò£¬È»ºó²ÅÄÜÓз¢ÑÔȨ¡£¶ø±¾ÈËÔÚoracle·½Ã棬Á¬°ëÍ°Ë®µÄËã²»ÉÏ¡£ÕâÒ»´ÎÒ²¿ÖÅÂÖ»ÄÜÊDZ»oracleÒ»°ÑÁË
¡£
¹ØÓÚдÊéÕâ»ØÊ£¬ÎÒÏàÐÅÔÚÕâ¸öʱ´ú£¬ºÜ¶àÈ˶¼Ïëд£¬»òÕßÒѾдÁË¡£µ«ÊÇÏëÒ²ºÃ£¬ÒѾдÁËÒ²ºÃ£¬ÕæÕýÄÜ°ÑÊéдºÃ¿ÖÅÂÒ²²»¶à¡£µ«ÊÇÎÒÃÇÖªµÀСÕÔͬ־µÄµÚÒ»±¾Ê飬ÎÞÂÛÊÇÊг¡»¹ÊǶÁÕß·´À¡¶¼ÊǷdz£²»´íµÄ¡£ÏúÁ¿Ò²ÊÇÔÚͬÀàÊé¼®Öкܿ¿Ç°µÄ¡£µ±È»£¬ËµÊéµÄºÃÓë²»ºÃ£¬ÆäʵҲÊÇÒ»¸ö¼ûÈʼûÖǵÄÎÊÌâ¡£ÎÒÃÇÖªµÀ£¬ÔÚÏÖÔÚÕâ¸öʱ´ú£¬³öÒ»±¾Êé²»ÄÑ£¬ÄѵÄÊÇÒª³öÒ»±¾ºÃÊé¡£ÖÁÓÚСÕÔͬ־µÄµÚ¶þÊéºÃÓë²»ºÃ£¬ÏÖÔÚ»¹²»ÊǸǹ׶¨ÂÛµÄʱºò¡£
¹ØÓÚÔõôѧºÃoracle£¿ËµËü²»ÄÑÒ²ÄÑ¡£Ò»¸öÐÂÊÖ£¬Èç¹ûÔÚoracleÁìÓòûÓиöÈýÎåÄêʱ¼äµÄרÐÄŬÁ¦£¬¿ÖÅÂÊÇÄѳÉÆøºòµÄ¡£Õæ¿ÉνÊDz»¾Ò»·¬±ù˪¿à£¬ÄĵÃ÷»¨·ÅÇåÏ㡣˵ÄÑÒ²²»ÄÑ£¬Ä³ÈËÔø¾Ëµ¹ý£¬ÊÀÉÏÎÞÄÑÊ£¬Ö»Òª¿ÏÅʵÇÂï¡£Æäʵ¼¼ÊõÕâ¸ö¶«Î÷£¬²»¹ÜÊÇoracle»¹ÊÇjava»òÕßÊDZðµÄ£¬µÀÀí¶¼ÊÇÒ»Ñù£¬ÄÇÅÂÄãÊÇÓÞ±¿£¬Ö»ÒªÅ¬Á¦¡¢×¨×¢£¬Äã¾ÍÄܵõ½ÄãÏëÒª¡£ÒòΪ¼¼ÊõÊÇѧÎÊ£¬Ö»ÒªÄã²»ÆÛÆËû£¬ËûÊDz»¿ÉÄÜÆÛÆÄãµÄ£¬¼ÈÈ»Ä㸶³öÁË£¬µ±È»¾Í»áÓлر¨¡£ÕýÈçÎäÏÁС˵ÖдóÏÀ£¬Ã¿Ò»¸ö¾ø¶¥¸ßÊÖ¶¼ÊÇÎÞÊý¸öµ¥µ÷¡¢¿ÝÔï¡¢ÎÞÁĵĹý³ÌÖгɳ¤ÆðÀ´µÄ¡£ËäÈ»ÄÇÖ»ÊÇÒÕÊõ£¬µ«ÊÇÉú»îµÄµÀÀíÊǶ¼Ò»ÑùµÄ¡£Ð¡ÕÔͬ־ҲÊǾÀúÁË8Äê¶àµÄ·çÓêÄ¥í£¬ÖÕÓÚÐ޳ɽñÌìµÄÕý¹û¡£ÔÚoracle·½ÃæÒ²ËãÊǸö·ÇÖøÃûµÄ¸ßÊÖ£¬»òÕßר¼Ò¡£Èç¹ûÏëÔÚoracle·½ÃæÓÐËùµÄ·¢Õ¹µÄÅóÓÑ£¬ÎÞÂÛÊǼ¼Êõ±¾Éí»¹ÊÇ·¢Õ¹·½Ïò¶¼²»·ÁСÕÔͬ־¶à×ö½»Á÷¡£
˳±ãÔÙ˵˵СÕÔÕâ¸öÈ˱¾Éí£¬ËäȻҲÓкܶàʱºòÇÅÇéµÄºÜ£¬µ«ÊÇ×ܵÄÀ´Ëµ»¹ËãÊÇÒ»¸öºÃÈË¡£×öÊÂÇé×î´óµÄÌصã¾ÍÊÇÖ´ÖøºÍÈÏÕ棬ÔÚ¼¼ÊõÁìÓòÒ²ËãÊǸöÖµµÃѧϰµÄÈË¡£±¾ÈËÒ»Ö±ÒÔºó
¾ÍÓиö¹Ûµã£¬ÀÏʦºÍÒ½ÉúÕâÁ½Ö°Òµ£¬ËäÈ»¶¼ÐèҪѧÀú¡¢ÄÜÁ¦¡¢ÖªÊ¶£¬µ«ÊÇÊ×ÏÈÐèÒªµÄ»¹ÊÇÊÇÈËÆ·¡£Ð´ÊéÒ²Ò»Ñù£¬ÎÄÕÂǧ¹ÅÊ£¬Ò»³¯ÓÀÁ÷´«£¬Ð´³öÀ´Êé¸ü¼ÓÁËÁË£¬Ç§¹ÅÁ÷´«£¬Èç¹ûÈË
Æ·²»ºÃ£¬Ð´³öÀ´µÄ¶«Î÷¿ÖÅÂÒ²Ö»ÄÜÒÅ»öǧÄê¡£ËùÒÔ±¾È˾õµÃСÕÔͬ־µÄÊéÂ½èÒ»¾äÁ÷ÐÐÓïÀ´Ëµ£¬Õâ¸ö¿ÉÒÔÓУ¡
˵ÁËÕâô¶à£¬ËµËµÕâ±¾Êé°É£¬ÓÉÓÚʱ¼ä¹Øϵ£¬±¾ÈËÒ²Ö»ÊÇ´ó¸Åä¯ÀÀÁËÒ»±é£¬¸ÐÊÜ×îÉîµÄÊÇ£¬ÊéÉÏ˵ºÜ¶àÎÊÌâºÜ¶à¶¼ÊÇÎÒÔÚ¿ª·¢¹ý³ÌÖÐÔø¾¼û¹ý»òÕßÇ×ÉíÓöµ½¹ýµÄÎÊÌâ¡£±¾ÈËÒòΪ´ÓÊ¿ª·¢ºÃ¶àÄêÁË£¬×ÔÈ»ÔÚora
Ïà¹ØÎĵµ£º
1.ÔÚAÓû§ÏÂÊÚȨ“ÉÌ»§ÐÅÏ¢±í”¸øBÓû§
grant all on TBL_INF_MCHNT_INF to B;
commit;
2.ÔÚBÓû§Ï½¨Á¢Í¬Òå´Ê
create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;
3. ²éѯÊý¾Ý¿âËùÓÐͬÒå´Êselect * from sys.synonyms ......
1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date i ......
SQL> create table test2(s1 varchar(10),s2 varchar2(10));
±íÒÑ´´½¨¡£
SQL> insert into test2 values('11','111');
ÒÑ´´½¨ 1 ÐС£
SQL> insert into test2 values('22','222');
ÒÑ´´½¨ 1 ÐС£
SQL> CREATE OR REPLACE PACKAGE test222 AS
2 TYPE t_cursor IS REF CURSOR;
3 procedure p_tes ......
Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊ ......