在每个节点执行 ssh node_name date,如果提示密码则表示不成功

$ ssh hpux1 date
Tue Jun 12 10:45:05 EAT 2007

这是正常的.

如果提示密码,需要重新生成SSH

...]]> blog zhaoyu728 Tue, 12 Jun 2007 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259867 Thread 2 cannot allocate new log, sequence 4510
Checkpoint not complete
Current log# 3 seq# 4509 mem# 0: +MYASM/baan/onlinelog/group_3.268.592727939
Thread 2 advanced to log sequence 4510
Current log# 4 seq# 4510 mem# 0: +MYA...]]> blog zhaoyu728 Thu, 07 Jun 2007 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259866 return varchar2 is
v_rs varchar2(4000);
begin
if str is null then
return null;
else
for i IN 1 .. length(str) loop
if ascii(substr(str, i, 1))...]]> blog zhaoyu728 Thu, 07 Dec 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259865 SP2-0923: 不允许通过 iSQL*Plus URL 执行 AS SYSDBA 或 AS SYSOPER 登录
这通常在第一次登陆isqlplus会犯的错误,那怎样登录呢?

DBA“登录”屏幕
1)您可以使用 SYSDBA 或 SYSOPER 权限登录到 iSQL*Plus，以通过 iSQL*Plus 执行数据库管理并运行 DBA 命...]]> blog zhaoyu728 Tue, 07 Mar 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259864 SQL> conn sys/ as sysdba
请输入口令:
已连接。
SQL> show parameter service_na

NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
blog zhaoyu728 Wed, 22 Feb 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259852 今天利用GTL组件，一个表显示父子结构，一个表显示相关父和子的数据，虽然有TreeView的功能，但是在利用checkbox属性时碰到了问题，响应事件只有true,但是怎么区分是显示父呢，显示子呢，而且多阶的父子结构怎么显示？

后来...]]> blog zhaoyu728 Tue, 14 Feb 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259857 using System;
using System.ComponentModel;
using System.Collections;
using System.Diagnostics;
using System.Data;
using System.Data.SqlClient;
public override object Select(object type)
{ blog zhaoyu728 Thu, 09 Feb 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259858 private void button1_Click(object sender, System.EventArgs e)
{
scmx11.Scmx.Clear();
treeView1.BeginUpdate();
dataGrid1.DataSource=null;
AddtoDataSet2(textBox1.Text);
DataView dv=new Data...]]> blog zhaoyu728 Thu, 09 Feb 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259853 blog zhaoyu728 Mon, 23 Jan 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259854 事件功能由三个因素组成：

1． 提供事件数据的类-----公共使用的类事件处理程序需要状态信息，则应用程序必须从此类派生一个类来保存数据。该类必须从 System.EventArgs（它是事件数据的基类）导出。如：

blog zhaoyu728 Mon, 23 Jan 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259855 select distinct gzh=(select distinct top 1 orderno from mom10200 m inner join ord20111 on m.orderno=ord20111.docno where m.orderno= '05B11F001'),
(select distinct dept from sfc10500 where part in (select partp from sfc10510 where partc=s.par...]]> blog zhaoyu728 Thu, 19 Jan 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259856
ALTER procedure pr_inv10210_cst

as
declare @l_messcode char(4),
@l_trancnt int,
@l_count int,
@l_llc int ,
@l_xuhk char(10),
@l_i int ,
@l_xuhktemp char(10)

/*create table...]]> blog zhaoyu728 Thu, 19 Jan 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259863 ORA-01719 outer join operator (+) not allowed in operand of OR or IN

Cause: An outer join appears in an or clause.

Action: If A and B are predicates, to get the effect of (A(+) or B), try (select wher...]]> blog zhaoyu728 Sun, 01 Jan 2006 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259850 CREATE PROCEDURE sp_decrypt(@objectName varchar(50))
AS
begin
set nocount on

begin tran
declare @objectName1 varchar(100),@orgvarbin varbinary(8000)
declare @sql1 nvarchar(4000),@sql2 varchar(8000),@sql3 nvarchar(4000)...]]> blog zhaoyu728 Mon, 10 Oct 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259851 create procedure scmx_delbom as
declare @same varchar(110),@id integer--声明变量，存储fetch提取的数据

declare scmx_cursor cursor for
select ltrim(rtrim(mycg))+ltrim(rtrim(dlhk)),count(*) from bom group by dlhk,mycg having count(*)&g...]]> blog zhaoyu728 Mon, 10 Oct 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259849 Dynamic Predicate:

SQL> col my_col new_value dyn_where_clause
SQL> select decode('&&deptno',null,decode('&&hiredate',null,'','where hire_date=to_date(
2 '''||'&&hiredate",''DD-MON-YYYY'')'),decod...]]> blog zhaoyu728 Thu, 15 Sep 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259847 SQL> select ename,sal,deptno from employee
2 start with ename='BLAKE'
3 connect by prior empno=mgr;

ENAME SAL DEPTNO
---------- ---------- ----------
BLAKE 2850 30
ALLEN ...]]> blog zhaoyu728 Tue, 30 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259848 它是只读的表，可以做为一个虚拟表。数据存在数据库外面的单一文件里。
外部表的元数据是在创建表的时候被定义的，存在其他的数据库或文件中。
Oracle 数据可以借助外部表把数据存在单一文件或从文件中卸载。
外部表的数据可以读但不能操作或建索引。...]]> blog zhaoyu728 Tue, 30 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259845 tree walking,Natural Tree Structure
The hierarchy can
be created by looking at the relationship between equivalent values in the EMPLOYEE_ID and
MANAGER_ID columns.
Hierarchy relationship can be exploited by joining the table to ...]]> blog zhaoyu728 Wed, 24 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259846 SQL> select ename||' reports to '||prior ename "Walk BOttom up"
2 from employee
3 start with ename='ALLEN'
4 connect by prior manager_id=empno;

Walk BOttom up
--------------------------------
AL...]]> blog zhaoyu728 Wed, 24 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259844 SQL> select ename,deptno,sal from emp
2 where exists(select 'x' from dept
3 where dept.deptno=emp.deptno) and sal in(select sal from emp where comm is not null);

ENAME DEPTNO SAL
---------- ---------- --...]]> blog zhaoyu728 Thu, 18 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259843 SQL> select ename,job from emp
2 where sal<(select avg(sal) from emp);

ENAME JOB
---------- ---------
SMITH CLERK
ALLEN SALESMAN
WARD SALESMAN
MARTIN SALESMAN
TURNER SALE...]]> blog zhaoyu728 Wed, 17 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259842 composite columns would mean skipping aggregation across certain levels.
That is, GROUP BY ROLLUP(a, (b, c))
is equivalent to
GROUP BY a, b, c UNION ALL
GROUP BY a UNION ALL
GROUP BY ()

SQL> select deptno,job,sal,su...]]> blog zhaoyu728 Mon, 15 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259841 SQL> select deptno deptid,job work,sum(sal),grouping(deptno) grp_dept,
2 grouping(job) grp_job from emp
3 where deptno<40
4 group by rollup(deptno,job);

DEPTID WORK SUM(SAL) GRP_DEPT GRP_JOB
-...]]> blog zhaoyu728 Sun, 14 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259840 The ROLLUP operator creates subtotals that roll up from the most detailed level to a grand total, following
the grouping list specified in the GROUP BY clause
The Rollup operation to produce cumulative aggregates such as subtotals:
SQ...]]> blog zhaoyu728 Sat, 13 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259838 SQL> desc member
名称 是否为空? 类型
----------------------------------------------------------------------------------- -------- ------
LAST_NAME ...]]> blog zhaoyu728 Fri, 12 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259839 Current_date is sensitive to the session time zone
The format mask ([+ | -] hh:mm) indicates the hours and minutes before or after UTC (Coordinated
Universal Time,
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'; blog zhaoyu728 Fri, 12 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259837 To display the three earner names and salaries from the emp table:

SQL> select rownum as rank,ename,sal from (select ename,sal from
2 emp order by sal desc)
3 where rownum<=4;

RANK ENAME SAL
...]]> blog zhaoyu728 Wed, 10 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259836 SQL> select * from copy_emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
736...]]> blog zhaoyu728 Wed, 03 Aug 2005 00:00:00 GMT http://space.itpub.net/8382469/viewspace-259834 SQL> select ename,hiredate,
2 to_char(next_day(add_months(hiredate,6),2),'fmdy ","fmddspth "of" fmmm ","rrrr') "Review" from emp;

ENAME HIREDATE Review
---------- -------------- ------------...]]> blog zhaoyu728 Tue, 26 Jul 2005 00:00:00 GMT