Óë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Êý¾Ý¿âµÄÁ´½ÓÐÅÏ¢¡£
*
* @author ZhongHuiQiang
*
*/
public interface IOracleDAOInfor {
String DB_SERVER_HOSET = "localhost";
String DB_SERVER_NAME = "ppoo";
String DB_USER_NAME = "system";
String DB ......
oracleÊý¾Ý¿â²åÈëÈÕÆÚÐÍÊý¾Ý
ÍùOracleÊý¾Ý¿âÖвåÈëÈÕÆÚÐÍÊý¾Ý£¨to_dateµÄÓ÷¨£©
½ñÌìÅöµ½ÁËÐèÒªÍùOracleÊý¾Ý¿âÖвåÈëÈÕÆÚÐÍÊý¾Ý£¬ÒªÊ¹ÓÃTO_DATEº¯Êý£¬ÔÚÍøÉÏ·¢ÏÖһƪдµÄ²»´íµÄÎÄÕ£¬ÕªÀ´Ò»Æð·ÖÏí¡£
INSERT INTO FLOOR VALUES ( to_date ( '2007-12-20 18:31:34' , 'YYYY-MM-DD HH24:M ......
INÌõ¼þ
ÓÃINÌõ¼þÔÚÖ¸¶¨µÄÒ»×éÖµÖнøÐвâÊÔ¡£INÌõ¼þÒ²¾ÍÊÇ ³ÉÔ±Ìõ¼þ¡£
ÔڻõÆƬµÄÀý×ÓÖÐÏÔʾËùÓоÀíºÅΪ100¡¢101»ò201µÄ¹ÍÔ±µÄemployee numbers, last names, salariesºÍ¾ÀíµÄemployee numbers¡£
ÔÚINÌõ¼þÖпÉÒÔʹÓÃÈκÎÊý¾ÝÀàÐÍ¡£ÏÂÃæµÄÀý×Ó´ÓEMPLOYEES±í·µ»Ø¹ÍÔ±ÐÅÏ¢ÐУ¬ÕâЩ¹ÍÔ±µÄÃû×Ö°üÀ¨ÔÚWHERE×Ó¾äµÄÃû×ÖÁÐ ......