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

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  
);   
/*==========²é


Ïà¹ØÎĵµ£º

OracleÒì³£ÎÊÌâ½â¾ö·½°¸


1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔ­ÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
 ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ: 
 (1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
 (2) ½«"±¾µØ ......

LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplus

LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......

OracleÊý¾Ý¿âÉè¼Æ

Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔÇ°²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
 ¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......

ÈçºÎÔÚoracleÖе¼Èëµ¼³ödmpÊý¾Ý¿âÎļþ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......

oracleÊý×Ö×Ö¶ÎÅжÏ

select nvl2(replace(translate('69584.00.00','.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber from dual;
select id,nvl2(replace(translate(id,'.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber
from tbl2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ