Oracle Óû§¼°½ÇÉ« ½éÉÜ
Ò»
.
Óû§¹ÜÀí
1.1
½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE
USER
DAVE
IDENTIFIED
BY
pwd
DEFAULT
TABLESPACE
users
TEMPORARY
TABLESPACE
temp
QUOTA
5m
ON
users;
1.2
ÐÞ¸ÄÓû§
ALTER
USER
DAVE QUOTA 0
ON
SYSTEM;
1.3
ɾ³ýÓû§
DROP
USER
DAVE;
DROP
USER
DAVE
CASCADE
;
1.4
ÏÔʾÓû§ÐÅÏ¢
SELECT
*
from
DBA_USERS
SELECT
*
from
DBA_TS_QUOTAS
¶þ
.
ϵͳȨÏÞ
ϵͳȨÏÞ
×÷ÓÃ
CREATE SESSION
Á¬½Óµ½Êý¾Ý¿â
CREATE TABLE
½¨±í
CREATE TABLESPACE
½¨Á¢±í¿Õ¼ä
CREATE VIEW
½¨Á¢ÊÓͼ
CREATE SEQUENCE
½¨Á¢ÐòÁÐ
CREATE USER
½¨Á¢Óû§
ϵͳȨÏÞ
ÊÇÖ¸Ö´ÐÐÌض¨ÀàÐÍ
SQL
ÃüÁîµÄȨÀû£¬ÓÃÓÚ¿ØÖÆÓû§¿ÉÒÔÖ´ÐеÄÒ»¸ö»òÒ»ÀàÊý¾Ý¿â²Ù×÷¡££¨Ð½¨Óû§Ã»ÓÐÈκÎȨÏÞ£©
2.1
ÊÚÓèϵͳȨÏÞ
GRANT
CREATE
SESSION
,
CREATE
TABLE
TO
DAVE;
GRANT
CREATE
SESSION
TO
DAVE
WITH
ADMIN
OPTION
;
Ñ¡Ï
ADMIN OPTION
ʹ¸ÃÓû§¾ßÓÐתÊÚϵͳȨÏÞµÄȨÏÞ¡£
2.2
ÏÔʾϵͳȨÏÞ
²é¿´ËùÓÐϵͳȨÏÞ£º
Select * from system_privilege_map;
ÏÔʾÓû§Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from dba_sys_privis;
ÏÔʾµ±Ç°Óû§Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from user_sys_privis;
ÏÔʾµ±Ç°»á»°Ëù¾ßÓеÄϵͳȨÏÞ£º
Select * from session_privis;
2.3
ÊÕ»ØϵͳȨÏÞ
REVOKE
CREATE
TABLE
from
DAVE;
REVOKE
CREATE
SESSION
from
DAVE;
Èý
.
½ÇÉ«£º
½ÇÉ«ÊÇÒ»×éÏà¹ØȨÏÞµÄÃüÃû¼¯ºÏ£¬
ʹÓýÇÉ«×îÖ÷ÒªµÄÄ¿µÄÊǼò»¯È¨ÏÞ¹ÜÀí¡£
3.1
Ô¤¶¨Òå½ÇÉ«¡£
CONNECT
×Ô¶¯½¨Á¢£¬
°üº¬ÒÔÏÂȨÏÞ£º
ALTER SESSION
¡¢
CREATE CLUSTER
¡¢
CREATE DATABASELINK
¡¢
CREATE SEQUENCE
¡¢
CREATE SESSION
¡¢
CREATE SYNONYM
¡¢
CREATE TABLE
¡¢
CREATEVIEW
¡£
RESOURCE
×Ô¶¯½¨Á¢
£¬°üº¬ÒÔÏÂȨÏÞ£º
CREATE CLUSTER
¡¢
CREATE PROCEDURE
¡¢
CREATE SEQUENCE
Ïà¹ØÎĵµ£º
1.½«¿Í»§¶Ë³ÌÐò½âѹµ½µçÄÔÖÐ
2.ÅäÖû·¾³±äÁ¿£º
ORACLE_HOME=F:\instantclient_10_2\client
Path¼ÓÉÏ%ORACLE_HOME%\bin£»
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3.ÐÞ¸Ä
%ORACLE_HOME%\network\adminϵÄtnsnames.oraÎļþ
dev = &nbs ......
1.¼¤»îSQL¸ú×Ù
´Óoracle10gÒÔºóÌṩÁËеķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
֮ǰ¾É·½·¨ÊÇʹÓà alter session set events .. »òÕßʹÓÃdbms_system.set_ev·½Ê½
ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......
½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......
×÷Óãºmerge into ½â¾öÓÃB±í¸úÐÂA±íÊý¾Ý£¬Èç¹ûA±íÖÐûÓУ¬Ôò°ÑB±íµÄÊý¾Ý²åÈëA±í£»
Óï·¨£º
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here ......
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç ......