JUST DO IT ~

我只想当个程序员

我的评论

re: c++ 一些经典论文 小高 2014-08-26 13:41  
Citations
359 The design and implementation of hierarchical software systems with reusable components - Batory, OʹMalley - 1992
130 The Programmer’s Apprentice - Rich, Waters - 1990
93 Genesis: An Extensible Database Management System - Batory, Barnett, et al. - 1988
75 Reusing and Interconnecting Software Components - GOGUEN - 1986
56 Data Abstraction and Object-Oriented Programming in C - Gorlen, Orlow, et al. - 1990
48 Software Components with - Booch - 1987
30 Index Support for Rule Activation - Brant, Miranker - 1993
20 Software components in a data structure precompiler - Sirkin, Batory, et al. - 1993
19 P++: a language for largescale reusable software components - Singhal, Batory - 1993
17 libg++, the GNU C++ library - Lea - 1988
14 Software templates - Volpano, Kieburtz - 1985
13 DaTE: The Genesis DBMS software layout editor - Batory, Barnett - 1991
13 Automating relational operations on data structures - Cohen, Campbell - 1993
11 Implementing a domain model for data structures - Batory, Singhal, et al. - 1992
8 Software Reuse through View Type Clusters - Novak - 1992
4 generation database systems - Next - 1991
希望能给我发一份 邮箱地址 gaoyinrui@163.com 谢谢
能否贡献一份上传下载的源码,最好能直接运行的,万分感谢,急需啊。gaoyinrui@163.com
re: 我的职业规划 小高 2009-10-10 00:55  
找个能发挥自己长处的方面.. 死钻研技术未必适合你

1.学院派
2.实战型
3.混业务

3个必居其一.否则做到老很虚的.

还是低调点...
做了几年才感觉入门...
很多人耐不住就走了....


---------

近期目标:在今年10月底争取转正。并在一年内把技术提升到更高的层次,达到高级程序员水平
中期目标:3--5年达到系统架构师水平,能担当更大的责任。
谢谢
re: Drools 规则引擎的使用总结 小高 2008-11-04 15:43  
最后哪句话比较中听
re: oracle 计算 执行的时间 小高 2008-10-16 00:18  

ORACLE sqlplus set 命令速查


SQL>set colsep' ';     //-域输出分隔符

SQL>set echo off;     //显示start启动的脚本中的每个sql命令,缺省为on

SQL> set echo on //设置运行命令是是否显示语句

SQL> set feedback on; //设置显示“已选择XX行”

SQL>set feedback off;  //回显本次sql命令处理的记录条数,缺省为on

SQL>set heading off;   //输出域标题,缺省为on

SQL>set pagesize 0;   //输出每页行数,缺省为24,为了避免分页,可设定为0。

SQL>set linesize 80;   //输出一行字符个数,缺省为80

SQL>set numwidth 12;  //输出number类型域长度,缺省为10

SQL>set termout off;   //显示脚本中的命令的执行结果,缺省为on

SQL>set trimout on;   //去除标准输出每行的拖尾空格,缺省为off

SQL>set trimspool on;  //去除重定向(spool)输出每行的拖尾空格,缺省为off

SQL>set serveroutput on; //设置允许显示输出类似dbms_output

SQL> set timing on; //设置显示“已用时间:XXXX”

SQL> set autotrace on-; //设置允许对执行的sql进行分析

set verify off //可以关闭和打开提示确认信息old 1和new 1的显示.

statement cache 关注一下
re: js中获取radio的值[未登录] 小高 2008-09-05 10:34  
不错的!
以用前面 那个兄弟的话 :"希望这篇文章能够帮助他们在开发期就能避免这样的失误,以免后期上线时再来修改代码从而增加项目的成本与风险。"

说的很好.
关注一下
re: 代码不是调出来的 小高 2008-08-13 23:38  
高手 少...但是 确实有这样的人 这也许才是真的程序员 ............你想成为这样 你可以自己少用调试器....大脑分析
这个代码比if 更丑陋 ..... 看了本书 就强用书上的东西 .... 很有问题 .......
博主有团队工作的经历吗 ...每个人都这样写(小提大作)...... 项目就真乱了....
自己研究还差不多 ... 我打赌 你要是真的 遇到了 你还是用 if
java equals ( Integer ) -125~126 缓存变量可能不通
re: sqlplus 初始化 login.sql 小高 2008-08-05 05:30  
set term off
set linesize 10001
spool a.txt
select * from dl_hqk_his where date_ > to_date('20070101','yyyymmdd');
spool off
set term on
re: sqlplus 初始化 login.sql 小高 2008-08-04 21:34  
现实所有define 的定义

idmp@idmp-192.168.2.100> define



DEFINE _DATE = "04-8月 -08" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "idmp" (CHAR)
DEFINE _USER = "IDMP" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.
1.0 - Production
With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE = "1002000100" (CHAR)
DEFINE SQL_PROMPT = "idmp@idmp-192.168.2.100" (CHAR)
DEFINE ANBC = "1" (CHAR)
idmp@idmp-192.168.2.100>
re: sqlplus 初始化 login.sql 小高 2008-08-03 23:15  
select
q'{
@bar;
}'
from dual;



select
'
@foo.htm;
'
from dual;




create or replace package foo
as
@foo_declarations;
@foo_procedures;
@foo_functions;
end;



http://awads.net/wp/2007/03/25/3-useful-sqlplus-tips/
re: sqlplus 初始化 login.sql 小高 2008-08-03 22:53  
已用时间: 00: 00: 01.04
idmp@idmp-192.168.2.101> set markup html on entmap ON spool on
preformat off
idmp@idmp-192.168.2.101> spool tables.xls
<br>
idmp@idmp-192.168.2.101&gt; select * from dual;
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'>
<tr>
<th scope="col">
D
</th>
</tr>
<tr>
<td>
X
</td>
</tr>
</table>
<p>

已用时间: 00: 00: 00.04
idmp@idmp-192.168.2.101&gt; spool off
re: sqlplus 初始化 login.sql 小高 2008-08-03 22:16  
用spool 输出文件 .............html 查询的结果
re: sqlplus 初始化 login.sql 小高 2008-08-03 22:15  
[Oracle] 用 Oracle 的 SQL*Plus 工具创建 HTML 页面
作者:Fenng
日期:23-Dec-2003 
出处:http://www.dbanotes.net
版本:1.01

Oracle 的 SQL*Plus 工具有一些比较有趣的选项,合理的使用,能够给我们意想不到的后果。其中有一个 ”-M” 选
项能够创建用来创建 HTML 报表,在实际应用中很有用处。我们先来看看 SQL*Plus的一些选项:

-----------------------Oracle8i------Begin------------------------------------------------
C:\>SQLPLUS -

用法 : SQLPLUS [ [<option>] [<logon>] [<start>] ]
其中 <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
< 登录 > ::= < 用户名 >[/< 口令 >][@<connect_string>] | / | /NOLOG
< 启动 > : : = @< 文件名 >[.<ext>] [< 参数 > ...]
"-" 显示使用语法
"-?" 显示 SQL*Plus 版本标帜
"-M <o>" 使用 HTML 标志选项 <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode

”-M” 选项指定在输出的时侯使用 HTML 标记来输出数据,用以代替普通的文本。
-----------------------Oracle8i-------------End-------------------------------------------

-----------------------Oracle9i------Begin------------------------------------------------
D:\>sqlplus -

SQL*Plus: Release 9.2.0.4.0 - Production

用法: SQLPLUS [ [<option>] [<logon>] [<start>] ]
其中 <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" 显示 SQL*Plus 的版本标帜和使用语法
"-V" 显示 SQL*Plus 的版本标帜
"-L" 只尝试登录一次
"-M <o>" 使用 HTML 标志选项 <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode
-----------------------Oracle9i-------------End-------------------------------------------

-----------------------Oracle10G Beta------Begin---------------------------------------

D:\>sqlplus -

SQL*Plus: Release 10.1.0.0.0 - Beta

用法: SQLPLUS [ [<option>] [<logon>] [<start>] ]
其中 <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" 显示 SQL*Plus 的版本标帜和使用语法
"-V" 显示 SQL*Plus 的版本标帜
"-C" 兼容性版本 <v>
"-L" 只尝试登录一次
"-M <o>" 使用 HTML 标志选项 <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode
-----------------------Oracle10G Beta---END---------------------------------------------

(我们从中也可以看出SQLPlus命令的一些变化,如新的参数等)

其中 ”-M” 选项的语法如下:

[-M[ARKUP] "HTML [ON|OFF] [HEAD text] [BODY text]

[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]"

如果我们在实际应用中,要对公司的某个Table进行每个月的报表 HTML 化,用 SQL*Plus 的这个特性很容易做到。

举例如下:

我们准备对 Scott 模式下的 DEPT 表进行处理。 DEPT 表内容:

SQL> SELECT * FROM dept;

DEPTNO DNAME LOC
---------- ---------------------------- ------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

在系统命令行下输出 HTML 文件:

将下面几行语句存到一个 .sql 脚本中(比如说 q.sql ) :

SET ECHO OFF
SET FEEDBACK OFF
SELECT * FROM dept;
SET ECHO ON
SET FEEDBACK ON
exit

然后在命令行下调用如下命令:

C:\> sqlplus -s -m "HTML ON HEAD DEPT 表格之内容 " Scott/tiger @c:\q.sql>Dept.html

对这条命令简单的解释一下:其中 ”-s” 表示 silent 模式, ”-m” 表示启用 HTML Markup 选项,
”HEAD DEPT 表格之内容 ” 可以用来定制一个简单的标题。然后命令中跟的是数据库用户名字和密码,
执行脚本,重定向到 Dept.html 中。

输出 Dept.html 有如下内容(空白处已经截去):

DEPT表格之内容
DEPTNO DNAME LOC
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

在 SQL*Plus 下输出文件

在 SQL*Plus 中可以用 SET MARKUP 命令来做到。

SET MARKUP

用法 : SET MARKUP HTML [ON|OFF] [HEAD text] [BODY text]

[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]

把下面的内容存为一个 .sql 脚本 ( 比如说 C:\q.sql) :

SET ECHO OFF
SET FEEDBACK OFF
SET MARKUP HTML ON SPOOL ON
SPOOL c:\Dept.html
SELECT * FROM dept;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON
SET FEEDBACK ON

在 SQL*Plus 中调用,即可创建内容。在 C:中创建了名为 Dept.html 的 HTML 页面,如下所示:
DEPTNO DNAME LOC
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

注:由于格式化的问题,实际的显示效果可能有所不同.
re: oracle 回话环境变量 userenv 小高 2008-08-03 11:13  
关于sys_context()函数功能一览

包括取本地ip,服务器端domian/db_name……,还有当前session的信息
后面有使用举例:
AUTHENTICATION_DATA
Data being used to authenticate the login user. For X.503 certificate authenticated sessions, this field returns the context of the certificate in HEX2 format.
256


Note: You can change the return value of the AUTHENTICATION_DATA attribute using the length parameter of the syntax. Values of up to 4000 are accepted. This is the only attribute of USERENV for which Oracle implements such a change.


AUTHENTICATION_TYPE
How the user was authenticated:

DATABASE: username/password authentication

OS: operating system external user authentication

NETWORK: network protocol or ANO authentication

PROXY: OCI proxy connection authentication

30

BG_JOB_ID
Job ID of the current session if it was established by an Oracle background process. Null if the session was not established by a background process.
30

CLIENT_INFO
Returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.
64

CURRENT_SCHEMA
Name of the default schema being used in the current schema. This value can be changed during the session with an ALTER SESSION SET CURRENT_SCHEMA statement.
30

CURRENT_SCHEMAID
Identifier of the default schema being used in the current session.
30

CURRENT_USER
The name of the user whose privilege the current session is under.
30

CURRENT_USERID
User ID of the user whose privilege the current session is under
30

DB_DOMAIN
Domain of the database as specified in the DB_DOMAIN initialization parameter.
256

DB_NAME
Name of the database as specified in the DB_NAME initialization parameter
30

ENTRYID
The available auditing entry identifier. You cannot use this option in distributed SQL statements. To use this keyword in USERENV, the initialization parameter AUDIT_TRAIL must be set to true.
30

EXTERNAL_NAME
External name of the database user. For SSL authenticated sessions using v.503 certificates, this field returns the distinguished name (DN) stored in the user certificate.
256

FG_JOB_ID
Job ID of the current session if it was established by a client foreground process. Null if the session was not established by a foreground process.
30

HOST
Name of the host machine from which the client has connected.
54

INSTANCE
The instance identification number of the current instance.
30

IP_ADDRESS
IP address of the machine from which the client is connected.
30

ISDBA
TRUE if you currently have the DBA role enabled and FALSE if you do not.
30

LANG
The ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.
62

LANGUAGE
The language and territory currently used by your session, along with the database character set, in this form:

language_territory.characterset
52

NETWORK_PROTOCOL
Network protocol being used for communication, as specified in the 'PROTOCOL=protocol' portion of the connect string.
256

NLS_CALENDAR
The current calendar of the current session.
62

NLS_CURRENCY
The currency of the current session.
62

NLS_DATE_FORMAT
The date format for the session.
62

NLS_DATE_LANGUAGE
The language used for expressing dates.
62

NLS_SORT
BINARY or the linguistic sort basis.
62

NLS_TERRITORY
The territory of the current session.
62

OS_USER
Operating system username of the client process that initiated the database session
30

PROXY_USER
Name of the database user who opened the current session on behalf of SESSION_USER.
30

PROXY_USERID
Identifier of the database user who opened the current session on behalf of SESSION_USER.
30

SESSION_USER
Database user name by which the current user is authenticated. This value remains the same throughout the duration of the session.
30

SESSION_USERID
Identifier of the database user name by which the current user is authenticated.
30

SESSIONID
The auditing session identifier. You cannot use this option in distributed SQL statements.
30

TERMINAL
The operating system identifier for the client of the current session. In distributed SQL statements, this option returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECT statements, not for remote INSERT, UPDATE, or DELETE operations. (The return length of this parameter may vary by operating system.)




SQL> SELECT sys_context('USERENV','IP_ADDRESS') FROM DUAL;

SYS_CONTEXT('USERENV','IP_ADDR
--------------------------------------------------------------------------------
10.0.0.177

SQL> SELECT SYS_CONTEXT ('hr_apps', 'group_no') "User Group"
2 FROM DUAL;

User Group
--------------------------------------------------------------------------------

SQL> SELECT sys_context('USERENV','CLIENT_INFO') FROM DUAL;

SYS_CONTEXT('USERENV','CLIENT_
--------------------------------------------------------------------------------

SQL> SELECT sys_context('USERENV','CURRENT_SCHEMA') FROM DUAL;

SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
IDCBJ

SQL> SELECT sys_context('USERENV','HOST') FROM DUAL;

SYS_CONTEXT('USERENV','HOST')
--------------------------------------------------------------------------------
WORKGROUP\RAINY

SQL> SELECT sys_context('USERENV','AUTHENTICATION_DATA') FROM DUAL;

SYS_CONTEXT('USERENV','AUTHENT
--------------------------------------------------------------------------------

SQL> SELECT sys_context('USERENV','AUTHENTICATION_TYPE') FROM DUAL;

SYS_CONTEXT('USERENV','AUTHENT
--------------------------------------------------------------------------------
DATABASE

SQL> SELECT sys_context('USERENV','DB_DOMAIN') FROM DUAL;

SYS_CONTEXT('USERENV','DB_DOMA
--------------------------------------------------------------------------------
chenyq

SQL> SELECT sys_context('USERENV','DB_NAME') FROM DUAL;

SYS_CONTEXT('USERENV','DB_NAME
--------------------------------------------------------------------------------
ora817

SQL> SELECT SYS_CONTEXT('hr_context', 'org_id') FROM DUAL;

SYS_CONTEXT('HR_CONTEXT','ORG_
--------------------------------------------------------------------------------

SQL>
re: oracle 计算 执行的时间 小高 2008-07-01 16:48  
select to_date('2008-6-1','yyyy-mm-dd') - interval '7' year test from dual;
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip


注意oracle 10g 不附带同名透明网管 . 无法连接 mssql 库 .
re: oracle open_cursors 小高 2008-06-16 15:19  
共享SQL区在shared pool中释放的条件

alter system flush shared_pool


http://space.itpub.net/12361284/viewspace-259954
re: excel 模板[未登录] 小高 2008-06-12 16:34  
文件不能下载,麻烦您给我一份,急用,谢谢
email:tryonmind@163.com
re: ibm thinkpad 键盘 设置 小高 2008-05-10 10:29  
@呵呵
就是 新的要表达意思的键盘码
再千万的记录 是否比较明显.
re: ORA-12560: TNS: 协议适配器错误 小高 2007-11-26 16:45  
@xx


可能是安装的时候没有建立 oracle 数据库。用工具建立一下就ok
1、使用sys用户登陆

2、执行 $ORACLE_HOME/rdbms/admin/utlxplan.sql ,生成表。

3、执行 $ORACLE_HOME/sqlplus/admin/plustrce.sql 生成角色等。

4、对需要使用该功能的用户赋予角色。

grant plustrace to public;


序号

命令

解释


1

SET AUTOTRACE OFF

此为默认值,即关闭Autotrace


2

SET AUTOTRACE ON

产生结果集和解释计划并列出统计


3

SET AUTOTRACE ON EXPLAIN

显示结果集和解释计划不显示统计


4

SETAUTOTRACE TRACEONLY

显示解释计划和统计,尽管执行该语句但您将看不到结果集


5

SET AUTOTRACE


TRACEONLY STATISTICS

只显示统计




Eg:SET AUTOTRACE ON, set timing on, alter session set time_statistics=true;


三、Autotrace执行计划的各列的涵义

序号

列名

解释


1

ID_PLUS_EXP

每一步骤的行号


2

PARENT_ID_PLUS_EXP

每一步的Parent的级别号


3

PLAN_PLUS_EXP

实际的每步


4

OBJECT_NODE_PLUS_EXP

Dblink或并行查询时才会用到




四、AUTOTRACE Statistics常用列解释

序号

列名

解释


1

db block gets

从buffer cache中读取的block的数量


2

consistent gets

从buffer cache中读取的undo数据的block的数量


3

physical reads

从磁盘读取的block的数量


4

redo size

DML生成的redo的大小


5

sorts (memory)

在内存执行的排序量


7

sorts (disk)

在磁盘上执行的排序量






ORACLE :: 评论 (0) :: 静态链接网址 :: 引用 (0)
发表评论
能否给我一份算法或代码,谢谢!
shenyegh@scfast.com

导航

<2024年3月>
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456

统计

常用链接

留言簿(3)

随笔分类(352)

收藏夹(19)

关注的blog

手册

搜索

积分与排名

最新评论

阅读排行榜

评论排行榜