oracle´´½¨ÊÓͼÖÐÉæ¼°µ½ÁíÍâÒ»¸öÓû§µÄ±íȨÏÞ²»×ãÎÊÌâ
ÔÚoracleÖд洢¹ý³Ì»òÕßÊÓͼµÈ¶ÔÏó´´½¨Ê±£¬Èç¹ûÉæ¼°µ½ÁíÍâÒ»¸öÓû§µÄ±í£¬¼´Ê¹ÄãÒѾgrant dbaÁË£¬Ò²²»ÐУ¬±ØÐëÏÔʽµØ¸³Óè²éѯȨÏÞ¡£·ñÔò£¬Äã»á·¢ÏÖÔÚpl/sqlÖпÉÒÔÖ´ÐÐÓï¾ä£¬µ«ÊÇÒ»µ©·Åµ½create Öо͸æËßÄãȨÏÞ²»×ã¡£
grant select any table to user
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
OracleÉó¼Æ¹¦ÄÜ
Ò»¡¢ Éó¼Æ·ÖÀࣺ
OracleÖÐÉó¼Æ×ÜÌåÉÏ¿É·ÖΪ“±ê×¼Éó¼Æ”ºÍ“ϸÁ£¶ÈÉó¼Æ”ºóÕßÒ²³ÆΪ“»ùÓÚÕþ²ßµÄÉó¼Æ”£¬ÔÚOracle10GÖ®ºó¹¦Äܵõ½ºÜ´óÔöÇ¿¡£ÆäÖбê×¼Éó¼Æ¿É·ÖΪÓû§¼¶Éó¼ÆºÍϵͳ¼¶Éó¼Æ¡£Óû§¼¶Éó¼ÆÊÇÈκÎOracleÓû§¿ÉÉèÖõÄÉó¼Æ£¬Ö÷ÒªÊÇÓû§Õë¶Ô×Ô¼º´´½¨ ......
author:skate
time:2010-05-27
oracleÌí¼Ó×Ö¶ÎÒýÆðµÄÎÊÌâ
ÓÉÓÚͬÊÂÔÚÌí¼ÓÁ˱íµÄ×ֶκó£¬Ã»ÓÐÖØбàÒëÊý¾Ý¿âµÄ¶ÔÏ󣬵¼ÖºÍÕâ¸ö±íÏà¹ØµÄºÜ¶àprocedureºÍpackage¶¼Ê§Ð§¡£
ÓÉÓÚ·¢ÏÖºóÊÇÔÚÐ޸ĺó2¸öСʱ°É£¬¶øÔÚÕâÆÚ¼äºÜ¶à³ÌÐòÔÚµ÷ÓÃÕâЩ¹ý³Ì£¬ÖÂʹºÜ¶à»á»°¶¼½©ËÀÔÚÄÇ£¬ËùÒÔÒ²ÎÞ·¨
ÔÙÖØбàÒë¹ýÈ ......
||------- ά»¤Êý¾ÝÍêÕûÐÔ -------||
¡¾Ô¼Êø¡¿
//Ô¼Êø
not null //·Ç¿Õ
unique //Ψһ ²»ÄÜÖظ´£¬µ«¿ÉÒÔΪ¿Õ
primary key //Ö÷¼ü
foreign key //Íâ¼ü
check //Âú×ãÌõ¼þ
//É̵êÊÛ»õϵͳ±íÉè¼Æ°¸Àý£¨1£©
//goods ÉÌÆ·±í
goodsid ......
||------- pl/sql »ù´¡ -------||
pl/procedural language ¹ý³ÌÓïÑÔ
//´´½¨±í
SQL> create table mytest(
2 name varchar2(30),
3 pwd varchar2(30));
//´´½¨¹ý³Ì
create procedure sp_pro1 is
create or replace procedure sp_pro1 is --Èç¹û´æÔÚ¼´ ......