Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle DBMS_METADATA Ó÷¨Àý×Ó

rom£ºhttp://www.psoug.org/reference/dbms_metadata.html
General Information
Source
{ORACLE_HOME}/rdbms/admin/dbmsmeta.sql
First Available
9.0.1
¼¸¸ö³£Óùý³Ì»òº¯Êý£º
GET_DDL
Fetch DDL for objects
dbms_metadata.get_ddl(
object_type IN VARCHAR2,
name        IN VARCHAR2,
schema      IN VARCHAR2 DEFAULT NULL,
version     IN VARCHAR2 DEFAULT 'COMPATIBLE',
model     IN VARCHAR2 DEFAULT 'ORACLE',
transform   IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB;
Table
CREATE TABLE test
PCTFREE 0
TABLESPACE uwdata AS
SELECT table_name, tablespace_name
from user_tables;
SET LONG 10000
SELECT dbms_metadata.get_ddl('TABLE', 'TEST')
from dual;
View
CREATE OR REPLACE VIEW my_tables AS
select table_name, tablespace_name
from user_tables;
SELECT dbms_metadata.get_ddl('VIEW', 'MY_TABLES')
from dual;
Function
CREATE OR REPLACE FUNCTION whoami RETURN VARCHAR2 IS
BEGIN
   RETURN user;
END whoami;
/
SELECT dbms_metadata.get_ddl('FUNCTION', 'WHOAMI')
from dual;
Tablespace
SELECT dbms_metadata.get_ddl('TABLESPACE', 'UWDATA')
from dual;
GET_DEPENDENT_DDL
Fetch DDL for dependent objects (audits, object grants)
dbms_metadata.get_dependent_ddl(
object_type        IN VARCHAR2,
base_object_name   IN VARCHAR2,
base_object_schema IN VARCHAR2 DEFAULT NULL,
version            IN VARCHAR2 DEFAULT 'COMPATIBLE',
model              IN VARCHAR2 DEFAULT 'ORACLE',
transform          IN VARCHAR2 DEFAULT 'DDL',
object_count       IN NUMBER   DEFAULT 10000)
RETURN CLOB;
GRANT select ON servers TO hr;
GRANT select ON servers TO scott;
set long 100000
SELECT dbms_metadata.get_dependent_ddl('OBJECT_GRANT','SERV


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle Ë÷Òý×éÖ¯±í£¨IOT£©

     Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
     ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°ü ......

Oracle 開發筆記

Oracle Îï¼þµÄÃüÃûÏÞÖÆ
ÈκÎÎï¼þµÄÃû稱²»µÃ³¬過 30 λԪ(Bytes)
Oracle µÄ dummy query 寫·¨
SELECT SYSDATE from dual
Oracle 選È¡²¿·Ö資Áϵķ½·¨
SELECT * from table WHERE ROWNUM<10; /* È¡³öǰ 10 筆 */
實現 Oracle ÉϵķÖ頁顯ʾ [¾«華] ......

Oracle ʱ¼ä²Ù×÷´óÈ«

ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
¡¡¡¡sysdate+(5/24/60/60)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
¡¡¡¡sysdate+5/24/60
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
¡¡¡¡sysdate+5/24
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
¡¡¡¡sysdate+5
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
¡¡¡¡add_months(sysdate,-5)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
¡¡¡¡add_months ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ