Óë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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......
Parsing command line arguments:
Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
at oracle.net.ca.I ......
declare
STR VARCHAR2(400);
begin
-- ÖØ½¨ORACLEË÷Òý
FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME
&nb ......