Oracle»ù´¡
---------------oracle ÈëÃÅ
´ò¿ª·þÎñÆ÷
net start oracleserviceORCL
´ò¿ª¼àÌýÆ÷
lsnrctl start
¹Ø±Õ·þÎñÆ÷
net stop oracleserviceORCL
¹Ø±Õ¼àÌýÆ÷
lsnrctl stop
-----------------------------
1.´´½¨±í
Create table ±íÃû
(×Ö¶ÎÃû Êý¾ÝÀàÐÍ)
2.Ð޸ıíÖÐÁеÄÊý¾ÝÀàÐÍ
Alter table ±íÃû
modify(×Ö¶ÎÃû Êý¾ÝÀàÐÍ)
Ìáʾ:Çå¿Õ±íºó²ÅÄÜÐÞ¸Ä
3.Ôö¼Ó±í×Ö¶Î
Alter table ±íÃû
add(×Ö¶ÎÃû Êý¾ÝÀàÐÍ)
4.ɾ³ý±í×Ö¶Î
Alter table ±íÃû
drop(×Ö¶ÎÃû Êý¾ÝÀàÐÍ)
5.´´½¨±í²¢¸´ÖÆÁíÒ»Õűí½á¹¹ºÍÊý¾Ý
Create table ±íÃû as
select * from table ±íÃû
6.²åÈëÁíÒ»ÕŵÄÊý¾Ýµ½×Ô¼º±íÖÐ
insert into ±íÃû (¿ÉÑ¡×Ö¶ÎÃû)
select * from ±íÃû
Ìáʾ:²åÈë±íÖÐ×Ö¶ÎÒªºÍ²éѯ±í×Ö¶ÎÀàÐÍÒ»ÖÂ,*´ú±íËùÓÐ×Ö¶Î,Èç¹ûÖ»Òª²¿·Ö×Ö¶Î,±£Ö¤Òª²åÈë±í×ֶκͲéѯ×ֶθöÊý,Êý¾ÝÀàÐÍÒ»ÖÂ
------------------------------
´´½¨±í¿Õ¼ä
create tablespace stusys
datafile 'd:\oracle\stusys.dbf'
size 50m
autoextend on;
´´½¨Óû§
create user wangwei identified by wangwei
default tablespace stusys
temporary tablespace temp;
ÊÚȨ
grant connect to wangwei;
grant resource to wangwei;
ÓÃÐÂÓû§µÇ¼
conn wangwei/wangwei
´´½¨±í
ѧÉú±íÖÐÓÐÒ»¸öÍâ¼ü¹ØÁª°à¼¶±í
create table classlist(
claid char(6) primary key,
opdate date,
manager char(8)
);
create table students(
stuid int primary key,
stuname char(8),
claid char(8) references classlist
);
------------------------------
oracleµÄÊý¾ÝÀàÐÍ
ÊýÖµÐÍ£ºnumber(<p>,<s>)
×Ö·ûÐÍ£ºchar(size)¡¢varchar2(size)¡¢varchar()
ÈÕÆÚÐÍ£ºdate
²éѯµ±Ç°Ê±¼äselect sysdate from dual;
¸ñʽ»¯µ±Ç°Ê±¼äalter session set nls_date_format='yyyy-mm-dd';
´ó¶ÔÏóÀàÐÍ£ºblob¡¢clob¡¢bfile¡¢raw¡¢long
¿ÕÀàÐÍ£ºnull
null²»µÈÓÚ''¿Õ
ÌØÊâÀàÐÍ£ºrowi
Ïà¹ØÎĵµ£º
/******************************************************************************/
/*
Ö÷Á÷Êý¾Ý¿âMYSQL/MSSQL/ORACLE²âÊÔÊý¾Ý¿â½Å±¾´úÂë
½Å±¾ÈÎÎñ:½¨Á¢4¸ö±í,Ìí¼ÓÖ÷¼ü,Íâ¼ü£¬²åÈëÊý¾Ý,½¨Á¢ÊÓͼ
ÔËÐл·¾³1:microsoft sqlserver 2000 ²éѯ·ÖÎöÆ÷
ÔËÐл·¾³2:mysql5.0 phpMyAdminÍøÒ³½çÃæ
ÔËÐл·¾³3:oracle 9i SQL*PLU ......
Ò»¸öÔµĵÚÒ»Ìì
´úÂë (Ë«»÷´úÂ븴ÖƵ½Õ³Ìù°å)
SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')
from dual
sysdate ΪÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°ÏµÍ³Ê±¼ä¡£
to_char Êǽ«ÈÕÆÚÐÍתΪ×Ö·ûÐ͵ĺ¯Êý¡£
to_date Êǽ«×Ö·ûÐÍתΪÈÕÆÚÐ͵ĺ¯Êý£¬Ò»°ãʹÓà yyyy-mm-dd hh24:mi:ss¸ñʽ£¬µ±Ã»ÓÐÖ¸¶¨Ê±¼ä²¿·Öʱ£¬ÔòÄ ......
ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇÍ ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐ ......
WinXP ÏÂÖØÐÂÉèÖà Oracle ¹ÜÀíÔ±ÃÜÂë
Windows ÏÂÐÞ¸Ä Oracle ¹ÜÀíÔ±ÃÜÂë²Ù×÷²½Öè¡£´Ë²½ÖèÔÚ WinXP5.1¡¢Oracle92 ϲÙ×÷³É¹¦¡£¸ü¸ÄÒÔºóÐèÒªÖØÆô¼ÆËã»úºÍʵÀý·½¿ÉÉúЧ¡£
±³¾°£ºWinXP °æ±¾ 5.1£¨ÄÚ²¿°æ±¾ºÅ 2600.xpsp_sp2_dgr.07022 ......