from:"Viktor"

UTL_FILE question

2004-01-30 Thread Viktor

Hello,
Ihave a procedure that open a cursor anddumps some data for last 24 monthsto a file. The date range is static condition definedinside the cursor. Procedure is working great, but Iwhat I'm havingproblemfiguring outisif there is a way to create not one file with all the data, but multiple files with monthly sets of data. This way data formonth1 is created as filename_012002.txt and so forth. 
Thanks much!
Viktor

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

SQL Query Problem(possilble duplicate send, Sorry!)

2004-01-13 Thread Viktor

Hello all,I am working with a query that does some counts. I've hit a brick wall and can't get passed trying to figure out how I can make the query show percentages %.Here is the query:select "COUNTRY", count ("MSS") "COUNT_MSS"FROM (SELECT DISTINCTms.journal_id||ms.yr_of_issue||ms.ms_sequence_no||ms.check_char MSS,m.RVIEWNUM_INIT_INITSET||M.RVIEWNUM_INIT_SITE||M.RVIEWNUM_INITSEQ "NAME_ID",NVL(a.country,'USA') "COUNTRY"FROM mscript ms, reviewms m, address a, journal jWHERE (m.first_return between '01/01/2003' and '12/31/2003' or m.second_return between '01/01/2003 and '12/31/2003' or m.second_return between '01/01/2003 and '12/31/2003') and ms.journal_id = j.journal_id and M.MSNUMBER_JCO!
DE
 = ms.journal_id and M.MSNUMBER_YRISSUE = ms.yr_of_issue and M.MSNUMBER_MS_SEQNO = ms.ms_sequence_no and M.MSNUMBER_CKCHAR = ms.check_char and m.RVIEWNUM_INIT_INITSET = a.namekey_init_initset(+) and M.RVIEWNUM_INIT_SITE = a.namekey_init_site(+) and M.RVIEWNUM_INITSEQ = a.namekey_initseq(+) and a.addtype_addrstyp in ('m', 'p') and a.addtype_typeno = 1 and (a.addr_end_date is null or a.addr_end_date  sysdate) and (first_recommend not in ('1','2','3','4','5','6','7','8','9','F','P','N','S','u') or second_recommend not in
 ('1','2','3','4','5','6','7','8','9','F','P','N','S','u'))order by 1)GROUP BY ROLLUP(COUNTRY)And the output:COUNTRY COUNT_MSSAUSTRALIA 1 AUSTRIA 2
 BELGIUM 4 CANADA 20 CHILE 1 CHINA  3
 CZECH REPUBLIC 1 DENMARK 4 ENGLAND 10 
 46Is there a way I can also display a percentage column, that is the percentage of the total in the same SQL statement?As always thanks so much!Viktor
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Re: SQL Query Problem(possilble duplicate send, Sorry!)

2004-01-13 Thread Viktor

Thanks for your reply! Will try it now. Will this work in 8i?

Viktor

Bricklen Anderson [EMAIL PROTECTED] wrote:
Viktor wrote: Hello all,  I am working with a query that does some counts. I've hit a brick wall  and can't get passed trying to figure out how I can make the query show  percentages %.  Here is the query:  select "COUNTRY", count ("MSS") "COUNT_MSS" FROM ( SELECT DISTINCT ms.journal_id||ms.yr_of_issue||ms.ms_sequence_no||ms.check_char MSS, m.RVIEWNUM_INIT_INITSET||M.RVIEWNUM_INIT_SITE||M.RVIEWNUM_INITSEQ  "NAME_ID", NVL(a.country,'USA') "COUNTRY" FROM mscript ms, reviewms m, address a, journal j WHERE (m.first_return between '01/01/2003' and '12/31/2003' or m.second_return between '01/01/2003 and '12/31/2003' or m.second_return between '01/01/2003 and '12/31/2003') and ms.journal_id = j.journal_id !
and
 M.MSNUMBER_JCO! DE = ms.journal_id and M.MSNUMBER_YRISSUE = ms.yr_of_issue and M.MSNUMBER_MS_SEQNO = ms.ms_sequence_no and M.MSNUMBER_CKCHAR = ms.check_char and m.RVIEWNUM_INIT_INITSET = a.namekey_init_initset(+) and M.RVIEWNUM_INIT_SITE = a.namekey_init_site(+) and M.RVIEWNUM_INITSEQ = a.namekey_initseq(+) and a.addtype_addrstyp in ('m', 'p') and a.addtype_typeno = 1 and (a.addr_end_date is null or a.addr_end_date  sysdate) and (first_recommend not in  ('1','2','3','4','5','6','7','8','9','F','P','N','S','u') or second_recommend not in  ('1','2','3','4','5','6','7','8','9','F','P','N','S','u')) order by 1) GROUP BY ROLLUP(COUNTRY)  And the output:  COUNTRY COUNT_MSS  AUSTRALIA 1 AUSTRIA 2 BELGIUM 4 CANADA 20 CHILE 1 CHINA 3 CZECH REPUBLIC 1 !
DENMARK
 4 ENGLAND 10 46  Is there a way I can also display a percentage column, that is the  percentage of the total in the same SQL statement?  As always thanks so much!  Viktor Will this work? (ran a simple test case that worked, although this may not):select country,count_mss,round((count_mss/decode(overall_total,0,1,overall_total))*100)||'%' pctfrom (select "COUNTRY",count ("MSS") over (partition by "MSS") "COUNT_MSS",count("MSS") over () overall_totalFROM (SELECT DISTINCTms.journal_id||ms.yr_of_issue||ms.ms_sequence_no||ms.check_char MSS,m.RVIEWNUM_INIT_INITSET||M.RVIEWNUM_INIT_SITE||M.RVIEWNUM_INITSEQ "NAME_ID",NVL(a.country,'USA') "COUNTRY"FROM mscript ms, reviewms m, address a, journal jWHERE (m.first_return between '01/01/2003' and '12/31/2003'or m.second_return between '01/01/2003 and '12/31/2003'or m.second_return!
 between
 '01/01/2003 and '12/31/2003')and ms.journal_id = j.journal_idand M.MSNUMBER_JCO! DE = ms.journal_idand M.MSNUMBER_YRISSUE = ms.yr_of_issueand M.MSNUMBER_MS_SEQNO = ms.ms_sequence_noand M.MSNUMBER_CKCHAR = ms.check_charand m.RVIEWNUM_INIT_INITSET = a.namekey_init_initset(+)and M.RVIEWNUM_INIT_SITE = a.namekey_init_site(+)and M.RVIEWNUM_INITSEQ = a.namekey_initseq(+)and a.addtype_addrstyp in ('m', 'p')and a.addtype_typeno = 1and (a.addr_end_date is nullor a.addr_end_date  sysdate)and (first_recommend not in ('1','2','3','4','5','6','7','8','9','F','P','N','S','u')or second_recommend not in ('1','2','3','4','5','6','7','8','9','F','P','N','S','u'))order by 1)GROUP BY ROLLUP(COUNTRY))(not sure how it will react to a 'group by rollup..' though.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bricklen AndersonINET: [EMAIL PROTECTED]Fat C!
ity
 Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

RE: RE: Career Advice

2003-12-19 Thread Viktor

I think so. Most of ourWebapps arewritten in Java, _javascript_, and Perl. Some minor web stuff is generated by PL/SQL.

Viktor

DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Viktor, Ryan - Is what you are experiencing the result of companies movingto open-systems Web-based architectures?Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Thursday, December 18, 2003 8:34 PMTo: Multiple recipients of list ORACLE-LI agree with Ryan. Pure Oracle jobs aren't hot as they used to be. We aregoing through this right now. They are planning to bring in a bunch of newdevelopers and splitting a few DBA's into dev. groups, which means we'llbecome more like software engineers (who can also do DBA stuff). There willbe only one Prod. DBA for a zillion systems. They're driving in the direction of bringing in more cross-trained people.They want all-aroind people who know Perl, Java, Oracle etc. The motto hasbeen: "If you get hit by a bus,!
he/she
can do it". The more you know, thebetter. Cross-training all the way. It's like that all-in-onefax/printer/copier thing. And at the same time, the paycheck isn't as it had been either. Viktor[EMAIL PROTECTED] wrote:my biggest concern is the model for development has been changed. The modelnow is do most development with software engineers and have only a smallnumber of database people. this means less pure oracle jobs. From: DENNIS WILLIAMS Date: 2003/12/18 Thu PM 02:59:26 EST To: Multiple recipients of list ORACLE-L Subject: RE: RE: Career Advice Ryan - Excellent points. I well know the feeling of being tied to Oracle's future. As to Oracle pricing itself out of the market, I would like tomake three points: - Pricing is one of the quickest things a vendor can change once it becomes convinced this is hurting it. On the ot!
her hand,
I've seensoftware vendors that stopped investing in new development. They aren't in business anymore! because you can't quickly change that decision. - Oracle being perceived as high priced tends to increase our salaries. A company spends a lot of money on Oracle, so they want it used to good advantage. The salary surveys I've seen show MS SQL Server DBA with lower salaries on the average. - Has anyone seen salary survey results for MySQL or PostgreSQL? The database is free, so how much should a company spend on a DBA? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 1:19 PM To: Multiple recipients of list ORACLE-L your goals should tie into the job market. you might absolutely lovePascal programming, but I dont recommend stu!
dying it.
Right now(and I dont know how it will fluctuate), there is far, far, far more demand for Software Engineers who specialize in Java or .Net. Far,far, far, more than people who specialize in the Oracle database. I think there has been a fundamental shift in database development. In the past youwould hire mostly Oracle specialized people to do most of your development. They would use forms or powerbuilder to do your GUIs. These days, a growing number of teams hire a large number of java or .Net experts and only a handful of database people. is this the best way to go?I dont know. I do see a trend though. How long will the trend last? I do not know. The biggest problem for IT workers is that we are so tied to one specific skillset and vendor. If Oracle prices themselves out of the market, our skills become far less valued. Employees to!
day want
super specialized skillsets. If you have them and they are hot, your set, but they wont behot forever and i! ts very hard to switch since people want experience in the specific skillset before hiring you. From: "Thater, William" Date: 2003/12/18 Thu PM 01:44:37 EST To: Multiple recipients of list ORACLE-L Subject: RE: Career AdviceDENNIS WILLIAMS scribbled on the wall in glitter crayon: Saira I think you have to decide what your goal is. Then you need to decide how to best accomplish that goal. One tool that can lead you toward a goal is self-study. I have used that tool many times myself. However, with experience you learn the self-study tool has its limits. To consider self-study, consider the following questions: !
t;
1. Is this an area that I can gain significant knowledge with a reasonable amount of effort? For example, are there good books available? Is the area well-defined enough for self-study? 2. Since I'm trying to substitute self-effort for work experience, is this an area where there are few people with real work experience? 3. Are there credentials that can be earned?i'd like to add one more... 4. is this something where getting it right will still give you a charge after doing it for 10 years or more?[and yes DBA and programming still do for me. but i'm finding thechances of being allowed to do it right are becoming few and far between.]-- Bill "Shrek" Thater ORACLE DBA

RE: RE: Career Advice

2003-12-18 Thread Viktor

I agree with Ryan. Pure Oracle jobs aren't hot as they used to be. We are going throughthisright now.Theyare planning to bring in a bunch of new developers and splitting a few DBA's into dev. groups, which means we'll become more likesoftware engineers (who can also do DBA stuff). There will be only one Prod. DBA for a zillion systems.

They're drivingin the direction ofbringing in more cross-trained people. They want all-aroind people who know Perl, Java, Oracle etc. The motto has been: "If you get hit by a bus, he/she can do it". The more you know, the better. Cross-training all the way.It's like thatall-in-one fax/printer/copier thing.

And at the same time, the paycheck isn't as it had been either.

Viktor

[EMAIL PROTECTED] wrote:
my biggest concern is the model for development has been changed. The model now is do most development with software engineers and have only a small number of database people. this means less pure oracle jobs. From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 2003/12/18 Thu PM 02:59:26 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: RE: Career Advice Ryan - Excellent points. I well know the feeling of being tied to Oracle's future. As to Oracle pricing itself out of the market, I would like to make three points: - Pricing is one of the quickest things a vendor can change once it becomes convinced this is hurting it. On the other hand, I've seen software vendors that stopped investing in new development. They aren't in business anymore!
because
you can't quickly change that decision. - Oracle being perceived as high priced tends to increase our salaries. A company spends a lot of money on Oracle, so they want it used to good advantage. The salary surveys I've seen show MS SQL Server DBA with lower salaries on the average. - Has anyone seen salary survey results for MySQL or PostgreSQL? The database is free, so how much should a company spend on a DBA? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 1:19 PM To: Multiple recipients of list ORACLE-L your goals should tie into the job market. you might absolutely love Pascal programming, but I dont recommend studying it. Right now(and I dont know how it will fluctuate), there is far, far, far more demand for Software
Engineers who specialize in Java or .Net. Far, far, far, more than people who specialize in the Oracle database. I think there has been a fundamental shift in database development. In the past you would hire mostly Oracle specialized people to do most of your development. They would use forms or powerbuilder to do your GUIs. These days, a growing number of teams hire a large number of java or .Net experts and only a handful of database people. is this the best way to go? I dont know. I do see a trend though. How long will the trend last? I do not know. The biggest problem for IT workers is that we are so tied to one specific skillset and vendor. If Oracle prices themselves out of the market, our skills become far less valued. Employees today want super specialized skillsets. If you have them and they are hot, your set, but they wont be hot forever and i!
ts very
hard to switch since people want experience in the specific skillset before hiring you. From: "Thater, William" <[EMAIL PROTECTED]> Date: 2003/12/18 Thu PM 01:44:37 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Career AdviceDENNIS WILLIAMS scribbled on the wall in glitter crayon: Saira I think you have to decide what your goal is. Then you need to decide how to best accomplish that goal. One tool that can lead you toward a goal is self-study. I have used that tool many times myself. However, with experience you learn the self-study tool has its limits. To consider self-study, consider the following questions: 1. Is this an area that I can gain significant knowledge with
a reasonable amount of effort? For example, are there good books available? Is the area well-defined enough for self-study? 2. Since I'm trying to substitute self-effort for work experience, is this an area where there are few people with real work experience? 3. Are there credentials that can be earned?i'd like to add one more... 4. is this something where getting it right will still give you a charge after doing it for 10 years or more?[and yes DBA and programming still do for me. but i'm finding the chances of being allowed to do it right are becoming few and far between.]-- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED]
Time is an illusion, lunchtime doubly so. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EM

RE: RE: Career Advice

2003-12-18 Thread Viktor

And at the same time, the paycheck isn't as it had been either.

Viktor

Re: Career Advice

2003-12-17 Thread Viktor

Let's take this topic into a more concrete scenario. New boss, company reorg, cross-training is enforced and now DBA'S's are going to be split into development groups. Need to learn Perl(looking forward to it actually!!!) and Java. Books, web sites, docs - all these material is great. But what if you're expected to learn fast and I can learn quickly, but still, do you guys have some advice on how can one "express" teach himself.

Managing expectation is one thing I need to talk with boss about. Surely I would not't want to be overwhelmed with stuff at the beginning. But at the same time I am kinda excited about picking up on Java and Perl. The questions is what are the tricks and tips for learning on a fast track?

Thanks!

Viktor
Stephane Faroult [EMAIL PROTECTED] wrote:
Believe somebody who first learned SQL back in 83, it's too late forJava now. Run-of-the-mill skill. Any young grad will know it and will beless expensive.ERP would be a good bet, because people learn them at work, mostly. Now,would a company change be justified just for that? Probably not. As yousaid, you are hired for what you know, not what you want to learn. Graspopportunities, learn whatever looks to you useful - and fun.My 0.02 EUR.SF[EMAIL PROTECTED] wrote: learn java and object oriented programming. go to sun.com and start reading the java docs. go to www.bruceeckel.com and read his java book. do a search on any job sites. a ton more work for java than oracle. people who can do both are in demand. From: Mladen Gogala <[EMAIL PROTECTED]><B!
R>
Date: 2003/12/17 Wed PM 01:49:25 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Career Advice Have you ever considered a career in country music? Try getting "Stand By your man" just right and the rest will come. You have to learn both kinds of music, country and western. May Jake and Elwood be with you. On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Eli!
te and
they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane FaroultINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting
services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

RE: Career Advice

2003-12-17 Thread Viktor

Dennis,

Yes, my thinking is exactly the same. Before I get too much involved with Java (it will be better to taketraining for Java), I am going to sharpen up my skills with Perl. Should be easier to pick it up, and the learning curve won't be as steep.

Every company reorg probably has more minuses that pluses. In our case the new wants the DBA's to participate in the development processes more like developers, which makes us more or less development DBA's. Writing code will be part of our job. Production DBA will do most of the trueadmin. tasks (unless he is out, then one of the dev. DBA's will pick thatup). But other than that, it looks like I am going to be more in the dev. world. Now I'll have to kick my lazy butt tolearn new stuff!

Jared as always thanks! I've already thought about your book and it's now on order!

What about books with basic development perspective?

Thanks!

Viktor

DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
ViktorMy suggestion is to go for Perl as the quick win and impress your newboss. Perl also tends to be more useful for DBAs. Learning Java can be a more long-term proposition. First, you need tohave a strong understanding of object-oriented design. We have traineddevelopers in Java, and it hasn't been a quick learn for them. Based on whatI've seen, I would push for Java training. Also, before you tear into Java,you may want to get a basic understanding of how the web stuff like HTMLworks.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, December 17, 2003 6:24 PMTo: Multiple recipients of list ORACLE-LLet's take this topic into a more concrete scenario. New boss, companyreorg, cross-training is enforced and now DBA'S's are going to be sp!
lit
intodevelopment groups. Need to learn Perl(looking forward to it actually!!!)and Java. Books, web sites, docs - all these material is great. But what ifyou're expected to learn fast and I can learn quickly, but still, do youguys have some advice on how can one "express" teach himself.Managing expectation is one thing I need to talk with boss about. Surely Iwould not't want to be overwhelmed with stuff at the beginning. But at thesame time I am kinda excited about picking up on Java and Perl. Thequestions is what are the tricks and tips for learning on a fast track?Thanks!ViktorStephane Faroult <[EMAIL PROTECTED]>wrote:Believe somebody who first learned SQL back in 83, it's too late forJava now. Run-of-the-mill skill. Any young grad will know it and will beless expensive.ERP would be a good bet, because people learn them at work, mostly. Now,would a company change be justified just for that?
Probably not. As yousaid, you are hired for what you know, not what you want to learn. Graspopportunities, learn whatever looks to you useful - and fun.My 0.02 EUR.SF[EMAIL PROTECTED] wrote: learn java and object oriented programming. go to sun.com and startreading the java docs. go to www.bruceeckel.com and read his java book. do a search on any job sites. a ton more work for java than oracle. peoplewho can do both are in demand. From: Mladen Gogala Date: 2003/12/17 Wed PM 01:49:25 EST To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice Have you ever considered a career in country music? Try getting "StandBy your man" just right and the rest will come. You have to learn both kinds ofmusic, country and western. May Jake and Elwood be with you.<BR!
>
On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Eli! te and they don't have as many customers - or should Isay, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these product!
s? Has
anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane FaroultINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribi

RE: SQL HELP - SOLVED!!!

2003-08-27 Thread Viktor

Thanks to ALL for your help on this! 

As always your advice is greatly appreciated!

Viktor"Jamadagni, Rajendra" [EMAIL PROTECTED] wrote:


Try something like ...


select id, col_1, col_2,sum(web_c),sum(other_c)
from
(select id, to_char(received_date,'-MM') col_1,yr||seq_no||ck col_2,
 case when seq_no  4000 then 1 else 0 end web_c,
 case when seq_no= 4000 then 1 else 0 end other_c 
 from t
where received_date between your_start_date and your_end_date)
group by id, col_1, col_2
/

Raj
 Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message-From: Viktor [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 26, 2003 5:00 PMTo: Multiple recipients of list ORACLE-LSubject: SQL HELP!!!
Hello,

I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:

for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" records. Ifseq_no  4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:

select id , to_char(received_date, '-mm'), id||yr||seq_no||ck MSNO CASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE0 ENDHARDCOPY
from twhere received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),
 sequence_no, id||yr||seq_no||ck
/

AR 2003-01 AR030023T 0 1AR 2003-01 AR0200302 0 1AR 2003-01 AR020047K 0 1AR 2003-01 AR020077N 0 1

I would like to show Year-Month once and count all instances ofid||yr||seq_no||ck (primary_key)for that Year-Month, but not tobreak on it, and unfortunaley it won't let me do it without grouping on seq_no

Please advise!!!

Any help is greatly appreciated!




Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwareThis e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

SQL HELP!!!

2003-08-26 Thread Viktor

Hello,

I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:

for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" records. Ifseq_no  4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:

select id , to_char(received_date, '-mm'), id||yr||seq_no||ck MSNO CASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE0 ENDHARDCOPY
from twhere received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),
 sequence_no, id||yr||seq_no||ck
/

AR 2003-01 AR030023T 0 1AR 2003-01 AR0200302 0 1AR 2003-01 AR020047K 0 1AR 2003-01 AR020077N 0 1

I would like to show Year-Month once and count all instances ofid||yr||seq_no||ck (primary_key)for that Year-Month, but not tobreak on it, and unfortunaley it won't let me do it without grouping on seq_no

Please advise!!!

Any help is greatly appreciated!


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: SQL HELP!!!

2003-08-26 Thread Viktor

Jared,

Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no 4000,in aid||yr||seq_no||ck row, it's a"web row", if not then it's not. what I would like to see is:

ID Received_date Non-web count Web_count
AR 2003-01 0 4AR 2003-02 0 6AR 2003-0 1 8
and so forth.

Again thanks for any suggestions you may have!

Thanks very much!


[EMAIL PROTECTED] wrote:
I'm not sure I entirely understand the result you are trying to achieve. Perhaps this will help select received_date, msno, sum(count_web), hardcopy from ( select id ,to_char(received_date, '-mm') received_date,id||yr||seq_no||ck MSNOCASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE 0  END HARDCOPY from twhere received_date between '01/01/2003' and '12/31/2003'group by id,!
p;
 to_char(received_date, '-mm'),  sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy / 




Viktor [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
08/26/2003 01:59 PM Please respond to ORACLE-L 
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SQL HELP!!!Hello,  I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:  for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" reco!
rds. If
 seq_no  4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select:  select id ,to_char(received_date, '-mm'),id||yr||seq_no||ck MSNOCASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE 0  END HARDCOPY from twhere received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),  sequence_no, id||yr||seq_no||ck !
/  AR 2003-01 AR030023T 0   1AR 2003-01 AR0200302 0   1AR 2003-01 AR020047K 0   1AR 2003-01 AR020077N 0   1  I would like to show Year-Month once and count all instances of id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no  Please advise!!! <B!
R> Any help is greatly appreciated!   


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: SQL HELP!!!

2003-08-26 Thread Viktor

Dave,

Thanks much! I appreciate your help. One other thing I might have forgotten is there a way to calculate non_web_count - to - total%
and web_count - to total % 

so in this way:

output would be like:
ID YEARNON WEB % WEB %NON-WEB

AC 2003-01 47 9867.6 32.4AC 2003-02 26 112AC 2003-03 57 121AC 2003-04 40 124

And so forth...

Thanks Dave and evryone else for your help!Dave Hau [EMAIL PROTECTED] wrote:
select id, received_date,count(count_non_web) non_web_count,count(count_web) web_countfrom(select id, to_char(received_date, '-mm') received_date,(case when seq_no = 4000 then 1 else null end) count_non_web,(case_when seq_no  4000 then 1 else null end) count_webfrom twhere received_date between '01/01/2003' and '12/31/2003')group by id,received_dateHTH,Dave[EMAIL PROTECTED] wrote: Jared,  Thanks for your fast reply! Sorry if I didn't explain myself clear  enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a  combination of 4 columns that make up a primary key. if seq_no 4000, in  a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I  would like to see is:  ID Received_date No!
n-web
 count Web_count AR 2003-01 0 4 AR 2003-02 0 6 AR 2003-0 1 8 and so forth.  Again thanks for any suggestions you may have!  Thanks very much![EMAIL PROTECTED] wrote:   I'm not sure I entirely understand the result you are trying to achieve.  Perhaps this will help  select received_date, msno, sum(count_web), hardcopy from ( select id , to_char(received_date, '-mm') received_date, id||yr||seq_no||ck MSNO CASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB, CASE WHEN seq_no =4000 then count(seq_no) ELSE 0 END HARDCOPY from t where received_date between '01/01/2003' and '12/31/2003' group by id, nbs! p; to_char(received_date, '-mm'),
 sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy / Viktor <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/26/2003 01:59 PM Please respond to ORACLE-L   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:  Subject: SQL HELP!!! Hello,  I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do:  for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" reco! rds. If seq_no  4000, then it's web, otherwise non-web. seq_no is not unique. So it's like 2 different where claused in a single select. Could I somehow use CASE or !
decode to
 accomplish this. Here is what I am trying to do in select:  select id , to_char(received_date, '-mm'), id||yr||seq_no||ck MSNO CASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB, CASE WHEN seq_no =4000 then count(seq_no) ELSE 0 END HARDCOPY from t where received_date between '01/01/2003' and '12/31/2003' group by id, to_char(received_date, '-mm'), sequence_no, id||yr||seq_no||ck ! /  AR 2003-01 AR030023T 0 1 AR 2003-01 AR0200302 0 1 AR 2003-01 AR020047K 0 1 AR 2003-01 AR020077N 0 1  I would like to show Year-Month once and count all instances of id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no  Please advise!!!  Any help is g!
reatly
 appreciated! Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software   Do you Yahoo!? Yahoo! SiteBuilder  - Free,  easy-to-use web site design software-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Dave HauINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto:
 [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: SQL HELP!!!

2003-08-26 Thread Viktor

Jared,

I had a temporary brain freeze :), thanks much! I have modified it a bit, and it seems to be working fine! One other small thing. Is there a quick wahy to calculate percentage of web/non-web and vice-versa in the same select after the column "sums"?

select distinct id, received_date, sum(count_web), sum(count_hardcopy)from (select distinct id , to_char(received_date, '-mm') received_date, id||yr||seq_no||ck MSNO, CASE WHEN seq_no  4000 then count(*) ELSE 0 end Count_WEB, CASE WHEN seq_no =4000 then count(*) ELSE 0 END Count_HARDCOPYfrom twhere id = 'AC'and received_date between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'),
 seq_no, id||yr||seq_no||ck)group by id, received_date

Thanks again![EMAIL PROTECTED] wrote:
Viktor, By using an inline view, count_web does indeed become a column. Did you try the query? Jared 




Viktor [EMAIL PROTECTED] 
08/26/2003 01:29 PM 
To:[EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:Re: SQL HELP!!!Jared,  Thanks for your fast reply! Sorry if I didn't explain myself clear enough. Unfortunately count_web is not a column, id||yr||seq_no||ck is a combination of 4 columns that make up a primary key. if seq_no 4000, in a id||yr||seq_no||ck row, it's a "web row", if not then it's not. what I would like to see is:  ID Received_date  Non-web countWeb_count AR 2003-01  0  4AR 2003-02  0  6AR 2003-0   1  8 and so forth.  Again thanks for any suggestions you may have!  Thanks very much! 
 
 
[EMAIL PROTECTED] wrote: I'm not sure I entirely understand the result you are trying to achieve. Perhaps this will help select received_date, msno, sum(count_web), hardcopy from ( select id ,to_char(received_date, '-mm') received_date,id||yr||seq_no||ck MSNOCASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE 0  END HARDCOPY from twhere received_date bet!
ween
 '01/01/2003' and '12/31/2003'group by id,; to_char(received_date, '-mm'),  sequence_no,id||yr||seq_no||ck ) group by received_date, msno, hardcopy / 




Viktor [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
08/26/2003 01:59 PM Please respond to ORACLE-L 
   To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc:Subject:SQL HELP!!!Hello, I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do: for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" recor ds. If seq_no  4000, then it's web, otherwise non-web. seq_no is not !
unique.
 So it's like 2 different where claused in a single select. Could I somehow use CASE or decode to accomplish this. Here is what I am trying to do in select: select id ,to_char(received_date, '-mm'),id||yr||seq_no||ck MSNOCASE WHEN seq_no  4000 then count(seq_no) ELSE 0 end Count_WEB,CASE WHEN seq_no =4000 then count(seq_no) ELSE 0  END HARDCOPY from twhere received_date between '01/01/2003' and '12/31/2003'group by id,to_char(received_date, '-mm'),  sequence_no,id||yr||seq_no||ck  BR/ AR 2003-01 AR030023T 0   1AR 2003-01 AR0200302 0   1AR 2003-01 AR020047K 0 !
 
 1AR 2003-01 AR020077N 0   1 I would like to show Year-Month once and count all instances of id||yr||seq_no||ck (primary_key) for that Year-Month, but not to break on it, and unfortunaley it won't let me do it without grouping on seq_no Please advise!!! Any help is greatly appreciated!  


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software 


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: Fwd: RE: newbie dba question - another try

2003-02-27 Thread Viktor

Thanks Darell! Your advice as well as from others is greatly appreciated.

Darrell Landrum [EMAIL PROTECTED] wrote:
Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in identifying the slowdowns in performace should be taken WHILE the issue is hot and users are on the horn with it? Obviously, they want FAST fix, magic stick. Their thinking is that there is a switch you turn on and that's it you're going fast again. Is there something that can be done in a short time window while the issue is present?Thanks again!"Godlewski, Melissa" <[EMAIL PROTECTED]>wrote:Alex, My 2 cents, First you need to get a baseline of performance during normal business hours, statspak is a great tool to use. When the system start to experience performance problems, then start drilling down to identify t!
he issues. Use v$ tables as well as statspak more frequently. Additionally, when you find the sessions causing problems pull the sql and work with the developer to tune it, or identify hot objects you need to manage. Run the 10046 trace on the sessions and collect information on the waits etc. A good place to look is the www.orafaq.com for past list comments/information. A helpful book is Oracle 101 performance tuning by Gaja, Kirti, and John. You can also go to the hotsos site and run your reports through the YAPP to help identify bottlenecks. LOLM.Godlewski-///Alex,Melissa has some good advice here. Your issue is too vague and broad for any reasonable assistance. It seems you're kind of in a trial by fire situation. There are so many things you need to look at and know for trouble shooting performance that, without more information, the most likely offering is a book(s). Unless someone has specifically backported statspack, it is only available from 8!
.1.6 forward, so you're stuck with bstat/estat.I haven't read Oracle 101 performance tuning, but I saw Gaja speak at the hotsos symposium and based on that would second Melissa's recommendation for this book. Also, "Expert One-on-One" by Tom Kyte and "Practical Oracle 8i" by Jonathan Lewis (I know it says 8i and you're on 8.0, but there are a lot of concepts and applications the same or similar.) There are probably many other good books which I haven't read.Some sites you should get into very soon (in any order)...http://www.jlcomp.demon.co.uk http://asktom.oracle.com http://www.hotsos.com In the meantime, try and get some traces of troublesome sessions and post those to the list, as well as any stat reports, and we'll offer what help we can. Also, please include any platform information you can get (operating system, etc.). Are your tables getting analyzed?Folks on the list weren't ignoring you, there just wasn't enough information to get !
started.We'll try not to let you have to deal with this alone.Good luck!Darrell Landrum [EMAIL PROTECTED] 02/27/03 05:53PM Note: forwarded message attached.-Do you Yahoo!?Yahoo! Tax Center - forms, calculators, tips, and more-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Darrell LandrumINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso!
send the HELP command for other information (like subscribing).Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

Re: Fwd: RE: newbie dba question - another try

2003-02-27 Thread Viktor

Thanks Darell! Your advice as well as from others is greatly appreciated.

Re: STATSPACK

2003-01-29 Thread Viktor

Jared,
You've got all the knowledge, for real! Is there a possibility of performance decrease when running statspack in Oracle 8.0.5? 
Thanks,
Viktor
[EMAIL PROTECTED] wrote:
No, but you can run the 8.1.6 version.There's a couple of special scripts for doing so.http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.htmlJared"Ruth Gramolini" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]01/29/2003 10:53 AMPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc: Subject: STATSPACKHello everyone,I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3instance?Thanks in advance,Ruth-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ruth GramoliniINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services!
-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list !
you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

OPEN CURSORS Question

2003-01-21 Thread Viktor

Hello,
I'm trying to find out what's causing this problemin one of the databases we have: Oracle 8.05/ Sun Solaris.Customers are using a front-end app where theyaccess databasevia Forms built modules and run a number of reports. The problem is that occasionally they get errors, each time slightly different ones -- I'm still waiting to hear the exact error message as of this morning, but I'd like to find out whether this may be as simple as rasing the value of OPEN_CURSORS in init.ora. It's currently set to 350 (small size db). I'd raise it to 750 or 1000, but I'd like to see for myself what's causing the errors (may be increased usage, other factors...). 
Anyways, part of this select's output is this:
SQLWKS SELECT s.sid, s.value, t.name 
2 FROM v$sesstat s, v$statname t 
3 WHERE s.statistic# = t.statistic# 
4 AND s.sid = 105;
SID VALUE NAME 
-- -- 
105 33882 opened cursors cumulative 
105 343 opened cursors current 

I realize that there may be a number of implicit cursors that are used in the application which increase the likeness of this type of error happening. As you see, for this user "opened current cursors" is 343, but OPEN_CURSORS is set to 350. Besides looking into SQLas possibletarget for tuning,could it be thatOPEN_CUROSRS is set too low for a front-end OLTP small sized DB?

Thank youvery much!

Regards,

ViktorDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: Orawomen

2003-01-08 Thread Viktor

Rachel,
I agree with you for the most part and I'm sure so will many others.There are manypeople, however,who advocate people skills, personality; attractiveness comes to mind, in the sense of do you like that person, in other words, do you feel positevely when working together. They say that even if a person lacks skills, she can be taught; as long as she is a nice person, they're fine with it.
Regards,
Viktor
Rachel Carmichael [EMAIL PROTECTED] wrote:
very technical, very detailed, and very dedicated. The fact that they were both attractive didn't hurt either. One majored in mathI'm about to start a flame war here, I just know it. WHY does it matter to mention the attractiveness of the female DBAs?When I talk about someone I work with, I don't comment on howattractive he or she is. I talk about whether or not the person can dothe work and I can learn from him or her.It's the subtle things that promote the attitude. --- "Smith, Ron L." <[EMAIL PROTECTED]>wrote: I have had the pleasure of working with 2 female DBA's at my company. I have to say they were both the best DBA's the company has had. Both were very technical, very detailed, and very dedicated. The fact that they were both attractive didn't hurt either. One majored i!
n mathamatics and had a 4 point average. But I would not concider her a geek at all. They are both always willing to go the extra mile when needed and work what ever hours are required. I probebly wouldn't be here if it weren't for them. It would be too boring. R. Smith -Original Message- Sent: Wednesday, January 08, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Cherie, Rachel - Thanks for sharing your viewpoint. Brian - I think you are correct that kids today get very little encouragement to study hard subjects like sciences. I find this ironic given the fact that we have an incredibly technological society. I think this is a cumulative product of our society. Parents don't always encourage their children, teachers feel they are talking to an unrecept!
ive audience (and usually don't have much exposure to technical careers themselves), and our popular culture ridicules the idea of maturity in general. But this is more of a concern for girls as they are making decisions about their future. The reason is role models. Often just one prominent member of a profession will encourage many young people to consider that field. Now when a young woman in the computer field is considering becoming an Oracle DBA, a quick scan of the bookshelves turns up Rachel's name. So hear that Rachel -- you're a role model, so you must write more books! -Original Message- Sent: Wednesday, January 08, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Just asking .. I'm told that the number of "Americans" (by which I mean kids born in the S!
tates) entering technical fields of all types is declining. Could the decline of the number of women in IT entering IT be a part of that trend? For that matter, I wasn't really called on much in school (and glad for it, I wasn't usually paying attention), nor did my teachers encourage me that I can recall for anything in particular. Yet, here I am, earning a living doing computer stuff. If 'girls' (or boys, see para 1) aren't encouraged in technical matters, perhaps it's a problem beyond the scope of an overworked and underpaid teachers? Please note, I speak as a father of six and the husband of an (former) educator. ~brian -Original Message- Sent: Wednesday, January 08, 2003 7:39 AM To: Multiple recipients of list ORACLE-L I !
think that within the population of women in IT, the number of female Oracle DBAs is increasing. However, in general, the number of women entering IT is decreasing. That is, the number of women who are encouraged to become DBAs or developers or network admins or sys admins is decreasing. I've noticed (I have a friend with a 13 year old son and a 16 year old daughter) that the schools are not encouraging girls to go into science or math. There have been studies done that show that teachers in those fields tend to call on the girls in the class less and spend less time helping them understand the subjects. My opinion only Rachel --- DENNIS WILLIAMS <[EMAIL PROTECTED]>wrote: Recently this list had a discussion of female Oracle DBAs. The consensus was that the numbers wer!
e increasing, which I view as a good thing. Here is an article with industry statistics saying that the number of women in IT is decreasing. http://itmanagement.earthweb.com/career/article.php/1564501 Any theories?Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San D

Oracle client for Mac OS X?

2002-11-21 Thread Viktor

Folks,
Can someone direct me to a source of good information on this topic. Is there wor will there be Oracle client for OS X? Any leads are very much apreciated!
Thanks!Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Re: FW: developer 2000

2002-11-08 Thread Viktor

I think you may need to get an upgraded installer version 3.3.1.1.0c. This is the one compatible with Y2K. Then, run the installer and select typical, and that should be it. 
Regards,
Viktor

Paulo Gomes [EMAIL PROTECTED] wrote:
 -Original Message- From: Paulo Gomes  Sent: sexta-feira, 8 de Novembro de 2002 17:33 To: '[EMAIL PROTECTED]' Subject: developer 2000-Original Message- From: Paulo Gomes  Sent: sexta-feira, 8 de Novembro de 2002 17:31 To: '[EMAIL PROTECTED]' Subject:   hi people now is my turn to ask for help. Just got some old forms that are still in developer 2000 version. Can't upgrade the client and have a win 2000 machine. Developer 2000 doesn't install in win 2000. Does anyone knows any trick to install Developer 2000 in win 2000? I DON'T WANT TO INSTALL A NEW NT MACHINE JUST FIX SOME LITTLE PROBLEM.  Thanks in advance Regards Paulo-- Please see the official ORACLE-!
!
L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD

RE: FW: developer 2000

2002-11-08 Thread Viktor

You need to get a patch.The one I was talking about isDev 2.1 Patch 6is patch. Look it up to metalink, or contact Oracle Support for assisstance.
Paulo Gomes [EMAIL PROTECTED] wrote:

THANKS
Do u happen to know where can i get that?
Regards
Paulo

-Original Message-From: Viktor [mailto:[EMAIL PROTECTED]]Sent: sexta-feira, 8 de Novembro de 2002 18:09To: Multiple recipients of list ORACLE-LSubject: Re: FW: developer 2000
I think you may need to get an upgraded installer version 3.3.1.1.0c. This is the one compatible with Y2K. Then, run the installer and select typical, and that should be it.
Regards,
Viktor

Paulo Gomes [EMAIL PROTECTED] wrote:
-Original Message- From: Paulo Gomes Sent: sexta-feira, 8 de Novembro de 2002 17:33 To: '[EMAIL PROTECTED]' Subject: developer 2000-Original Message- From: Paulo Gomes Sent: sexta-feira, 8 de Novembro de 2002 17:31 To: '[EMAIL PROTECTED]' Subject: hi people now is my turn to ask for help. Just got some old forms that are still in developer 2000 version. Can't upgrade the client and have a win 2000 machine. Developer 2000 doesn't install in win 2000. Does anyone knows any trick to install Developer 2000 in win 2000? I DON'T WANT TO INSTALL A NEW NT MACHINE JUST FIX SOME LITTLE PROBLEM. Thanks in advance Regards Paulo-- Please see the official ORACLE-!
!
! ! L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

Do you Yahoo!?U2 on LAUNCH - Exclusive medley videos from Greatest Hits CDDo you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD

Displaying Foreign characters

2002-10-17 Thread Viktor

Hello all,
Is there a simple way to display correctlyforeign characters primarily found in name and address records? Currectly, NLS_LANGUAGE = AMERICAN in init.ora and NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 in the registry on client side. Problem is is that name and address records may have characters like "a"with 2 dots on top, and many others, and when querying the db, obviously they're not displayed correctly.
Is therean easy way to do this reql quick?
Thanks much in advance!Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com

Re:Spool Oracle Tables into Excel Format

2002-09-20 Thread Viktor

By the way, would you use replace to get rid of the commas withiin fields so that Excel reads it properly?
[EMAIL PROTECTED] wrote:
Bob,You can create a CSV file from SQL*Plus with the following statement:select Date: 9/20/2002 12:33 PMAll,Is it possible to create Oracle reports into Excelformat ? Is it possible to spool Oracle tables into Excelformat?Thanks in AdvanceBob__Do you Yahoo!?New DSL Internet Access from SBC  Yahoo!http://sbc.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bob RobertINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego!
!
, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB!
!
 ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!

SQL Question

2002-06-07 Thread Viktor


Hello All,

It looks as if I've hit a brick wall and I'd very much
appreciate if you can help. I've got a query that has
to get some names and tie them to members. Name table
is the main table with and member table is child
table.

desc Names

FIRST_INIT  NOT NULL CHAR(4)
SECOND_INIT NOT NULL CHAR(1)
INIT_SEQUENCE   NOT NULL NUMBER
LAST_NAMEVARCHAR2(30)
FIRST_NAME   VARCHAR2(20)
FLAGNOT NULL NUMBER

desc MEMBER

MEM_FIRST_INIT   CHAR(4)   
MEM_SECOND_INIT  CHAR(1)
MEM_INIT_SEQUENCENUMBER

Member table references Names table on FIRST_INIT,
SECOND_INIT, INIT_SEQUENCE.





__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Question (DISREGARD 1ST MESSAGE, SORRY)

2002-06-07 Thread Viktor


Hello All,

It looks as if I've hit a brick wall and I'd very much
appreciate if you can help. 

desc Names

FIRST_INIT  NOT NULL CHAR(4)
SECOND_INIT NOT NULL CHAR(1)
INIT_SEQUENCE   NOT NULL NUMBER
LAST_NAMEVARCHAR2(30)
FIRST_NAME   VARCHAR2(20)
FLAGNOT NULL NUMBER

desc MEMBER

MEM_FIRST_INIT   CHAR(4)   
MEM_SECOND_INIT  CHAR(1)
MEM_INIT_SEQUENCENUMBER

Member table references Names table on FIRST_INIT,
SECOND_INIT, INIT_SEQUENCE (FOREIGN KEYS).

Names table has NOT NULL column flag. It can only be 0
or 1 -- means Name is a member.

But, not all NAME records with FLAG 1 are in MEMBER.
In other words, records in MEMBER usually represent
other some other types of memership.

But, in this case, I need to get those NAME(parent)
records that have FLAG = 1, and those MEMBER(child)
records that reference NAMES via foreign keys.
Sometimes NAME record with FLAG = 1, also has a MEMBER
record, and it could be that record with FLAG = 1 does
not have a record in MEMBER.

I need all those with FLAG = 1 in NAMES + all records
that are in MEMBER.

Is there another way besides the UNION:

SELECT a.first_init||a.second_init||a.init_sequence
INITIALS,
   a.last_name LAST_NAME, 
   a.first_name FIRST_NAME,
   a.flag MEMBER_FLAG,
FROM names a
WHERE a.advisor_flag = 1
UNION
SELECT a.first_init||a.second_init||a.init_sequence
INITIALS,
   a.last_name LAST_NAME, 
   a.first_name FIRST_NAME,
   a.flag MEMBER_FLAG
FROM names a, 
 members m
WHERE a.first_init = m.mem_first_init
 and a.second_init = m.mem_second_init
 and a.init_sequence = m.mem_init_sequence

Thanks a lot in advance!

Regards,

Viktor







__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DECODE HELP SOLVED

2002-05-21 Thread Viktor


Thanks Lyuda and Ron for your help!

--- Lyuda Hoska [EMAIL PROTECTED] wrote:
 Something like this would work.  
 SELECT GREATEST(FIRST_DATE,
 NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE))
 FROM your_table;
 Just an idea, you can explore it further..
 
 -Original Message-
 Sent: Monday, May 20, 2002 3:48 PM
 To: Multiple recipients of list ORACLE-L
 
 Hello all,
 
 This has probably been discussed here before and I'm
 sorry if I'm repeating this. But I'd very much
 appreciate if someone could show me how to use
 DECODE
 to select a MAX date where records are like this:
 
 PRIM. KEY  FIRST_DATE SEC_DATE   THIRD_DATE
 JO001599O 12/14/2000 03/23/2001 05/21/2001 
 JO001620L12/27/2000 05/16/2001 
 
 The first_date, sec_date and third_date may or may
 not
 exist; either one of the dates will be there. I need
 to come up with another column LATEST_DATE which
 will
 show the latest date of the 3.
 
 Thanks very much in advance!
 
 
 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Viktor
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Lyuda Hoska
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

DECODE HELP

2002-05-20 Thread Viktor


Hello all,

This has probably been discussed here before and I'm
sorry if I'm repeating this. But I'd very much
appreciate if someone could show me how to use DECODE
to select a MAX date where records are like this:

PRIM. KEY  FIRST_DATE SEC_DATE   THIRD_DATE
JO001599O 12/14/2000 03/23/2001 05/21/2001 
JO001620L12/27/2000 05/16/2001 

The first_date, sec_date and third_date may or may not
exist; either one of the dates will be there. I need
to come up with another column LATEST_DATE which will
show the latest date of the 3.

Thanks very much in advance!


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to calculate time using SQL

2002-04-01 Thread Viktor


Try this:

select to_date('10:20:32','hh:mi:ss') -
to_date('10:25:29', 'hh:mi:ss')
from dual
/

Viktor

--- Nguyen, David M [EMAIL PROTECTED] wrote:
 Is it possible to calculate seconds using SQL?  
 
 For example, I'd like to subtract   these two time
 to get difference in
 seconds:
 
 10:20:32  -   10:25:29
 
 Thanks,
 David
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Nguyen, David M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

[no subject]

2002-03-19 Thread Viktor


Hi all,

I've got a query that returned more rows than needed.

Here is the query:

SELECT distinct
m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char
MSNO,
   M.RECEIVED_DATE RECEIVED DATE,
   M.EDITOR_NO EDITOR NUMBER,
   S.STATHIST_CODE STATUS CODE,
   ST.STATUS_DESC  STATUS DESCRIPTION,
   count(*) REVIEWER COUNT
FROM mscript m,
 stathist s,
 reviewms r,
 statcode st
WHERE M.JOURNAL_ID = 'ES'
  AND M.EDITOR_NO = 31
  AND S.STATHIST_CODE  'z'
  AND S.STATHIST_CODE = ST.STATUS_CODE
  AND M.JOURNAL_ID = s.shist_ms_jcode --- primary
key
  AND M.YR_OF_ISSUE = s.shist_ms_yrissue  --- primary
key
  AND M.MS_SEQUENCE_NO = s.shist_ms_ms_seqno ---
primary key
  AND M.CHECK_CHAR = s.shist_ms_ckchar  --- primary
key
  AND s.shist_ms_jcode = r.msnumber_jcode  --- primary
key
  and s.shist_ms_yrissue = r.msnumber_yrissue  ---
primary key
  and s.shist_ms_ms_seqno = r.msnumber_ms_seqno  ---
primary key
  and s.shist_ms_ckchar = r.msnumber_ckchar  ---
primary key
GROUP BY
m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char,
   M.RECEIVED_DATE,
   M.EDITOR_NO,
   S.STATHIST_CODE,
   ST.STATUS_DESC
order by 1
/

And the query displays this :

ES9507372 10/03/199531 b accepted with one
revision 01/10/2002
ES9507372 10/03/199531 d author revision
returned   
ES9507372 10/03/199531 e all reviews
returned   
ES9507372 10/03/199531 f sent to editor   
 
ES9507372 10/03/199531 g proofs sent to
author  
ES9507372 10/03/199531 j Cols receipt and
processing
ES9507372 10/03/199531 l acceptance
pending materials   
ES9507372 10/03/199531 m manuscript
initially received  
ES9507372 10/03/199531 p sent to Cols.
journals office  
ES9507372 10/03/199531 q sent for review  
  

I only want it to select the first record all the way
on top because it has the most current data with the
most corrent DATE. 

Records in STATHIST TABLE ARE LIKE where stathist_date
and stathist_code are the last 2 columns. 

ES9507372  01/10/2002 b 
ES9507372  01/05/2002 d 
ES9507372  01/02/2002 e 

Unique for each row.  
I know I am missing something in the query, but I've
got a brain freeze; I basically need to have the
query select only records that have LATEST
stathist_date and NOT repating all recs there are.

Thanks so much in advance!!!


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Weird Report Problem

2002-03-13 Thread Viktor


All,

We've got a weird report problem where the report is
called from a form 
when a user clicks on a button located on the canvas
of the forms 
screen. The button has a trigger on which run 1 of 2
reports based on the 
value user selects from a drop down list in the form's
screen. Trigger is 
simple if :value this  drop parameter if it
exists, re-create it, 
pass text parameters to report ... run_product... else
the same for the 
other condition.
Issue is that although things are GREAT in NT
environment and on our 
development UNIX server( where of course we ftp the
fmb's and compile 
them there via command line creating the fmx file),
problem DOES ARISE in 
our production environment. It's like the form does
not see the latest 
code change we made... still running the report it's
not supposed to 
--- sort of executing the old code that was there
before...

Please advise

Thanks so much!


__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: LIKE and % operator

2002-03-04 Thread Viktor


Try changing the query to say:

select * 
from sonusrpt 
where lower(subject) like '%general%'
/


--- Nguyen, David M [EMAIL PROTECTED] wrote:
 I am running oracle8i on solaris8.  I have a word (
 General ) in my column
 named subject, I try to run SQL using LIKE and %
 to grep any data having
 the word ( General ) but it displayed no rows
 selected.  Does someone have
 any idea why?  Below is my SQL I used.
 
 SQL select * from sonusrpt where subject like
 '%general%';
 
 no rows selected.
 
 
 Thanks,
 David
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Nguyen, David M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Duplicate rows

2002-02-06 Thread Viktor


Here is a query that was posted here a while ago:
delete from pa_answer
where rowid in (select rowid
from p_answer pa
where rowid  (select min(pa2.rowid)
from p_answer pa2
where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name))

This should help.

Viktor


--- Alexander Ordonez [EMAIL PROTECTED] wrote:
 Hi gurus,
 I need detect and delete duplicate rows in any
 table, somebody helpme 
 thanks!!!
 
 @lex


   Lic. Alexander Ordóñez Arroyo 
   Caja Costarricense del Seguro Social  
   
   Soporte Técnico - División de Informática 

   Telefono: 295-2004, San José, Costa Rica  
  
   [EMAIL PROTECTED]Icq# 30173325
 


 The true is out there in WWW
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Alexander Ordonez
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to calculate Last and First Day of Month?

2002-01-24 Thread Viktor


Thanks to Jared and others for a quick assistance.

Regards,

Viktor

--- [EMAIL PROTECTED] wrote:
 Well, yes the first day of the month is always 1.
 
 Representing it as the first day of the current
 month requires
 you to use the SYSDATE function. 
 
 Returning the first day of the month can be done in
 several
 ways, some more reasonable than others.
 
 there's the new to SQL basic programmer DBA wannabe
 method:
 
 select
substr(to_char(sysdate,'MM/DD/'), 1,2) ||
'/01/' ||
substr(to_char(sysdate,'MM/DD/'), 7)
 from dual;
 
 There's the slightly better:
 
 select
to_date(to_char(sysdate,'MM') ||
 '01','MMDD')
 from dual;
 
 The obtuse date math method ( my favorite ):
 
 select
last_day(add_months(sysdate,-1))+1
 from dual;
 
 ( there are several variations on this method )
 
 A little RTFM will reveal a much cleaner method:
 
 select
trunc(sysdate,'mm')
 from dual;
 
 So, the answer is always 1, but there is more than
 one way to get there.
 
 Jared
 SA, OCP, and Part Time Perl Evangelist
 
 
 
 
 
 
 
 
 
 Charlie Mengler [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 01/23/02 12:59 PM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: How to calculate Last
 and First Day of Month?
 
 
 I would have thought that the first day of the
 month
 is ALWAYS the 1st, as in 1 (ONE)!
 
 Please explain why it needs to be calculated or 
 could be a value other than ONE.
 
  
   [EMAIL PROTECTED] 01/23/02 10:35AM 
  Hey guys,
  
  I know this is propablby easy, but I'm a bit
  overwhelmed here this week. Can you please tell me
 how
  to get first and last days of the month given
 SYSDATE?
  
  thanks a lot
  
  Regards
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to calculate Last and First Day of Month?

2002-01-23 Thread Viktor


It is the 1st. I've already got quick help on that...

thanks


--- Charlie Mengler [EMAIL PROTECTED] wrote:
 I would have thought that the first day of the
 month
 is ALWAYS the 1st, as in 1 (ONE)!
 
 Please explain why it needs to be calculated or 
 could be a value other than ONE.
 
  
   [EMAIL PROTECTED] 01/23/02 10:35AM 
  Hey guys,
  
  I know this is propablby easy, but I'm a bit
  overwhelmed here this week. Can you please tell me
 how
  to get first and last days of the month given
 SYSDATE?
  
  thanks a lot
  
  Regards
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Viktor


Hi all,

Last nignt when we were expring data for one of our
databases, this error ocurred:

ORA-01555: snapshot too old: rollback segment number
3 with name R02) offset=(0).

Now, we were able to once again export and load data
this morning. And there was no error.

What is the best aproach to try to eliminate this
error in the future?

Any suggestions apreciated.

Thanks

Regards



__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Viktor


Thanks to all for your insights. 
Your ideas were helpful, as always.

Regards




--- Deshpande, Kirti [EMAIL PROTECTED]
wrote:
 With Oracle 9i  Auto Undo Management, Oracle
 allocates a default
 min_extents=2 for the undo segments. And there is
 nothing one can do to
 change it (other than continue using the rollback
 segment approach). The
 min_extents=20 guideline came about from Oracle's
 internal testing (a very
 controlled environment) to find ways to minimize
 ORA-1555 error. 
 
 - Kirti 
 
 
 -Original Message-
 Sent: Tuesday, January 15, 2002 2:15 PM
 To: Multiple recipients of list ORACLE-L
 
 
 min extents = 20 is not carved in stone. You
 allocate them with the
 number of extents that make sense for your database
 
 the problem is, as new releases come out, old
 facts change and people
 keep spreading them anyway
 
 --- àãø_éçéàì [EMAIL PROTECTED] wrote:
  Hello Viktor
  
  Regarding the rollback segments, I heard from
 Oracle that you need to
  allocate them
  with min extents=20. 
  This will cause users to get their own extents and
 the chance that a
  new
  update will overwrite 
  an old update that you need will decrease.
  Check metalink. they have a paper on this error
 (if I remember
  correctly)
  
  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]
  
   -Original Message-
   From: Karniotis, Stephen
 [SMTP:[EMAIL PROTECTED]]
   Sent: Tue, January 15, 2002 8:05 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  RE: ORA-01555: snapshot too old:
 rollback segment
  number...
   
   You can export with CONSISTENT=N; a consistent
 view of the data
  will not
   be
   achieved.  You can also increase the size of
 your rollback segments
  to
   accommodate large queries while updates are
 being performed.  There
  is not
   much else you can do on this one.
   
   Thank You
   
   Stephen P. Karniotis
   Technical Alliance Manager
   Compuware Corporation
   Direct:   (248) 865-4350
   Mobile:   (248) 408-2918
   Email:[EMAIL PROTECTED]
   Web:  www.compuware.com
   
   
-Original Message-
   Sent: Tuesday, January 15, 2002 12:20 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  ORA-01555: snapshot too old: rollback
 segment number...
   
   Hi all,
   
   Last nignt when we were expring data for one of
 our
   databases, this error ocurred:
   
   ORA-01555: snapshot too old: rollback segment
 number
   3 with name R02) offset=(0).
   
   Now, we were able to once again export and load
 data
   this morning. And there was no error.
   
   What is the best aproach to try to eliminate
 this
   error in the future?
   
   Any suggestions apreciated.
   
   Thanks
   
   Regards
   
   
   
  
 __
   Do You Yahoo!?
   Send FREE video emails in Yahoo! Mail!
   http://promo.yahoo.com/videomail/
   -- 
   Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
   -- 
   Author: Viktor
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
   San Diego, California-- Public Internet
 access / Mailing
  Lists
  
 


   To REMOVE yourself from this mailing list, send
 an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
   the message BODY, include a line containing:
 UNSUB ORACLE-L
   (or the name of mailing list you want to be
 removed from).  You may
   also send the HELP command for other information
 (like
  subscribing).
   -- 
   Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
   -- 
   Author: Karniotis, Stephen
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
   San Diego, California-- Public Internet
 access / Mailing
  Lists
  
 


   To REMOVE yourself from this mailing list, send
 an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
   the message BODY, include a line containing:
 UNSUB ORACLE-L
   (or the name of mailing list you want to be
 removed from).  You may
   also send the HELP command for other information
 (like
  subscribing).
  

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This e-mail was scanned by the eSafe Mail
 Gateway 
  

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  -- 
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing
  Lists
 


  To REMOVE yourself from this mailing list, send an
 E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling

RE: The OCP bar is being raised

2002-01-10 Thread Viktor


How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor

--- Bowes, Chris [EMAIL PROTECTED] wrote:
 Maybe I am completely misreading this.  However, I
 didn't see the 8 to 9 OCP
 upgrade and that is why I said, you'll have to take
 them over again.  If I
 am completely out to lunch and this is just a re-org
 of the Masters and OCP
 and those 8 OCP can get OCM with 2 classes and a
 test, then I apologize for
 wasting your time and bandwidth, but from what I
 read (and it was a quick
 read) even if you are 8 OCP, you still have to have
 the 9 OCA and OCP before
 you can get the 9 OCM.  
 
 --Chris
 
 
 -Original Message-
 Sent: Thursday, January 10, 2002 10:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Of course, those of us who already have the OCP and
 want to be called a 
 'master'
 just need to take the 2 required courses and then
 the OCM exam.
 
 When looking at the details, they just split the
 previous 5 exam OCP into 
 two tiers,
 a 2 exam OCA, and a 2 exam OCP which has the OCA as
 a prerequisite.
 
 The Oracle Master was always available, but without
 a test -- it just
 required taking ILT courses. They just added a
 practicum exam to
 make the OCM cert.
 
 I can see your point about this being a 'money
 grab', but the only new item
 here is the OCM practicum exam -- everything else
 existed for 8 and 8i.
 
 -Joe
 
 At 07:05 AM 1/10/02 -0800, you wrote:
 
 I'd say the cost is being raised.  Look at the
 requirements for each.  You 
 can't just take the OCM exam.  No we would first
 have to get the 
 OCA.  Whether or not we need the entry level cert
 we have to have 
 it.  Then, and only then, can we take the OCP. 
 Then and only then, can we 
 take the OCM and that is after we take these
 REQUIRED classes from Oracle 
 Ed.  So someone the caliber of Steve Adams or Jared
 Still, has to spend 
 money in a class that they could probably teach
 from memory before they 
 can get certification and that is after getting 2
 other certs that have no 
 value to them.  Call me a cynic, but to me, this is
 nothing but a money
 grab.
 
  From the website:
 
 --To become an Oracle Associate, you must pass the
 exams required
 -- for the Oracle Associate level of your selected
 job role. Typically,
 --two exams are required; the first one can be
 taken via the Internet,
 --while subsequent exams must be taken in a
 proctored environment. By
 --completing your Oracle Associate, you are
 half-way toward achieving the
 -- Oracle Certified Professional credential.
 
 --To become an Oracle Certified Professional, you
 must pass all required 
 exams
 --in your selected job role, including those at the
 Associate level.
 
 --To become an Oracle Certified Master, you must
 first be an Oracle
 --Certified Professional. Additionally, achieving
 your OCM credential
 --requires attending two advanced level Oracle
 University courses from
 --the list shown on this page as well as passing
 the OCM Practicum exam.
 
 --Chris
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 10, 2002 9:16 AM
 To: Multiple recipients of list ORACLE-L
 Subject: The OCP bar is being raised
 
 Anyone care to comment on the following, IMHO it's
 about time:

---
 - 
 
 ---
 Introducing two new levels of Oracle Certified
 Professional (OCP)
 Achievement
 
 A recent *IDC report on IT Education and Training
 Services quoted database
 professionals and network engineers as the
 fastest-growing areas of 
 Professional
 Certification. And in an October survey from
 *crn.com on Certification, 
 58% of
 respondents said that it is very difficult to find
 qualified Oracle
 Certified
 Professionals-Database Administrators.
 
 To meet this demand, we have recently introduced
 two new levels of 
 professional
 achievement to DBAs (and soon to be released to
 Application and Java 
 Developers
 worldwide):
 
 The Oracle Certified Associate (OCA) -- an
 entry-level Oracle qualification
 requiring successful completion of two exams.
 The Oracle Certified Master (OCM) -- an advanced
 qualification for Oracle
 Certified Professionals (OCP), that requires
 students to take a practicum 
 exam
 on-sitee at an Oracle University education center.
 Visit

http://www.oracle.com/education/certification/news/index.html?certlevels.h

tmlhttp://www.oracle.com/education/certification/news/index.html?certlevels
 .html 
 
 for more information
 
 IDC, IT Education and Training, Sept 2001
 crn.com, Certification: What's Hot, What's Not, Oct
 2001

---
 - 
 
 -
 --
 Please see the official ORACLE-L FAQ: 
 http://www.orafaq.comhttp://www.orafaq.com
 --
 Author:
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
 San Diego

Re: OCP discount is avaialable still?

2002-01-09 Thread Viktor


Try Discount code S36 when you sign up for an exam.
I used it before and it worked for me
I did all my exam scheduling at www.prometric.com.

Regards,

Viktor


--- Tirumala, Surendra
[EMAIL PROTECTED] wrote:
 Hi List,
 
 I would like to know if anyone knows whether the OCP
 discount for otn
 memebers is still avaialable?
 Have been trying in technet.oracle.com without
 success.
 
 Thanks,
 Surendra
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Tirumala, Surendra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: WHERE CURRENT OF Question

2001-10-05 Thread Viktor


Hi Bill,

I didn't really do much checking, but my guess is that
the 'WHERE CURRENT OF' works here because you're
selecting * in the cursor. 

If you, for instance, select columna_a as supposed to
*
then you will most likely get the error.

My guess is  that this is just how ORACLE locks the
set when you select in the cursor; therefore, you
don't get the error. But,like I said, if you only
select column_a, and then, attempt to update column_b,
you will most likely see the error that you might have
expected.


Regards.

--- Bill Buchan [EMAIL PROTECTED] wrote:
 
 
 Why does the following work?  I open a cursor with
 FOR UPDATE OF COLUMN_A 
 and then do an update of COLUMNB, WHERE CURRENT OF
 the cursor.  Surely I 
 shouldn't be allowed to do that?
 (Ora 8.1.7.2)
 
 Any insight appreciated!
 Thanks
 - Bill.
 
 
 SQLWKS create table test_table
   2 (
   3 column_anumber,
   4 column_bnumber
   5 )
   6
 Statement processed.
 SQLWKS insert into test_table values (1,2)
   2
 1 row processed.
 SQLWKS insert into test_table values (2,3)
   2
 1 row processed.
 SQLWKS insert into test_table values (3,4)
   2
 1 row processed.
 SQLWKS declare
   2 cursor c1 is select * from
 test_table for update of column_a;
   3 begin
   4 for i in c1 loop
   5 update test_table set
 column_b = column_b * 2
   6 where current of c1;
   7 end loop;
   8 end;
   9
 Statement processed.
 SQLWKS select *
   2 from test_table
   3
 COLUMN_A   COLUMN_B
 -- --
   1  4
   2  6
   3  8
 3 rows selected.
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Bill Buchan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Stored procedure performance

2001-08-13 Thread Viktor


I love the quote beneath your message!
It's so true.


--- Christopher Spence [EMAIL PROTECTED] wrote:
 There are many many answers to your question.
 And it all lies in what your trying to accomplish.
 
 As a general rule, packages perform better than
 procedures are the entire
 package is loaded.
 PL/SQL is slower than SQL in due to the context
 switches and calls to sql
 parser, although these can be minmized by using bulk
 transactions and other
 features.  
 Java procedures out perform plsql when it is heavily
 computational.
 PL/SQL out performs Java procedures when it is
 heavily transactional
 OCI calls being one of lowest levels are of course
 very efficient.
 
 The performance differences can be milliseconds or
 it can be hours depending
 what is trying to be accomplished.
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275
 
 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863
  
 
 
 
 -Original Message-
 Sent: Monday, August 13, 2001 11:21 AM
 To: Multiple recipients of list ORACLE-L
 
 
 In the process of making a design decision, I'm
 looking for information on
 the relative performance of PL/SQL stored procedures
 / packages vs. both
 Pro*C / OCI SQL calls and Java stored procedures. 
 All things being equal,
 let's say for DML calls with little or not
 procedural logic, what technique
 is likely to yield the best performance, and how
 much of a performance
 difference exists?  In the case of PL/SQL vs. SQL,
 is the advantage of
 centralization overshadowed by a performance hit? 
 In the case of PL/SQL vs.
 Java, is the advantage of a more standard and
 widely-used language among
 application developers similarly negated by a
 performance disadvantage?
 
 I'm interested in hearing opinions based on both
 theoretical and empirical
 information.  Thanks.
 
 Paul Baumgartel
 MortgageSight Holdings, LLC
 [EMAIL PROTECTED]
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Paul Baumgartel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in the
 message BODY, include a line containing: UNSUB
 ORACLE-L (or the name of
 mailing list you want to be removed from).  You may
 also send the HELP
 command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Christopher Spence
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Happy Birthday List !!

2001-04-26 Thread Viktor


Happy birthday!

--- Jamadagni, Rajendra
[EMAIL PROTECTED] wrote:
 Oracle-L hosted at fatcity became operational a year
 ago ... 
 
 The new list will be available for use at 1am (0100
 hours) on Wed,
 26-Apr-2000 PDT. says the message from Bruce the
 ListMaster ...
 
 HTH
 Raj

__
 Rajendra JamadagniMIS, ESPN Inc.
 Rajendra dot Jamadagni at ESPN dot com
 Any opinion expressed here is personal and doesn't
 reflect that of ESPN Inc.
 
 QOTD: Any clod can have facts, but having an opinion
 is an art !
 

*
 
 This e-mail message is confidential, intended only
 for the named recipient(s) above and may contain
 information that is privileged, attorney work
 product or exempt from disclosure under applicable
 law. If you have received this message in error, or
 are not the named recipient(s), please immediately
 notify ESPN at (860) 766-2000 and delete this e-mail
 message from your computer, Thank you.
 

*
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jamadagni, Rajendra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Report 2.5, how to bring up ' 0 ' when sql query returns null ?

2001-04-09 Thread Viktor



Hey,

Go to Metalink site and enter 29736.1 in the search
box.

Hopefully, that document will help you.

--- "Hsu, Anthony C., ,CPMS"
[EMAIL PROTECTED] wrote:
 Hi friends,
 
 I would appreciate that if anyone can share the idea
 to
 bring up ' 0' after SQL query returns null in Report
 2.5 ?
 What I mean is in Report 2.5,  if I have four SQL
 queries and each query
 will returns each quarterly data and I need to
 display ' 0' even though
 there
 is no records return for the 2nd quarter.
 
 
 My report now can display data like below and the
 SQL query is
 /*   select count(rain_days), count(sunshine_days)
 from weather
  where  quarter='2'  */  and the return is null
 
 quarter   qtr1qtr3qtr4
 
 
 rain days #   20   15 25
 
 sunshine days#10   15  5
 
 
 
 
 
 I want to have report can display like below even
 though my SQL query
 /*select count(rain_days), count(sunshine_days)
 from weather
   where  quarter='2'*/
 returns null
 
 quarter   qtr1qtr2qtr3qtr4
 
 
 rain days #   20   0   15 25
 
 sunshine days#10   0   15  5
 
 
 Thanks.
 
 
 
  
 
  
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Hsu, Anthony C., ,CPMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Question

2001-04-03 Thread Viktor



Hello all,

Can someone tell me whether or not there is a way
do this in SQL?
I want to select some data given a certain date
range,i.e  where some_date between start_date and
end_date.
Is there a way to group the output by week?
In other words, something like:

SELECT column_a, column_b, count(*),
sum(column_c)
FROM table_t
WHERE some_date_column BETWEEN :start_date and
:end_date
GROUP BY ...?

How this be grouped by week?

Thanks a lot.


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Question

2001-04-03 Thread Viktor


Thanks a lot to everyone who helped.
It's all good!

Special Thanks to William and Regina!


--- William Rogge [EMAIL PROTECTED] wrote:
 YES.
 
 column the_week noprint
 SELECT column_a, column_b,
 to_char(some_date_column,'YYWW') the_week, count(*),
sum(column_c)
 from table_t
 WHERE some_date_column BETWEEN :start_date and
 :end_date
 group by to_char(some_date_column, 'YYWW')
 
 
 -Original Message-
 From: Viktor [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 03, 2001 1:36 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  SQL Question
 
 
 Hello all,
 
 Can someone tell me whether or not there is a way
 do this in SQL?
 I want to select some data given a certain date
 range,i.e  where some_date between start_date and
 end_date.
 Is there a way to group the output by week?
 In other words, something like:
 
 SELECT column_a, column_b, count(*),
 sum(column_c)
 FROM table_t
 WHERE some_date_column BETWEEN :start_date and
 :end_date
 GROUP BY ...?
 
 How this be grouped by week?
 
 Thanks a lot.
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Viktor
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: William Rogge
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Discount for register the exam

2001-03-11 Thread Viktor


I'd like to know the same thing as well.
By the way, how do you get get the 20% OTN discount
you mentioned?

Thanks

--- WENDY YUE [EMAIL PROTECTED] wrote:
 
 Hi, Gangs:
 
 I'm planning to take DBA Exam soon. Does anyone know
 how to get extra discount (besides 20% OTN discount)
 when register an exam?
 
 Thanks
 
 
 
 -
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great
prices!


__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

What do you think works faster?

2001-02-12 Thread Viktor


We've got some dynamic sql proc.

Attached are 2 files.

Which one you think should work faster?

Thanks.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
 Proc.sql

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

 Proc1.sql

Ascii code of tab?

2001-02-05 Thread Viktor


What is ascii code of TAB?

Thanks

__
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

47 matches

Mail list logo