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

ÓëoracleÏà¹ØµÄһЩÃüÁî

1.µÇ½ϵͳÓû§
sqlplus È»ºóÊäÈëϵͳÓû§ÃûºÍÃÜÂë
µÇ½±ðµÄÓû§
conn Óû§Ãû/ÃÜÂë;
2.´´½¨±í¿Õ¼ä
create tablespace ¿Õ¼äÃû
datafile 'c:\¿Õ¼äÃû' size 15M --±í¿Õ¼äµÄ´æ·Å·¾¶,³õʼֵΪ15M
autoExtend on next 10M --¿Õ¼äµÄ×Ô¶¯Ôö³¤µÄÖµÊÇ10M
permanent online; --ÓÀ¾ÃʹÓÃ
3.´´½¨Óû§
create user shi --´´½¨Óû§ÃûΪshi
identified by scj --´´½¨ÃÜÂëΪscj
default tablespace ±í¿Õ¼äÃû --ĬÈϱí¿Õ¼äÃû
temporary tablespace temp --ÁÙʱ±í¿Õ¼äΪtemp
profile default --ÊÜprofileÎļþµÄÏÞÖÆ
quota unlimited on ±í¿Õ¼äÃû; --ÔÚ±í¿Õ¼äÏÂÃæ½¨±í²»ÊÜÏÞÖÆ
4.´´½¨½ÇÉ«
create role ½ÇÉ«Ãû identified by ÃÜÂë;
5.¸ø½ÇÉ«ÊÚȨ
grant create session to ½ÇÉ«Ãû£»--¸ø½ÇÉ«ÊÚÓè´´½¨»á»°µÄȨÏÞ
grant ½ÇÉ«Ãû to Óû§Ãû£» --°Ñ½ÇÉ«ÊÚÓèÓû§
6.¸øÓû§ÊÚÓèȨÏÞ
grant create session,resource to shi;--¸øshiÓû§ÊÚÓèËùÓÐȨÏÞ
grant create table to shi; --¸øshiÓû§ÊÚÓè´´½¨±íµÄȨÏÞ
7.select table_name from user_tables; ²ì¿´µ±Ç°Óû§ÏµÄËùÓбí
8.select tablespace_name from user_tablespaces; ²ì¿´µ±Ç°Óû§Ï嵀 ±í¿Õ¼ä
9.select username from dba_users;²ì¿´ËùÓÐÓû§Ãû³ÆÃüÁî ±ØÐëÓÃsys as sysdbaµÇ½
10.´´½¨±í
create table ±íÃû
(
id int not null,
name varchar2(20) not null
)tablespace ±í¿Õ¼äÃû --ËùÊôµÄ±í¿Õ¼ä
storage
(
initial 64K --±íµÄ³õʼֵ
minextents 1 --×îСÀ©Õ¹Öµ
maxextents unlimited --×î´óÀ©Õ¹Öµ
);
11.--Ϊusrs±íÌí¼ÓÖ÷¼üºÍË÷Òý
alter table users
add constraint pk primary key (ID);
12.ΪÒѾ­´´½¨users±íÌí¼ÓÍâ¼ü
alter table users
add constraint fk_roleid foreign key (roleid)
references role(role_id) on delete cascad; --ϱßдÖ÷±íµÄÁÐ
on delete cascadÊÇ´´½¨¼¶Áª
13.°ÑÁ½¸öÁÐÁ¬½ÓÆðÀ´
select concat(name,id) from ±íÃû£» --°ÑnameºÍidÁ¬½ÓÆðÀ´
14.½ØÈ¡×Ö·û´®
select column(name,'Àî') from ±íÃû£» --°ÑnameÖеġ®Àȥµô
15.ÔËÐÐÊÂÎñ֮ǰ±ØÐëд
set serveroutput on; --´ò¿ªÊäÈëÊä³ö£¨²»Ð´µÄ»°,´òÓ¡²»³öÐÅÏ¢£©
16.whileµÄÓ¦ÓÃ
declare --ÉùÃ÷²¿·Ö
ccc number:=1; --¸´Ö°
a number:=0;
begin --ÊÂÎñµÄ¿ªÊ¼
while ccc


Ïà¹ØÎĵµ£º

oracle»ù´¡ÈëÃŽ̲Ä

 
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
    [default value] [prima ......

ÔÚlinuxÉÏsilent°²×°oracle¼òÖ±ÊÇÒ»³¡Ø¬ÃÎ

 Parsing command line arguments:
    Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
        at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
        at oracle.net.ca.I ......

oracleÊý¾ÝÀàÐÍnumber

OracleʹÓñê×¼¡¢¿É±ä³¤¶ÈµÄÄÚ²¿¸ñʽÀ´´æ´¢Êý×Ö¡£Õâ¸öÄÚ²¿¸ñʽ¾«¶È¿ÉÒԸߴï38λ¡£
    NUMBERÊý¾ÝÀàÐÍ¿ÉÒÔÓÐÁ½¸öÏÞ¶¨·û£¬È磺
    column NUMBER £¨ precision£¬ scale£©
    precision±íʾÊý×ÖÖеÄÓÐЧλ¡£Èç¹ûûÓÐÖ¸¶¨precisionµÄ»°£¬Oracle½«Ê¹ÓÃ38×÷Ϊ¾«¶È¡£
&nb ......

ORACLE²éѯ»òɾ³ýʱָ¶¨Ê¹ÓÃË÷ÒýµÄд·¨­

 ²éѯʱ¿ÉÒÔÖ¸¶¨Ê¹ÓÃË÷ÒýµÄд·¨¡£­
­
SELECT   /*+ index(TB_ALIAS IX_G_COST3) */­
  TB_ALIAS.*­
  from g_Cost TB_ALIAS­
WHERE Item_Two = 0­
   AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')­
   AND Flight_D ......

ORACLEÖÐÒ»¸öUPDATEµÄ²Ù×÷Á÷³Ì

ǰÕó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
      i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ