Oracle»ù´¡Ñ§Ï°±Ê¼Ç
1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
create tablespace ±í¿Õ¼äÂß¼Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼'
size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off£©;
4.´´½¨Óû§£ºcreate user Óû§Ãû identified by ÃÜÂ룻
5.Óû§ÊÚȨ£ºgrant connect to Óû§Ãû --------±íʾÊÚÓèÓû§Á¬½ÓµÄȨÏÞ
grant dba to Óû§Ãû ------±íʾÊÚÓè¹ÜÀíÔ±µÄȨÏÞ
grant resource to Óû§Ãû -----±íʾ´´½¨Ò»¸öȨÏÞ¶ÔÏó
--Á¬½Ó
conn admin/admin;
--Á¬½Óµ±Ç°Óû§
conn yangjian/yangjian;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user system identified by system;
--ɾ³ýÓû§(cascadeɾ³ýģʽ¶ÔÏó)
drop user admin cascade;
6.exit -----Í˳öÁ¬½Ó
7.´´½¨±í£º
create table ±íÃ÷
£¨
sid varchar2(20), --varchar2±íʾ¶¯Ì¬µÄ×Ö·ûÀàÐÍ
sage int ----Êý×ÖÀàÐÍ
£©;
--ɾ³ý±í¿Õ¼ä
Drop tablespace spac
--Ð޸ıí
--1.Ϊָ¶¨µÄ±íÌí¼ÓÒ»ÁÐ
alter table student add(score varchar2(3))
--2.ÐÞ¸ÄÖ¸¶¨ÁÐ
alter table student modify(score number(3,1))
--3.ɾ³ýÖ¸¶¨µÄÁÐ
alter table student drop column score
--4.²é¿´Ö¸¶¨±íµÄ½á¹¹
desc student
--ɾ³ý±í
--1.ֻɾ³ý±íÖеÄËùÓÐÊý¾Ý£¬±£Áô±íµÄ½á¹¹
truncate table student
delete student;
--2.ɾ³ýÕû¸ö±í£¬°üÀ¨±íµÄÕû¸ö½á¹¹
drop table student
8.show user ------ÏÔʾµ±Ç°µÇ½Óû§Ãû
9.´´½¨Ò»¸öÐòÁУº
create sequence ÐòÁÐÃû start with 1 increment by 2 minvalue 1 maxvalue 2000
cycle/uncycle; -----±íʾ¸ÃÐòÁдÓ1¿ªÊ¼£¬×ÔÔö2£¬×îСֵ1£¬×î´óÖµ2000£¬cycle±íʾµ½´ï×î´óÖµºó
Ïà¹ØÎĵµ£º
ºÜ¶àÈ˶¼Åöµ½¹ýÒòΪ×Ö·û¼¯²»Í¬¶øÊ¹Êý¾Ýµ¼Èëʧ°ÜµÄÇé¿ö¡£ÕâÉæ¼°Èý·½ÃæµÄ×Ö·û¼¯£¬Ò»ÊÇoracel server¶ËµÄ×Ö·û¼¯£¬¶þÊÇoracle client¶ËµÄ×Ö·û¼¯;ÈýÊÇdmpÎļþµÄ×Ö·û¼¯¡£ÔÚ×öÊý¾Ýµ¼ÈëµÄʱºò£¬ÐèÒªÕâÈý¸ö×Ö·û¼¯¶¼Ò»Ö²ÅÄÜÕýÈ·µ¼Èë¡£
¡¡¡¡1¡¢²éѯoracle server¶ËµÄ×Ö·û¼¯
¡¡¡¡ÓкܶàÖÖ·½·¨¿ÉÒÔ²é³öor ......
ÔÚOracleÊÇÌṩÁËnext_dayÇóÖ¸¶¨ÈÕÆÚµÄÏÂÒ»¸öÈÕÆÚ.
Óï·¨ : next_day( date, weekday )
date is used to find the next weekday.
weekday is a day of the week (ie: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
¿ÉÓÃÓÚ:
Oracle 9i, Oracle 10g, Oracle 11g
For example:
next_day('01- ......
ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È ......
select * from (
select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMEN ......