r******t
发帖数: 629 | 1 据说先training3到4个星期，这期间不付费，然后给发project，project期间给工资～
神奇啊！这个是怎么回事？貌似涉及的项目还很多～
This is Yitong from VForce InfoTech. It was a pleasure speaking with you
today.
I read your resume and feel that you could be a good fit for a position with
VForce InfoTech.
We offer full time positions with H1B, Green card or TN Sponsorship in the
all over the U.S and Canada . Please look through our open positions such as
Business Analyst, Data Analyst, Website Developer, SQL/PLSQL Developer on
our career page: http://w... 阅读全帖 |
|
l*******n
发帖数: 53 | 2 芝加哥Northern Trust银行招数名consultants. J2EE/Oracle PLSQL. 有工作经验优先
。可办H1B和绿卡。[email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=String.fromCharCode(c);}s=document.createTextNode(s);l.parentNode.replaceChild(s,l);}}catch(e){}})();
/* ]]> */ |
|
h*****6
发帖数: 866 | 3 有人找到remote 的 Oracle DBA 或者 PLSQL developer的工作吗？ |
|
i*******r
发帖数: 166 | 4 有美国的计算机学位，3年公司C++/C#经验，4年PLSQL developer经验, 有绿卡
想找一份在家远程的收入，时间 M-F 8:00-5:00 都行, 除了Friday上午不available
求建议，怎么找？ |
|
w*******m
发帖数: 106 | 5 Successful candidates should have a MS degree or above in Computer Science,
Electrical Engineering or Applied Mathematics with hands on programming
experience in C++/Java/Unix Shell, R, Python and Oracle PLSQL. Knowledge in
cloud computing, virtualization, Hadoop and noSQL databases is highly
desired. |
|
h******a
发帖数: 2 | 6 A global software vendor is looking for a Senior Developer or Junior
Architect to join the US division. Experience in insurance industry is a big
plus.This is a great opportunity for those experienced developer who wants
to grow into senior management position or customer facing position. Strong
communication and personal skills are must have.
40-50% travel is expected. Flexible work location.
If you are interested in the position, please send me an email: ericshenus@
gmail.com
Detail Job Descri... 阅读全帖 |
|
c*********n
发帖数: 2 | 7 Sr. Java Developer
Possesses and applies a comprehensive knowledge across key tasks and high
impact assignments. Plans and leads major technology assignments. Evaluates
performance results and recommends major changes affecting short-term
project growth and success.
Work experience and skills
- Java Programming, Design Pattern
· Perform Unit Testing in local/development environments and full
regression testing in staging and production
· Development of XML and Web Services Technologies,
· XML ... 阅读全帖 |
|
l*******n
发帖数: 53 | 8 A Chicago based bank is looking for one junior and two senior Java/J2EE/
PLSql developers. The required skills are J2EE, Spring and Oracle PL/SQL.
Sponsorship is available. Please email c********[email protected] if interested. |
|
h*****6
发帖数: 866 | 9 有人找到remote 的 Oracle DBA 或者 PLSQL developer的工作吗？ |
|
i*******r
发帖数: 166 | 10 有美国的计算机学位，3年公司C++/C#经验，4年PLSQL developer经验, 有绿卡
想找一份在家远程的收入，时间 M-F 8:00-5:00 都行, 除了Friday上午不available
求建议，怎么找？ |
|
|
F****n
发帖数: 746 | 12 Please check you mail, thanks! |
|
m*****i
发帖数: 2325 | 13 一个人老打不起精神。 信息量也不够多。
我的方向 data warehouse， oracle sql plsql， unix shell， informtica。 我有
一点资料可以share。
站内短信联系。 |
|
s******n
发帖数: 340 | 14 我想搬来三藩。想请大家指点一下，我这样背景在三藩能在哪种公司找到工作，大体收
入能有多少。过去几年经常飞，有点累了，想在local 找份工作。
我现在在一家咨询公司里做Manager, 有8年工作经验， 过去几年主要做System
Deployment, System Integration 的 implementation，还有Utility 公司的Asset
Analytics （不是金融行业的Asset）。会点SAP， Spatial Analysis, Oracle 数据库
和 BI。以前编程主要用过.Net 和Oracle PLSQL.
希望大家不吝赐教，十分感谢。 |
|
|
W**********s
发帖数: 42 | 16 please send resume with salary requirements to g*****[email protected] if you are
interested.
=================================================
Job Description:
This position is the senior DBA specializing in Oracle products in a UNIX
environment. The position supports infrastructure databased and application
operation in a federal agency data center at Washington, DC. The candidate
should be able to work in dynamic environment with self-improving skills.
The candidate must be a good team player and... 阅读全帖 |
|
i*****c
发帖数: 60 | 17 No, sharepoint has been open a while.
2 new are open, and another one business analyst is open.
I am not hiring manager, but all are in this group/department.
Don't worry too much all requirements.
I know how much every position they want to pay :-).
Sharepoint:
Bachelor's Degree and 5-7 years of Software development experience either
in .Net and SharePoint.
· Strong understanding of different software development life cycle
methodologies (waterfall, iterative) and contemporary software ... 阅读全帖 |
|
B*****g
发帖数: 34098 | 18 没有，去年把一波plsql的从组里分出去了，现在把另外一个office的java developer
划过来了。除了VP退休，他升不了了。 |
|
|
|
|
|
|
|
j***a
发帖数: 10844 | 25 mi = might, not me, haha. |
|
c*h
发帖数: 33018 | 26 收入：
【合集】找工作,找学校, 学校挂身份,签证,绿卡,公民 |
|
|
|
|
|
|
|
|
B*****g
发帖数: 34098 | 34 DC的网友们不要光是琢磨呀，尤其是不需要H1B的，照着我发的资料下苦功学，半年肯定
有工作。不过哥还是那句话，学技术首推java，你有能力学java，学之；你学不了编程
，Oracle数据库是你不二的选择。我和一些专家人探讨过（包括大师），基本上认为直
接去上证书班不是最佳选择。打好SQL-PLSQL的基础还是很重要的。这个在我发的link都
有资料乃至视屏，这个就不需要再讲了，咱们讲10有89还不如小布老师讲的。
学习完了SQL实际上就可以找工作了，当然找DBA工作还不行。但是可以一边找一边学。
而且哥既不看好新手找DBA工作，也不看好DBA工作前景。不过这些对于初学者并不是关
键，多说不宜。先踏踏实实学一阵。
当然，也可能有些同学已经有一定基础了，想烤几个证，由于oracle证书的特殊性，你
也不用琢磨了，直接去金马培训报名
妈上 |
|
f*******d
发帖数: 12693 | 35 我估计是前几天看见local有人标900刀的24-70，去了一封信，之后就开始不断收到spa
m，而且我不知道该怎么过滤法，包子求教。
来信基本就是这样的，而且所有的信息都不断换，我根本没法找过滤的pattern，咋办？
from :.cobra-info._com:. c******[email protected]
reply-to m*****[email protected]
to m****[email protected]
date Fri, Oct 7, 2011 at 9:43 AM
subject Protect your..familys health - without..COBRA-- |
|
t****e
发帖数: 6 | 36 DBA, PLSQL, Reporting, JAVA, .net,
Quality Assurance, Business Analyst ... much more
Send your resume today : s***[email protected]
BRITSTAN TECHNOLOGY
People are the only difference?
451 West Lambert Road #214
Brea, CA 92821
714-255-9111
s***[email protected] |
|
d****i
发帖数: 397 | 37 do you remember the book name? also do you have some examples on hand? |
|
v*****n
发帖数: 4 | 38 傻瓜级的更好。
因为偶是初次接触数据库方面的东东：）
谢大侠了~~~~~~~~~ |
|
t****e
发帖数: 6 | 39 That is what I mean, It will be nice if I can speak out all those Access
generations, which prove you are proficient about those.
They don't really care about those Access forms, reports ... etc. since the
main DB is still on Oracle. I am consident about my Oracle and PLSQL, don't
think too much problem about Access,(they have their standar Java interface
and Crystal Report Server).
But what can I say about those Access? I can't just say too easy ....
I am curious by myself also, how old is this |
|
w*r
发帖数: 2421 | 40 I am using Oracle 10g, java store procedure is way more efficient than PLSQL
stored procedure. Indexes were build on the columns I tried to join.
Basically, if the larger table has full statistics, then the optimizer
choose full tablescan for the larger table and hash join. If I delete the
statistics on larger table, only leave the indexes statistics, the optimizer
choose bitmap index join first and then access table by rowid by the result
of the join:D
because |
|
I******e
发帖数: 101 | 41 TB1 200K rows,
TB2 9M rows,
Let us assume each row in 1K, then TB1 is 200MB, TB2 is 9GB. Assuming that
you have decent IO capacity, like 50MB/s, then the table scan should only
take
((9 GB) + (200 MB)) / (50 MB/s) = 188.32s, around 3 minutes.
So, table scan should not cause the problem.
If you have enough memory for hash join, then hash join should be much
faster than any index join. Are you using automatic memory management or
fixed memory management in 10g?
PLSQL
optimizer
result |
|
B*****g
发帖数: 34098 | 42 你这个只能搞出sql，不能直接run。
Oracle PLSQL似乎搞不出来前N个（N是parameter），不知道把java搞上能不能行。 |
|
f********n
发帖数: 33 | 43 “现在我要用 IN，即使sub里面只有一个return，至少１０分钟还没有结束。要是用 =，
只要几秒钟。试过各种hint，都没能成功。”
我以前做过优化，是Oracle 8，9，现在的产品都不是很清楚了，所以我的想法，楼主
仅当建议听听。“至少１０分钟还没有结束”可能是执行了全表搜索之类的费时操作（
即使你是用PLSQL之类优化过了），一种方法是对关键字做索引，但这种方法对于很大
的table可能还是有问题，即使你看了执行计划里面，仍然会有这种情况。那么另一种
情况就是优化你的语句，我记得Oracle里面有个设置是可以设置每次系统一次可以读取
多少数据记录块，如果默认的数值相对太少了，也会导致检索的时候频繁读盘，最后是
系统强制全表搜索的情况，你可以设置这个参数。另外一个方案就是把大表拆散分散存
储，不过貌似你的情况还没有到这种地步。还有一种可能，是你的SQL语句书写的问题
，一般上从关系代数（不记得具体名字了）上检查一下优化一下，也是可能的，我就有
碰到过要查询1小时的SQL，优化过只要5分钟不到的情况。
祝你顺利。 |
|
B*****g
发帖数: 34098 | 44 和sql３差不多, 除了month还有year，sql没答出来，用plsql作的，结果工资少了
一万.
(***应该可以假设（year，month，product＿id） unique***, 不过最好别这样假设)
YEAR, MONTH, PRODUCT_ID, PRODUCT_QTY
2007, 1, 1, 2
2007, 1, 2, 3
2007, 2, 1, 2
2007, 2, 2, 3
2007, 3, 1, 2
2007, 3, 2, 3
......
Need:
YEAR, PRODUCT_ID, QUATER1_QTY,QUATER2_QTY,QUATER3_QTY, QUATER4_QTY
......
NND, 第一次竟然发错了, 现在应该改好了 |
|
B*****g
发帖数: 34098 | 45 【 以下文字转载自 JobHunting 讨论区 】
发信人: yrymaomao (轻风冷露), 信区: JobHunting
标 题: Re: 精通SQL,VB,JAVA,C++(optional)的developer多么? (转载)
发信站: BBS 未名空间站 (Thu Jan 15 10:26:44 2009)
Java as a language is simple, j2ee is complex.
VB as a language is simple, .net is so so.
c++ is a little bit harder, but it is optional. haha
sql is too simple to be mentioned if you do not need some non standarded
advanced feature in some special edition of sql, such as PLsql. haha |
|
u*********8
发帖数: 18 | 46 各位大牛， 我有一个函数， 生产用的， 运行没问题，就是太慢了，整个函数要20秒
，放web 就30秒了。 哪位大牛给
改改吧，多谢了。急用呢！
SQL> create or replace function ws_selectAwardCount_test
2 (
3 p_barcode varchar2
4 ) return VARCHAR2 is
5
6 v_id_of_job varchar2(100);
7 v_total_scanned number:=0;
8
9 v_barcode varchar2(32);
10
11 v_counter number:=0;
12
13 v_begin timestamp;
14 v_begin2 timestamp;
15 v_end timestamp;
16 v_end2 timestamp;
17 v_diff |
|
u*********8
发帖数: 18 | 47 没人帮忙，咋办呢， 有无办法可以重奖帮忙的人呢？ |
|
B*****g
发帖数: 34098 | 48 create index on upper(convert(id_of_row,'US7ASCII')) |
|
c*****d
发帖数: 6045 | 49 应该是没用上索引
把那个where upper()=upper()语句改一下 |
|
u*********8
发帖数: 18 | 50 太感谢了， 看来 beijing 这人真是大牛啊！该咋感谢呢？ 小弟能办到的， 都去办。 |
|
