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

³£ÓõÄORACLE PLSQL¹ÜÀíÃüÁî

³£ÓõÄORACLE PL/SQL¹ÜÀíÃüÁî
        ÊìϤORACLE¹ÜÀíµÄÒ»¶¨¶ÔÕâЩÃüÁî²»»áİÉú£¬²»¹ý¶ÔÓÚÎÒÕâ¸ö¸Õ½Ó´¥ORACLE¹ÜÀíµÄÀ´Ëµ£¬»¹ÊÇÓбØÒª×öϼǼ£¬ÒÔ±ãËæÊ±²é¿´¡£
    Ò» µÇ¼SQLPLUS
    sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
    Èç:Óû§sys(ÃÜÂëΪ123)ÒÔsysdbaµÄ½ÇÉ«µÇ¼Êý¾Ý¿âORACL£¬ÎÒÃÇ¿ÉÒÔÊäÈ룺sqlplus sys/123@oracl as sysdba;
    ÕâÖֵǼ·½Ê½»áÖ±½Ó±©Â¶ÃÜÂ룬Èç¹ûÏëÒþ²ØÃÜÂ룬¿ÉÒÔÔÚ´ËÊ¡ÂÔÃÜÂëµÄÊäÈ룬È磺sqlplus sys@oracl as sysdba;»Ø³µÒÔºóORACLE»á¸ø³öÊäÈëÃÜÂëµÄÌáʾ·û¡£
    µÇ¼ÒÔºóÈç¹ûÏëÇл»ÆäËûµÄÓû§£¬¿ÉÒÔÖ±½ÓʹÓÃconnect ÃüÁî,È磺connect user2/password@oracl as sysdba,ͬÉÏÒ»Ñù£¬¿ÉÒÔ½«ÃÜÂë·Ö¿ªÊäÈë¡£
    ¶þ Í˳öSQLPLUS
    quit£»
    Èý ´´½¨Óû§
    create userÓû§Ãûidentified byÃÜÂë;
    È磺´´½¨Óû§CKSP£¬ÃÜÂëΪ123: create user cksp identified by 123;
    ËÄ ¸øÓû§·ÖÅä½ÇÉ«»òȨÏÞ
    grant *** to ***;
    È磺¸ø¸Õ²ÅµÄÓû§·ÖÅä½ÇÉ«DBA:grant dba to cksp;
    ·ÖÅäcreate tableȨÏÞ£ºgrant
    Îå ɾ³ýÓû§
    drop userÓû§[cascade];
    ÆäÖÐcascadeÊÇ¿ÉÑ¡µÄ£¬Èç¹ûÊäÈëÁË£¬Ôò±íʾɾ³ý¸ÃÓû§¼°ËùÓÐÊý¾Ý¡£
    È磺ɾ³ýÉÏÃæ´´½¨µÄÓû§CKSP¼°ËûµÄËùÓÐÊý¾Ý£ºdrop user cksp cascade;


Ïà¹ØÎĵµ£º

Oracleʱ¼ä¼ÆËã

ÈÕÆÚ¸ñʽ²ÎÊý   º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY    ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD   ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW   ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......

ʹÓÃOracle µÄ imp ,exp ÃüÁîʵÏÖÊý¾ÝµÄµ¼Èëµ¼³ö

Ò».˵Ã÷
   oracle µÄexp/impÃüÁîÓÃÓÚʵÏÖ¶ÔÊý¾Ý¿âµÄµ¼³ö/µ¼Èë²Ù×÷;
   expÃüÁîÓÃÓÚ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öÖÁ±¾µØ,Éú³ÉdmpÎļþ;
   impÃüÁîÓÃÓڰѱ¾µØµÄÊý¾Ý¿âdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶³ÌµÄOracleÊý¾Ý¿âÖС£
¶þ.Óï·¨
¿ÉÒÔͨ¹ýÔÚÃüÁîÐÐÊäÈë imp help=y »ñÈ¡impµÄÓï·¨ÐÅÏ¢:
========= ......

Oracle µÄһЩµ¼ÈëºÍµ¼³ö·½·¨

֮ǰÏîÄ¿ÓÐÓõ½µÄһЩµ¼ÈëºÍµ¼³ö£¬Ê±ÖÁÒѾÃÕûÀíһϣ¬×ö¸ö¼ÇºÅ
µ¼ÈëÎļþ£º
1. ÔÚij·¾¶ÏÂд¿ØÖÆÎļþ e:\testRegionControl.ctl £º
 load data
 infile  e:\region.txt
 truncate into table region
 fields terminated by X'09'
 TRAILING NULLCOLS
 (
 PPCC_ID&nbs ......

ORACLE NUMBERÀàÐÍÏê½â


1>.NUMBERÀàÐÍϸ½²£º
Oracle number datatype Óï·¨£ºNUMBER[(precision [, scale])]
¼ò³Æ£ºprecision --> p
      scale     --> s
NUMBER(p, s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+1 ......

oracle´æ´¢¹ý³Ì´úÂëʵÀý

1¡¢ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM        IN     NUMBER,
ED_NUM        IN     NUMBER
)
IS
BEGIN
declare
     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ