eygle.com   eygle.com
eygle.com  
 
留言簿 - Oracle Life - Powered by Eygle.com
eygle.com 我要留言
成就Oracle DBA职业生涯
昵称
内容 页: 1 - << < 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 > >> - 404
# 1949
Ate
To:
　　我可不可以土一点的回答说，从来处来？
From: Ate
2005.11.07 18:07
To: Ate
　　[COLOR=blue]不可以[/COLOR]
From: eygle
2005.11.07 18:28
版主选项: 回复 编辑
# 1947
warehouse
To:
　　能否帮忙提供一个sts and tk的下载连接？多谢！
From: warehouse
2005.11.07 16:24
To: warehouse
　　[COLOR=blue]没研究过,不能[/COLOR]
From: eygle
2005.11.07 17:08
版主选项: 回复 编辑
# 1945
蓓蓓


来自: 江苏南京

To:
　　你的网站感觉很不错
尤其是一些很好的文章
我把它在我的个人空间里做了一个链接
因为很喜欢
呵呵
请不要介意
谢谢
期待ing
From: 蓓蓓
2005.11.07 06:35
To: 蓓蓓
　　[COLOR=blue]谢谢支持,欢迎链接![/COLOR]
From: eygle
2005.11.07 07:12
版主选项: 回复 编辑
# 1944
donniejeck


来自: 中国。重庆

To: eygle
　　eygle:
 
 了解一下，如何用一个启动脚本来启动两个以上的例程呢？操作平台　是windows 2000SERVER.在ＩＴＰＵＢ上看过一些有关在ＵＮＩＸ平台下启动的脚本，有点不太明白。请不吝指教。行谢过了，ＭＳＮ上看到你老忙，就到这来了。
From: donniejeck
2005.11.06 23:19
To: donniejeck
　　[COLOR=blue]
如果你不习惯写一个脚本，可以把你上次写的脚本写两个，在启动脚本里分别调用这2个脚本。
[/COLOR]
From: eygle
2005.11.07 05:37
版主选项: 回复 编辑
# 1943
qsx
To:
　　听说你可以搞oracle方面的培训，那我想找你帮我培训，怎么跟你联系？
From: qsx
2005.11.06 19:22
To: qsx
　　[COLOR=blue]
发邮件给我eygle.com@gmail.com
[/COLOR]
From: eygle
2005.11.06 21:14
版主选项: 回复 编辑
# 1942
qsx
To: eygle
　　老大你好，再问你一些问题：
1、看了你写的一些文章，意思是把oracle里的内容通过WINDOWS系统放到internet让别人浏览，这一个工作对于非专业的人来说很困难，如果用SQL Server要相对容易得多，是吗？
2、我是一个oracle8I DBA，但从没系统的学过oracle，都是在工作中慢慢的学习，也没学过SQL Server，请问能不能把oracle8i里的表内容转到SQL Server2000里面？如果能，用什么软件？用什么方法？或者告诉我学习哪本书。
3、把数据库里的内容放到自己的网站上，让别人能在网上查询某些相关内容，应该看哪些书？（我的工作规定我只能用windows操作系统，并且目前我还不会建网站，正准备学习建站）
From: qsx
2005.11.06 19:20
To: qsx
　　[COLOR=blue]
1.Oracle和SQL Server在你说的应用上，没用任何难度的区别，一样的简单易用。
2.转换工具Oracle、SQL都有，Migration Workbench 、 DTS
3.书不知道，你说的其实是非常简单的东西，不需要书来讲的吧。
[/COLOR]
From: eygle
2005.11.07 05:36
版主选项: 回复 编辑
# 1941
qsx
To: eygle
　　老大你好，问你两个问题：
1、能不能在网上下载到oracle10g软件？如果能，网址是？
1、在oracle8i里的表能用exp实用程序导出，然后用imp实用程序导入到oracle 10g里吗？
From: qsx
2005.11.06 18:51
To: qsx
　　[COLOR=blue]
1. http://otn.oracle.com 上可以下载
这里有快速链接:
http://www.eygle.com/index-dbalink.php
2.可以
[/COLOR]
From: eygle
2005.11.07 05:33
版主选项: 回复 编辑
# 1940
lily
To: eygle
　　好久没来了 但支持会一如既往的过来蹦蹦
From: lily
2005.11.06 18:23
版主选项: 回复 编辑
# 1939
lala
To:
　　
今天被人骗了，一大早坐车跑到市中心，傻不拉几什么也没干又回来了
中午吃完午饭去买了件衣服，后来又去超市，买了些水果，看到有漱口水，就买了一瓶蓝色的李施德林，两三年前曾经买过蓝色的，当时刚把漱口水灌到嘴里就吐出来了，后来马上送人了，前一阵子买了一瓶橙色的，勉强可以用，用了大半瓶的时候我信心大增，跟人讲我要换蓝色的了，再后来就是晚上做梦梦到因为漱口水太辣，舌头给溃疡了，不知道这次用了会不会真的舌头溃疡
From: lala
2005.11.04 23:34
To: lala
　　[COLOR=blue]漱口水没用过，听说是资本主义腐朽生活的体现...[/COLOR]
From: eygle
2005.11.05 09:03
版主选项: 回复 编辑
# 1938
remen
To: eygle
　　老大，又来麻烦您了，嘿嘿！先谢谢！
我现在系统奇慢，仔细看后发现是个查询导致的，脚本如下：
select/*+ ORDERED */ --qv.lj,
 'v' "BJ",
  bso.department_id department_id,
  bso.standard_operation_id process_id,
  ppf.person_id person_id,
  qv.CHARACTER31 "BC",
  cih.workshop_name "CJ",
  'N' "SFBZ",
  trunc(to_date(qv.CHARACTER17, 'YYYY/MM/DD') "CLRQ",
  qv.CHARACTER27 "YG" ,
  nvl(qv.CHARACTER30,qv.CHARACTER25) "CHP",
  nvl(qv.CHARACTER14,'A'"LJGXDM",
  decode(qv.CHARACTER14,NULL,nvl(qv.CHARACTER26,qv.CHARACTER20),nvl(nvl(qv.CHARACTER29,qv.CHARACTER26),qv.CHARACTER20) ) "GXDM",
  qv.CHARACTER2"SZCG",
  qv.WIP_ENTITY_ID "JOB",
  decode(cih.inspection_code,'HGP',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "HGP",
  decode(cih.inspection_code,'CP',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "CP",
  decode(cih.inspection_code,'FP',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "FEP",
  decode(cih.inspection_code,'SF',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "SAOF",
  decode(cih.inspection_code,'FS',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "FANS",
  decode(cih.inspection_code,'FG',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "FANG",
  decode(cih.inspection_code,'LT',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "LIANT",
  decode(cih.inspection_code,'SSBLCP',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "SSCP",
  decode(cih.inspection_code,'SSBLFP',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "SSFP",
  decode(cih.inspection_code,'DCZT',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "DACZT",
  decode(cih.inspection_code,'SHF',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "SHUAIF",
  decode(cih.inspection_code,'SH',round(round(to_number(qv.CHARACTER7, '9999999999999999999999999999999.999999'*cpp1.per_price,8)/cpp2.per_price,8),0) "SUNH"
 
from qa_results qv,
 cux_inspection_headers cih,
 cux_inspection_lines cil,
 cux_process_prices cpp1,
 cux_process_prices cpp2,
 bom_standard_operations bso,
 per_people_f ppf
where qv.CHARACTER8 = cil.reason_code
and cih.header_id = cil.header_id
and qv.CHARACTER28 is null
and qv.CHARACTER27 is not null
and qv.CHARACTER8 is not null
and qv.plan_id=101
--and nvl(qv.lj,'无' = '无'
and decode(qv.CHARACTER14,NULL,nvl(qv.CHARACTER26,qv.CHARACTER20),nvl(nvl(qv.CHARACTER29,qv.CHARACTER26),qv.CHARACTER20) ) = cih.process_code

注意最后一个条件，如果不加这个条件就会很快，如果加上就会很慢。估计是这个函数反复比较导致的，但是我这个函数还必须用，有什么办法优化一下呢？
qa_results的脚本如下：
-- Create table
create table QA.QA_RESULTS
(
  COLLECTION_IDNUMBER not null,
  OCCURRENCE NUMBER not null,
  LAST_UPDATE_DATE DATE not null,
  QA_LAST_UPDATE_DATEDATE not null,
  LAST_UPDATED_BYNUMBER not null,
  QA_LAST_UPDATED_BY NUMBER not null,
  CREATION_DATEDATE not null,
  QA_CREATION_DATE DATE not null,
  CREATED_BY NUMBER not null,
  QA_CREATED_BYNUMBER not null,
  LAST_UPDATE_LOGINNUMBER,
  REQUEST_ID NUMBER,
  PROGRAM_APPLICATION_ID NUMBER,
  PROGRAM_ID NUMBER,
  PROGRAM_UPDATE_DATEDATE,
  TRANSACTION_NUMBER NUMBER,
  TXN_HEADER_IDNUMBER,
  ORGANIZATION_IDNUMBER not null,
  PLAN_IDNUMBER not null,
  SPEC_IDNUMBER,
  TRANSACTION_ID NUMBER,
  DEPARTMENT_IDNUMBER,
  TO_DEPARTMENT_ID NUMBER,
  RESOURCE_IDNUMBER,
  QUANTITY NUMBER,
  ITEM_IDNUMBER,
  UOMVARCHAR2(3),
  REVISION VARCHAR2(3),
  SUBINVENTORY VARCHAR2(10),
  LOCATOR_ID NUMBER,
  LOT_NUMBER VARCHAR2(30),
  SERIAL_NUMBERVARCHAR2(30),
  COMP_ITEM_ID NUMBER,
  COMP_UOM VARCHAR2(3),
  COMP_REVISIONVARCHAR2(3),
  COMP_SUBINVENTORYVARCHAR2(10),
  COMP_LOCATOR_IDNUMBER,
  COMP_LOT_NUMBERVARCHAR2(30),
  COMP_SERIAL_NUMBER VARCHAR2(30),
  WIP_ENTITY_IDNUMBER,
  LINE_IDNUMBER,
  TO_OP_SEQ_NUMNUMBER,
  FROM_OP_SEQ_NUMNUMBER,
  VENDOR_IDNUMBER,
  RECEIPT_NUMVARCHAR2(30),
  PO_HEADER_ID NUMBER,
  PO_RELEASE_IDNUMBER,
  PO_LINE_NUMNUMBER,
  PO_SHIPMENT_NUMNUMBER,
  CUSTOMER_IDNUMBER,
  SO_HEADER_ID NUMBER,
  RMA_HEADER_IDNUMBER,
  PROJECT_ID NUMBER,
  TASK_IDNUMBER,
  STATUS NUMBER,
  TRANSACTION_DATE DATE,
  CHARACTER1 VARCHAR2(150),
  CHARACTER2 VARCHAR2(150),
  CHARACTER3 VARCHAR2(150),
  CHARACTER4 VARCHAR2(150),
  CHARACTER5 VARCHAR2(150),
  CHARACTER6 VARCHAR2(150),
  CHARACTER7 VARCHAR2(150),
  CHARACTER8 VARCHAR2(150),
  CHARACTER9 VARCHAR2(150),
  CHARACTER10VARCHAR2(150),
  CHARACTER11VARCHAR2(150),
  CHARACTER12VARCHAR2(150),
  CHARACTER13VARCHAR2(150),
  CHARACTER14VARCHAR2(150),
  CHARACTER15VARCHAR2(150),
  CHARACTER16VARCHAR2(150),
  CHARACTER17VARCHAR2(150),
  CHARACTER18VARCHAR2(150),
  CHARACTER19VARCHAR2(150),
  CHARACTER20VARCHAR2(150),
  CHARACTER21VARCHAR2(150),
  CHARACTER22VARCHAR2(150),
  CHARACTER23VARCHAR2(150),
  CHARACTER24VARCHAR2(150),
  CHARACTER25VARCHAR2(150),
  CHARACTER26VARCHAR2(150),
  CHARACTER27VARCHAR2(150),
  CHARACTER28VARCHAR2(150),
  CHARACTER29VARCHAR2(150),
  CHARACTER30VARCHAR2(150),
  CHARACTER31VARCHAR2(150),
  CHARACTER32VARCHAR2(150),
  CHARACTER33VARCHAR2(150),
  CHARACTER34VARCHAR2(150),
  CHARACTER35VARCHAR2(150),
  CHARACTER36VARCHAR2(150),
  CHARACTER37VARCHAR2(150),
  CHARACTER38VARCHAR2(150),
  CHARACTER39VARCHAR2(150),
  CHARACTER40VARCHAR2(150),
  CHARACTER41VARCHAR2(150),
  CHARACTER42VARCHAR2(150),
  CHARACTER43VARCHAR2(150),
  CHARACTER44VARCHAR2(150),
  CHARACTER45VARCHAR2(150),
  CHARACTER46VARCHAR2(150),
  CHARACTER47VARCHAR2(150),
  CHARACTER48VARCHAR2(150),
  CHARACTER49VARCHAR2(150),
  CHARACTER50VARCHAR2(150),
  CHARACTER51VARCHAR2(150),
  CHARACTER52VARCHAR2(150),
  CHARACTER53VARCHAR2(150),
  CHARACTER54VARCHAR2(150),
  CHARACTER55VARCHAR2(150),
  CHARACTER56VARCHAR2(150),
  CHARACTER57VARCHAR2(150),
  CHARACTER58VARCHAR2(150),
  CHARACTER59VARCHAR2(150),
  CHARACTER60VARCHAR2(150),
  CHARACTER61VARCHAR2(150),
  CHARACTER62VARCHAR2(150),
  CHARACTER63VARCHAR2(150),
  CHARACTER64VARCHAR2(150),
  CHARACTER65VARCHAR2(150),
  CHARACTER66VARCHAR2(150),
  CHARACTER67VARCHAR2(150),
  CHARACTER68VARCHAR2(150),
  CHARACTER69VARCHAR2(150),
  CHARACTER70VARCHAR2(150),
  CHARACTER71VARCHAR2(150),
  CHARACTER72VARCHAR2(150),
  CHARACTER73VARCHAR2(150),
  CHARACTER74VARCHAR2(150),
  CHARACTER75VARCHAR2(150),
  CHARACTER76VARCHAR2(150),
  CHARACTER77VARCHAR2(150),
  CHARACTER78VARCHAR2(150),
  CHARACTER79VARCHAR2(150),
  CHARACTER80VARCHAR2(150),
  CHARACTER81VARCHAR2(150),
  CHARACTER82VARCHAR2(150),
  CHARACTER83VARCHAR2(150),
  CHARACTER84VARCHAR2(150),
  CHARACTER85VARCHAR2(150),
  CHARACTER86VARCHAR2(150),
  CHARACTER87VARCHAR2(150),
  CHARACTER88VARCHAR2(150),
  CHARACTER89VARCHAR2(150),
  CHARACTER90VARCHAR2(150),
  CHARACTER91VARCHAR2(150),
  CHARACTER92VARCHAR2(150),
  CHARACTER93VARCHAR2(150),
  CHARACTER94VARCHAR2(150),
  CHARACTER95VARCHAR2(150),
  CHARACTER96VARCHAR2(150),
  CHARACTER97VARCHAR2(150),
  CHARACTER98VARCHAR2(150),
  CHARACTER99VARCHAR2(150),
  CHARACTER100 VARCHAR2(150),
  LPN_ID NUMBER,
  CONTRACT_IDNUMBER,
  CONTRACT_LINE_ID NUMBER,
  DELIVERABLE_ID NUMBER
)
tablespace QAD
  pctfree 10
  pctused 40
  initrans 10
  maxtrans 255
  storage
  (
  initial 16K
  next 4M
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
-- Create/Recreate indexes
create index QA.QA_RESULTS_CUX_N1 on QA.QA_RESULTS (CHARACTER14, CHARACTER20, CHARACTER25, CHARACTER26, CHARACTER28, CHARACTER29, CHARACTER30)
  tablespace QAX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
  initial 40K
  next 43152K
  minextents 1
  maxextents 505
  pctincrease 0
  );
create index QA.QA_RESULTS_CUX_N2 on QA.QA_RESULTS (CHARACTER14, CHARACTER20, CHARACTER26, CHARACTER25, CHARACTER27, CHARACTER29, CHARACTER30)
  tablespace QAX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
  initial 40K
  next 43152K
  minextents 1
  maxextents 505
  pctincrease 0
  );
create index QA.QA_RESULTS_CUX_N3 on QA.QA_RESULTS (CHARACTER28)
  tablespace QAX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
  initial 40K
  next 12784K
  minextents 1
  maxextents 505
  pctincrease 0
  );
create index QA.QA_RESULTS_CUX_N4 on QA.QA_RESULTS (CHARACTER27)
  tablespace QAX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
  initial 40K
  next 12784K
  minextents 1
  maxextents 505
  pctincrease 0
  );
create index QA.QA_RESULTS_N1 on QA.QA_RESULTS (ITEM_ID, ORGANIZATION_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N2 on QA.QA_RESULTS (SERIAL_NUMBER, ORGANIZATION_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N3 on QA.QA_RESULTS (COMP_SERIAL_NUMBER, ORGANIZATION_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N4 on QA.QA_RESULTS (LOT_NUMBER, ORGANIZATION_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N5 on QA.QA_RESULTS (SO_HEADER_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 4M
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N6 on QA.QA_RESULTS (COLLECTION_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N7 on QA.QA_RESULTS (TXN_HEADER_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create index QA.QA_RESULTS_N8 on QA.QA_RESULTS (CONTRACT_ID, CONTRACT_LINE_ID, DELIVERABLE_ID)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );
create unique index QA.QA_RESULTS_U1 on QA.QA_RESULTS (PLAN_ID, COLLECTION_ID, OCCURRENCE)
  tablespace QAX
  pctfree 10
  initrans 11
  maxtrans 255
  storage
  (
  initial 16K
  next 256K
  minextents 1
  maxextents unlimited
  pctincrease 0
  );

呵呵，脚本比较长，还请老大息怒，帮我仔细看看，感动阿....................
From: remen
2005.11.04 04:28
To: remen
　　[COLOR=blue]
晕，搞那么长...
是个图书下载系统么?

没看明白在判断什么，能否增加个字段，记录最大章节数，或者你需要判断的内容，减少函数判断，否则肯定影响性能的。
[/COLOR]
From: eygle
2005.11.05 09:02
版主选项: 回复 编辑
页: 1 - << < 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 > >> - 404
我要留言
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com