Data Warehouse Business Analyst :Knowledge On Data Warehouse Concept and Practice.Strong Communication Skill.Project Management ExperienceBanking And Cards IT System ExperienceOracle Development Experience A PlusTeradata Knowledge A PlusGood Communication In English Both Writing And OralData Warehouse DeveloperKnowledge And Experience On Data Warehouse Development.Strong Technical Expertise On Oracle Pl/Sql,Experience on UNIX operation and Shell programming

Data Warehouse Business Analyst :Knowledge On Data Warehouse Concept and Practice.Strong Communication Skill.Project Management ExperienceBanking And Cards IT System ExperienceOracle Development Experience A PlusTeradata Knowledge A PlusGood Communication In English Both Writing And OralData Warehouse DeveloperKnowledge And Experience On Data Warehouse Development.Strong Technical Expertise On Oracle Pl/Sql,Experience on UNIX operation and Shell programming

Position Description• This position is for occident super large-scale online e-commerce retailer. It will be responsible for the development and maintenance work on the back-end PL/SQL module, including discussion requirement with development team of our customer, study out design blue print, develop new functionality, and maintain on-hand functionality, and collaborate with testing team to fulfill test task, etc.• Besides, it still has to provide technical support to productio

Title1: PL/SQL DeveloperPosition DescriptionThis position is for occident super large-scale online e-commerce retailer. It will be responsible for the development and maintenance work on the back-end PL/SQL module, including discussion requirement with development team of our customer, study out design blue print, develop new functionality, and maintain on-hand functionality, and collaborate with testing team to fulfill test task, etc.Besides, it still has to provide technical support to

Title1: PL/SQL DeveloperPosition DescriptionThis position is for occident super large-scale online e-commerce retailer. It will be responsible for the development and maintenance work on the back-end PL/SQL module, including discussion requirement with development team of our customer, study out design blue print, develop new functionality, and maintain on-hand functionality, and collaborate with testing team to fulfill test task, etc.Besides, it still has to provide technical support to

假设有表（test）如下：Name1 Name2Jason MelissaJason ShashaJason ShermanMelissa JasonMelissa ShashaShasha JasonShasha MelissaShasha ShermanSherman JasonSherman ShashaJason Melissa和Melissa Jason被认为是重复项，所以删除重复项后的应该为：Name1 Name2Jason MelissaJason ShashaJason ShermanMelissa ShashaShasha Sherman请问各位这种结果用SQL该如何写啊？建表语句：create table test as (select'Jason' Name1, 'Melissa' Name2 from dual

Unix System Engineer / Unix系统工程师职位描述：部署和管理关键任务的Solaris/Linux系统Solaris/Linux系统性能分析与优化解决系统错误信息和警告编写脚本或小程序进行系统检测和维护借助于监控系统，预测并解决95%以上的系统问题遵从变更管理流程对生产和关键系统进行修改和优化轮班对系统提供24/7运营oncall支持Oncall时需保证系统资源充足职位要求计算机科学本科或相应学力4年以上Linux/Solaris系统管理经验1年以上SHELL(Bash, Perl, Awk, Sed, 等.)脚本经验能够对一些复杂技术领域进行清晰的描述（进

各位兄弟姐妹， 看下下面的问题该怎么解决啊？select (case when aremst.loccod ='P' thencount(distinct invlod.lodnum) when aremst.loccod ='V' thensum( (case when uniqueness_query.dtl_is_serialized =1 then ((pd1.len * pd1.wid * pd1.hgt)* (invdtl.untqty * 1.0 / invdtl.untcas)) else ((pd1.len * pd1.wid * pd1.hgt)* floor(invdtl.untqty * 1.0 / invdtl.untcas)+ ((pd2.l

各位兄弟姐妹， 看下下面的问题该怎么解决啊？select (case when aremst.loccod ='P' thencount(distinct invlod.lodnum) when aremst.loccod ='V' thensum( (case when uniqueness_query.dtl_is_serialized =1 then ((pd1.len * pd1.wid * pd1.hgt)* (invdtl.untqty * 1.0 / invdtl.untcas)) else ((pd1.len * pd1.wid * pd1.hgt)* floor(invdtl.untqty * 1.0 / invdtl.untcas)+ ((pd2.l

SQL> insert into jira.affectedobject2select * from dbo.affectedobject@jira;insert into jira.affectedobjectselect * from dbo.affectedobject@jiraORA-00997: illegal use of LONG datatype这个sql是从sql server 2008中复制dbo.affectedobject表的数据到oracle中的affectedobject,两个表的表结构如下：dbo.affectedobjectissuedid numeric(18,0) not null,testcontext ntext;SQL> desc jira.affectedobject;NameTypeNullable Default Comments-------- ------------ -

select rowid,trndte cnvtrndte,actcod,ship_line_id,ship_id,client_id,ordnum,ordlin,ordsln,prt_client_id,prtnum,carcodfrom ordactwhere (to_number(to_char(sysdate,'J'))- to_number(to_char(trndte,'J')) > 100)and rownum < 100and (ordnum is null or not exists(select 'x'from ordwhere ord.ordnum = ordact.ordnumand ord

各位兄弟姐妹：以下是我的操作环境和遇到的问题，还请各位多多帮忙！OS: Windows XP 英文操作系统Database Version: 10.2.0.1SQL> select * from v$nls_parameters;PARAMETERVALUE---------------------------------------------------------------- ----------------------------------------------------------------NLS_LANGUAGEAMERICANNLS_TERRITORY

Enclosed is the book which I want to share with everyone, I think it's very useful to you to improve your ability of writing SQland help you to write out the high performance SQl statement.I expect everyone enjoys it very much!:)[ 本帖最后由 jack198409 于 2009-4-21 08:38 编辑 ]