Database
文章平均质量分 75
E0001
这个作者很懒,什么都没留下…
展开
-
查找Oracle数据库中包含指定值的字段
SET SERVEROUTPUT ONACCEPT ROW_ID PROMPT '请输入要查询的字符串 :'DECLARE SQL_STMT VARCHAR2(200); V_TBLNAME VARCHAR2(30); V_COLNAME VARCHAR2(30); REC_COUNT NUMBER(7):=0; CURSOR WT_TABLES IS ...原创 2011-06-11 23:14:52 · 1689 阅读 · 0 评论 -
DBMS_STATS.GATHER_SCHEMA_STATS Procedures
This procedure gathers statistics for all objects in a schema.SyntaxDBMS_STATS.GATHER_SCHEMA_STATS ( ownname VARCHAR2, estimate_percent NUMBER DEFAULT to_estimate_percent_ty...原创 2011-06-11 23:46:40 · 194 阅读 · 0 评论 -
Initialization Parameter files: PFILEs vs. SPFILEs
When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are eith...原创 2011-11-22 00:43:28 · 133 阅读 · 0 评论