Archive

Archive for the ‘Database’ Category

PL/SQL developer 显示所有数据

May 24th, 2012 No comments

Categories: Database Tags:

IBM小型机AIX环境Oracle启动

October 20th, 2011 No comments

IBM小型机AIX环境Oracle启动

IBM小型机和磁盘阵列启动关闭顺序

 

启动顺序

关闭顺序

磁盘阵列

1

3

IBM小型机

2

2

双机热备(HA)

3(smitty clstart

1(smitty clsto[……]

Read more

Categories: Database Tags:

PowerDesigner连接oracle

August 12th, 2011 No comments

配置

菜单–》文件–》逆向工程–》Database…

在New Physical Data Model 窗口中,DBMS(Database Management System)选择 ORAC[……]

Read more

Categories: Database Tags:

建立一个与表B结构一样的A表(不包含B表数据或包含B表数据)

June 16th, 2011 No comments
  1. 建立一个与表B结构一样的A表(不包含B表数据或包含B表数据)

表B:


create table text nologging as

select * from text_new

wh[……]

Read more

Categories: Database Tags: ,

找出在text_new表中而不在text_old表(表中记录有空值)中的记录

June 16th, 2011 No comments

text_old表

text_new表



 

需求: 找出在text_new表中而不在text_old表(表中记录有空值)中的记录

结果一——使用in

 [……]

Read more

Categories: Database, Oracle Tags: ,

No result defined for action com.custody.action.system.chargeStandard.ChargeStandardAction and result error

October 5th, 2010 No comments

1.1     No result defined for action XXAction and result error

解决方案:

<!– 缴费标准管理Action –>

&[……]

Read more

Categories: Database Tags: ,