Oracle ʹÓñí×ܽá
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varchar2(20) not null,
True_name varchar2(20),
Email_address varchar2(50) not null, --Ψһ
Password_question varchar2(50) not null,
Password_anwser varchar2(50) not null,
Status char(1), --ĬÈÏÊÇ1£¬È¡Öµ0»ò1
Customer_level char(1), --ĬÈÏÊÇ1£¬È¡Öµ1£¬2£¬3
Score number(6),
Register_date date, --ĬÈÏΪϵͳʱ¼ä
Login_time timestamp,
Login_count number(6),
Login_ip char(6)
);
/*===========´´½¨Orders±í==========*/
create table Orders
(
Order_id varchar2(10) not null,
Order_Customer_id number(6) not null,
Order_date date not null,
Order_price number not null
);
/*==========²é
Ïà¹ØÎĵµ£º
http://tianzt.blog.51cto.com/459544/171759 ½ö½ö¹©×Ô¼ºÑ§Ï°Ö®ÓÃ
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3 ......
alter table µÄ¹¦ÄÜÊÇÐ޸ıí¸ñ¡£°üÀ¨ÖØÃûÃü£¬¼Ó¼õ×Ö¶Î,ÐÞ¸Ä×Ö¶ÎÀàÐͺʹóС£¬´¦Àí Ô¼ÊøµÈµÈ¡£±¾Àý×ÓÖ®´¦Àí±íÃûºÍ×ֶΣ¬´úÂëÈçÏ£º
create table liu(a varchar2(20),b number(2))
alter table liu rename to jin
rename jin to cai
alter table cai add c varchar2(30)
alter table cai add (d varchar2(3 ......
1)µ¼ÈëoracleÊý¾Ý¿âÎļþ.dmpʱ³öÏÖ´íÎó
imp PERSONNEL_MANAGE/MWQ@MIS file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied̞:
¿ÚÁî:
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: in ......
oracleÄÚÖóÌÐò°ü
STANDARDºÍDBMS_STANDARD ¶¨ÒåºÍÀ©Õ¹PL/SQLÓïÑÔ»·¾³
DBMS_ALERT Ö§³ÖÊý¾Ý¿âʼþµÄÒ첽֪ͨ
DBMS_APPLICATION_INFO ÔÊÐíΪ¸ú×ÙÄ¿µÄ¶ø×¢²áÓ¦ÓóÌÐò
DBMS_AQ&DBMS_AQADM ¹ÜÀíoracle advanced queuingÑ¡¼þ
DBMS_DEFER¡¢DBMS_DEFER_SYSºÍDBMS_DEFER_QUERY ÔÊÐí¹¹½¨ºÍ¹ÜÀíÑÓ³ÙµÄÔ¶³Ì¹ý³Ìµ÷ÓÃ
DBMS_DDL ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......