³£ÓõÄ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;
Ïà¹ØÎĵµ£º
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û
DD ÔÂÖеĵڼ¸Ìì
DDD ÄêÖеĵڼ¸Ìì
DY ÌìµÄ¼òдÃû
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ
IYYY ISO±ê×¼µÄËÄλÄê·Ý
YYYY ËÄλÄê·Ý
YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»
HH Сʱ£¬°´12Ð¡Ê ......
Ò».˵Ã÷
oracle µÄexp/impÃüÁîÓÃÓÚʵÏÖ¶ÔÊý¾Ý¿âµÄµ¼³ö/µ¼Èë²Ù×÷;
expÃüÁîÓÃÓÚ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öÖÁ±¾µØ,Éú³ÉdmpÎļþ;
impÃüÁîÓÃÓڰѱ¾µØµÄÊý¾Ý¿âdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶³ÌµÄOracleÊý¾Ý¿âÖС£
¶þ.Óï·¨
¿ÉÒÔͨ¹ýÔÚÃüÁîÐÐÊäÈë imp help=y »ñÈ¡impµÄÓï·¨ÐÅÏ¢:
========= ......
֮ǰÏîÄ¿ÓÐÓõ½µÄһЩµ¼ÈëºÍµ¼³ö£¬Ê±ÖÁÒѾÃÕûÀíһϣ¬×ö¸ö¼ÇºÅ
µ¼ÈëÎļþ£º
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 ......
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 ......
1¡¢ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM IN NUMBER,
ED_NUM IN NUMBER
)
IS
BEGIN
declare
......