ORACLEÊý¾Ý×Öµä¼ò½é
ORACLEÖеÄÊý¾Ý×ÖµäÊÇʲô£¿ÓÐʲôÌصãºÍ¹æÂÉ£¿
Êý¾Ý×Öµä¼Ç¼ÁËÊý¾Ý¿âµÄϵͳÐÅÏ¢£¬ËüÊÇÖ»¶Á±íºÍϵͳÊÓͼµÄ¼¯ºÏ¡£
Êý¾Ý×ÖµäµÄËùÓÐÕßÊÇSYSÓû§£¬Êý¾Ý×ֵ䶼±»´æ·ÅÔÚSYSTEM±í¿Õ¼ä£¬SYSÓû§µÄ·½°¸Ï¡£
Êý¾Ý×ÖµäÖ»ÔÊÐíSELECT²Ù×÷£¬Æäά»¤ºÍÐÞ¸ÄÈÎÎñÓÉÊý¾Ý¿â×Ô¶¯Íê³É¡£
µ±Óû§Ö´ÐÐCREATE¡¢ALTER¡¢DROP²Ù×÷ʱ£¬OracleÊý¾Ý¿â»áÔÚÏàÓ¦Êý¾Ý×ÖµäÉÏÖ´ÐÐINSERT¡¢UPDATE£¬
DELETE²Ù×÷¡£
ORACLEÖÐÊý¾Ý×ÖµäÓÐÈýÖÖÀàÐÍ£¬·Ö±ðΪUSER_XXX¡¢ALL_XXX¡¢DBA_XXX£¬ÆäÖÐUSER_XXX±íʾµ±Ç°
Óû§ËùÓµÓеĶÔÏó£¬ALL_XXX±íʾµ±Ç°Óû§ÓвÙ×÷ȨÏ޵ĶÔÏó£¬DBA_XXX±íʾÊý¾Ý¿âÖÐËùÓеĶÔÏó¡£±È
È磺²ÉÓÃSCOTTÓû§µÇ¼Êý¾Ý¿âÖ®ºóÖ´ÐÐÏÂÁÐÃüÁî¿ÉÒÔ¿´µ½ÓÐËĸö±í£º
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
Ö´ÐÐÏÂÁÐÃüÁîʱ¿ÉÒÔ¿´¶à·Ç³£¶àµÄ±í£¬ÆäÖаüÀ¨SCOTTËùÓµÓеĺÍSCOTTÓÐȨÏÞ·ÃÎʵģº
SQL> select table_name from all_tables;
Ö´Ðнá¹û£¨ÂÔ£©
DBA_XXX±íʾÊý¾Ý¿âÖÐËùÓеĶÔÏ󣬰üÀ¨ÊôÓÚÓû§µÄ¡¢Óû§ÓÐȨÏÞ·ÃÎʵÄÒÔ¼°ÏµÍ³ÖеĶÔÏó¡£ÒòΪDBA_XXXÊÔͼ¿ÉÒԲ鿴ϵͳÖеÄÐÅÏ¢£¬ËùÒԺܶàDBA_XXXÊý¾Ý×Öµä¶ÔûÓÐÏàӦȨÏÞµÄÓû§ÆÁ±ÎÁË¡£±ÈÈçDBA_TABLES£¬SCOTTÓû§¾ÍûÓÐȨÏ޲鿴£¬¶øSYSTEM¡¢SYSÓû§¾ßÓв鿴¸ÃÊý¾Ý×ÖµäµÄȨÏÞ¡£Èç¹ûҪʹij¸öÓû§¾ßÓв鿴DBA_XXXµÄȨÏÞ£¬Ôò±ØÐë¸øËüÊÚÓèDBA¡¢SELECT_CATALOG_ROLE½ÇɫȨÏÞ¡£
ÕÆÎÕÕâ¸ö¹æÂɾͿÉÒԺܷ½±ãµÄʹÓÃÊý¾Ý×ÖµäÁË¡£
Ïà¹ØÎĵµ£º
create or replace directory MY_DIR as '/usr/test/';
create or replace function f_exportTxt(
--´«Èë²ÎÊý
i_query in varchar2,
i_separator in varchar2,
i_dir in varchar2,
i_filename in varchar2
) return number
is
/**
** º¯ÊýÃû:f_exportTxt
&nbs ......
ת×Ô£ºhttp://hong9270503.blog.163.com/blog/static/1272923200916112245844/
ѧϰoracle,×îºÃÊ×ÏÈÁ˽âOracleµÄ¿ò¼Ü¡£ÕâÑù¶ÔOracleÓÐÒ»¸öÕûÌåµÄÈÏʶ£¬ÓиßÎݽ¨ê²µÄ×÷Óá£
1¡¢ÎïÀí½á¹¹£¨ÓÉ
¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢¿ÚÁîÎļþ×é³É£©
¡¡¡¡
Ò»¸öÊý¾Ý¿âÖеÄÊý¾Ý´æ´¢ÔÚ´ÅÅÌÉÏÎïÀíÎļþ£¬ ......
ORACLE EXP/IMP ²ÎÊýÏê½â2010-03-22 17:53OracleÊý¾Ý¿âʹÓÃIMP/EXP¹¤¾ß½øÐÐÊý¾Ýµ¼ÈëÓëµ¼³ö½éÉÜ£º
1.ʹÓÃÃüÁîÐУº
Êý¾Ýµ¼³ö£º
1.½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§ÃûsystemÃÜÂëmanagerµ¼³öµ½D:\Test_bak.dmpÖÐ
exp system/manager@ora10 file=d:\Test_bak.dmp full=y
ora10±íʾÊý¾Ý¿âÃû
2.½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ ......
@@servername:·µ»ØÔËÐÐSQL ServerÊý¾Ý¿â±¾µØ·þÎñÆ÷µÄÃû³Æ¡£
@@remserver:·µ»ØµÇ¼¼Ç¼ÖмÇÔصÄÔ¶³ÌSQL Server·þÎñÆ÷µÄÃû³Æ¡£
@@connections:·µ»Ø×ÔÉÏ´ÎÆô¶¯SQL ServerÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý£¬ÓÃÆä¿ÉÈùÜÀíÈËÔ±·½±ãµØÁ˽â½ñÌìËùÓÐÊÔͼÁ¬½Ó·þÎñÆ÷µÄ´ÎÊý¡£
@@cursor_rows:·µ»Ø×îºóÁ¬½ÓÉϲ¢´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñ ......
ʹÓÃÒ»ÏÂSQL
select *
from T_0303003
order by stock_holder
½øÐÐÑ¡È¡Êý¾Ýʱ£¨stock_holderΪ´æ·ÅÖÐÎĵÄ×ֶΣ©£¬½á¹û·¢ÏÖÁ½¿â·µ»ØµÄ¼Ç¼˳Ðò²»Ò»Ö¡£×ÁÄ¥Ö®ºóÓ¦¸ÃΪ×Ö·û¼¯ÎÊÌ⣬һ¸ö¿â×Ö·û¼¯ÎªÏµÍ³Ä¬ÈÏ×Ö·û¼¯£¬ÁíÒ»¸ö¿âΪUTF-8×Ö·û¼¯¡£²éÕÒ×ÊÁϺó·¢ÏÖ£¬¶ÔÓÚÖÐÎÄ×ֶεÄÅÅÐò£¬Ó¦¸ÃÊ¹Ó ......