Re: SQL*Plus with readline

2003-12-17 Thread Carel-Jan Engel
On Tue, 16 Dec 2003, Carel-Jan Engel wrote: Does this tool have the same 'functionality'? So, be carefull, or take advantage of it ;-). Nope, the only history it stores are the commands you type once the program it execs is fired up. Now, if you connect scott/tiger from within sqlplus,

RE: NT - Win2K causes performance degradation..

2003-12-17 Thread Jamadagni, Rajendra
Title: Message Half of all memory to kernel is consistent with MS policy of taking half your entire IT budget to give you products that do half the advertised work. Raj Rajendra dot Jamadagni at nospamespn dot

RE: NT - Win2K causes performance degradation..

2003-12-17 Thread Boivin, Patrice J
Title: Message Advanced Server costs quite a bit more than the boiler plate variety of 2000. Patrice. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: December 16, 2003 8:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: NT - Win2K

RE: NT - Win2K causes performance degradation..

2003-12-17 Thread Boivin, Patrice J
Interesting. We noticed the same thing on Windows2000, it doesn't get mentioned often. Does it mean not many people maintain databases that require more than 1.5G of memory on their Windows servers? My impression so far: - one can't use virtual memory on the Windows platform for a busy database,

RE: connection pooling from an application server to oracle

2003-12-17 Thread Thater, William
Bellow, Bambi scribbled on the wall in glitter crayon: To extrapolate, then, do you think that Neanderthals(at a cranial capacity of over 1700 cc) would have been using Oracle 11h, or do you think they would have prefered OODBMSs? i think they'd are smart enough to use what works best for

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread Boivin, Patrice J
So we have to take two advanced Oracle courses... I have a bad feeling that the Oracle Internals Seminars by Scott Gossett don't count. Would that be correct? They are not part of the OCP tracks. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin,

Re: connection pooling from an application server to oracle

2003-12-17 Thread Mladen Gogala
I think that Neanderthals are in the damagement and would prefer the best looking salesperson which also happens to agree with their view, formed by reading Computerworld. As for the cranial capacity, it's the same thing as with the silicon based CPUs: most of capacity is vasted doing unnecessary

Re: Re: Who are certified Oracle Masters?

2003-12-17 Thread Mladen Gogala
I've taken those for 8i. Scott is a great guy and the course is excellent. In NYC there was a waiting list for his course. On 12/17/2003 09:19:26 AM, Boivin, Patrice J wrote: So we have to take two advanced Oracle courses... I have a bad feeling that the Oracle Internals Seminars by Scott

DISASTER RECOVERY with Continous Access

2003-12-17 Thread Spears, Brian
Anybody Setup an Oracle Disaster recovery with the product Continuous Access on San at an alternative location? I have a few options but would like to know what other people found good. I prefer having the disaster recovery site being validated on a continous basis with automated restores etc.

Stored Outline Problem

2003-12-17 Thread Bill Buchan
Hi all, I'm trying to set up stored outlines and am running into the following problem (OUTLN tables are initially empty and the shared pool has just been flushed): ALTER SESSION SET CREATE_STORED_OUTLINES = TRUE; SELECT 'THISISMYTEST' FROM DUAL; ALTER SESSION SET CREATE_STORED_OUTLINES =

RE: Stored Outline Problem

2003-12-17 Thread Jamadagni, Rajendra
I think it is the hash value for sql text something like hash(sql_text_here) ... probably used to do a fast match with trying to lookup outlines ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views

Fwd: Stored Outline Problem

2003-12-17 Thread Bill Buchan
Additional information: The problem described below occurs on 9.2.0.4 (Linux). I have just tried re-producing on 8.1.7.4 (Solaris) and it actually worked fine there (hash values in ol$ and v$sql matched). Once again, any input welcome. Thanks, - Bill. Hi all, I'm trying to set up stored

RE: Unreadable time_stamp format

2003-12-17 Thread Nguyen, David M
Jared, It is epochtime. When I run your given SQL I got TO_DATE output is 24-NOV-03. Is it actual date translated from epochtime 1069716948959 ? How do I query to select only 100 records? SQL select to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*100 0) ) from

Re: Re: Who are certified Oracle Masters?

2003-12-17 Thread Rachel Carmichael
I ended up going to Bethesda from NYC to take the class with him --- Mladen Gogala [EMAIL PROTECTED] wrote: I've taken those for 8i. Scott is a great guy and the course is excellent. In NYC there was a waiting list for his course. On 12/17/2003 09:19:26 AM, Boivin, Patrice J wrote: So we

Re: SQL*Plus with readline

2003-12-17 Thread Daniel Hanks
On Wed, 17 Dec 2003, Carel-Jan Engel wrote: On Tue, 16 Dec 2003, Carel-Jan Engel wrote: Does this tool have the same 'functionality'? So, be carefull, or take advantage of it ;-). Nope, the only history it stores are the commands you type once the program it execs is fired up. Now,

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread Pete Sharman
That's correct. I believe the reasoning is that the advanced courses (listed below) that are included have to include hands on. The Internals seminars are not hands on. As a couple of asides, Scott is not the only instructor who runs those internals seminars, and I'm not even sure if he's

Re: Fwd: Stored Outline Problem

2003-12-17 Thread M.Godlewski
Bill, I tried your example on my systems. On Sun solaris 9.2.0.4 has the same issue of non matching hash values. Sun Solaris 8.1.7.3 has matching hash_values.Bill Buchan [EMAIL PROTECTED] wrote: Additional information:The problem described below occurs on 9.2.0.4 (Linux).I have just tried

Re: Re: Who are certified Oracle Masters?

2003-12-17 Thread Mladen Gogala
Bethesda city center on Wisconsin Av.? Nice place with some rather fancy restaurants around. I drove around Washington and Bethesda and I must say that it is a beautiful area. I would like to live in Reston, VA. Did you know that propery prices in Reston are comparable to those on LI? On

Please read - Re: connection pooling from an application server to oracle

2003-12-17 Thread Jared . Still
Off topic ( way off topic ) threads have been consuming a lot of bandwidth on this list. Focus please. Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 06:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Unreadable time_stamp format

2003-12-17 Thread Jared . Still
David, SOAPBOX Not trying to sound condescending or disrespectful, but I think you need some serious practice time with SQL. Break out the SQL manual, and find out how to join various tables. A good place to start would be the demo account scott/tiger, with the demo tables in

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread Hsu, Anthony C., ,CPMS
high 300K to 0.5M for a townhouse and 500K to 1M for single house -Original Message- Sent: Wednesday, December 17, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Bethesda city center on Wisconsin Av.? Nice place with some rather fancy restaurants around. I drove around

RE: Unreadable time_stamp format

2003-12-17 Thread Nguyen, David M
Jared, Sure I will. Thanks for you help. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unreadable

Career Advice

2003-12-17 Thread Saira Somani-Mendelin
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

Re: Career Advice

2003-12-17 Thread Jared . Still
Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that

OCP 8i

2003-12-17 Thread Nelson, Allan
Title: OCP 8i Hi Listers, Does anyone know how long the 8i OCP tests will be offered. I can't seem to find it on the Oracle Education Web site. Thanks Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread Boivin, Patrice J
This is OT... 3-bedroom Houses in Halifax, Canada sell for about CDN$130K now. Patrice. -Original Message- Sent: December 17, 2003 1:09 PM To: Multiple recipients of list ORACLE-L high 300K to 0.5M for a townhouse and 500K to 1M for single house -- Please see the official ORACLE-L

Re: Career Advice

2003-12-17 Thread Mladen Gogala
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

Zooming in...

2003-12-17 Thread Mladen Gogala
Jared, I just read your post. I'll be focusing. Please, delete my career advice without reading it as it reveals despicable lack of focus. I'm zooming in on oracle now. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Sadly, I do agree with you, but its a silly world out there. You cant get a job working with these packages without experience, and you cant get experience if you dont work with these packages. So my alternatives are few to none. Indeed, the Tecsys applications are comparable to many

RE: Career Advice

2003-12-17 Thread Nelson, Allan
Hi Somani, This is, of course, just one opinion. YMMV. I would recommend that you go deep enough on the Oracle server until you would be willing to take the junior off your title. The reason for this recommendation is that the server is an intricate piece of software that rewards study and

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Wow... as talented and knowledgeable as you are, you are one really bored DBA. You must work alone, or be self-employed. Or maybe you are trying to tell me to read between the lines... In any case, I won't get into a silly argument with you. Thanks for your advice, Saira -Original

RE: Career Advice

2003-12-17 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: 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. son, that there was

Re: Re: Career Advice

2003-12-17 Thread ryan_oracle
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]

no longer listening

2003-12-17 Thread QuijadaReina, Julio C
Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Hi Allan, Please call me Saira :) All you are saying is true. I find that in my present role, I don't have access to the applications source code so I have to look at the database for performance tuning (which should be the case anyway to start). On the other hand, I'm the only one at this job

RE: Career Advice

2003-12-17 Thread Justin Cave
I'd look to the business side of things to get your foot in the door if you want to work with some of the more well-known application suites. While the specific knowledge of one application suite is seldom easily transferred to another application, the requirements and experience of the actual

Re: Career Advice

2003-12-17 Thread eric king
That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message -

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread ryan_oracle
DC area is insanely expensive. you can spend $300,000 for a condo. Traffic is very bad also and getting worse. it doesnt get 'affordable' until you get up to frederick or in virginia near manassas or west of leesburg. with all the government money and the private sector IT stuff in free

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Is it that difficult though? Just to get familiar with it if youve worked with other similar software before? I guess youd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no?

Re: Career Advice

2003-12-17 Thread Mladen Gogala
Or maybe you are trying to tell me to read between the lines... I'm not. I was just kidding. I don't know any of this stuff (SAP, Siebel, Oracle Apps) and I do make my living. Frankly, I don't like specialists, because they end up just like pandas: no bamboo shoots, and they starve. Black

Re: OCP 8i

2003-12-17 Thread Jose Luis Delgado
Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- Nelson, Allan [EMAIL PROTECTED] wrote: Hi Listers, Does anyone know how long the 8i OCP tests will be offered. I can't seem to find it on the Oracle Education Web site. Thanks

RE: Career Advice

2003-12-17 Thread Odland, Brad
There is no set formula now. But learning a fair amount of SQL, Oracle Database and Unix Administration can do you no wrong. IN my experience the companies or people that hire you because of big names on your resume are NOT the ones you want to work for. IT administration work has become more

RE: Career Advice

2003-12-17 Thread Odland, Brad
If you need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo linux box at home is a great learning exersize. (I've yet to do the Gentoo thing, RedHat right now) (You need at least two computers at home...List how many computers do you have at home.be

RE: OCP 8i

2003-12-17 Thread Nelson, Allan
Oh, thanks -Original Message- Jose Luis Delgado Sent: Wednesday, December 17, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- Nelson, Allan [EMAIL PROTECTED] wrote: Hi

Re: no longer listening

2003-12-17 Thread Mladen Gogala
Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, QuijadaReina, Julio C wrote: Hi all, For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
That is an excellent guideline. I find myself as somewhere in the middle of those two spectrums, a little more towards the second one. My personal belief is that languages can be learnt - like Java or any other code - if you possess the skills. I can read and understand 4GL code without ever

RE: Career Advice

2003-12-17 Thread Odland, Brad
My career advice to you is: do whatever sells. Even if it is wearing a sandwich board that says, Hot Large Pizza Now $5.00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Career Advice

2003-12-17 Thread Mladen Gogala
Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, Odland, Brad wrote: My career advice to you is: do whatever sells. Even if it is wearing a sandwich board that says, Hot Large Pizza Now $5.00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

Re: no longer listening

2003-12-17 Thread LeRoy Kemnitz
I had a lot of problems with the listeners going down for no reason. I was running 8.1.7.4 with 8.1.7 listeners at the time. I changed the ports to non-default ports and upgraded to 9. And haven't had a problem since. "QuijadaReina, Julio C" wrote: Hi all, For the last couple of weeks, I

RE: Career Advice

2003-12-17 Thread DENNIS WILLIAMS
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

RE: Career Advice

2003-12-17 Thread Bobak, Mark
Ok, we're getting way OT now My local Little Caesars Pizza has the Hot and Ready deal going. One large w/ pepperoni for $5, carry-out only. -Original Message- Sent: Wednesday, December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Little Caesars. $5 CDN (Seriously). -Original Message- Mladen Gogala Sent: December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, Odland, Brad wrote: My career advice to you is: do whatever sells. Even if it is

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. I've hesitated to learn Perl - don't know why, but now I find I have to know it to do my job better, esp when I'm working

Re: Career Advice

2003-12-17 Thread Mladen Gogala
Does il in your email address stand for Illinois? Is it in the Chicago area? If it's Peoria, then I understand. On 12/17/2003 03:39:26 PM, Bobak, Mark wrote: Ok, we're getting way OT now My local Little Caesars Pizza has the Hot and Ready deal going. One large w/ pepperoni for $5,

Re: Career Advice

2003-12-17 Thread Mladen Gogala
On 12/17/2003 03:44:34 PM, Saira Somani-Mendelin wrote: Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. Dennis has a point. The question is where do you want to go

RE: no longer listening

2003-12-17 Thread Odland, Brad
Eh? -Original Message- Sent: Wednesday, December 17, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, QuijadaReina, Julio C wrote: Hi all, For the last

RE: no longer listening

2003-12-17 Thread QuijadaReina, Julio C
Thanks for replying Leroy, I am running Oracle 9i Enterprise Edition 9.2.0.1.0 for both the database and the listener. But I wonder if the issue is the standard port 1521, should I change to a non-standard port? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Sounds like a fun time J no really Thanks for all the details. Right now I have one computer that is used by everyone. I have a spare laptop but I can always buy a couple of cheap computers to set up a mini lab. Thanks, Saira -Original Message- From: [EMAIL PROTECTED]

RE: no longer listening

2003-12-17 Thread QuijadaReina, Julio C
Mladen, I did look at the listener.log file and did not see any changes as far as network configuration. The host where the database is running on does not have a fixed IP address though. It gets a lease from a DHCP. I checked the logs on the DHCP and the IP for my database host has not changed

RE: Career Advice

2003-12-17 Thread Bobak, Mark
Nope, IL=IL=Information Learning, which is the division of ProQuest that I work for. I'm work in Ann Arbor, the place I'm refering to is in Belleville, which is between Detroit and AA. -Original Message- Sent: Wednesday, December 17, 2003 3:49 PM To: Multiple recipients of list

Oracle 9i reports

2003-12-17 Thread Nalla Ravi
Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are

Re: no longer listening

2003-12-17 Thread LeRoy Kemnitz
I was able to track activity on the network trying to access the default port. Not sure that was the cause or not. I am not an expert but since I changed - no problems. I am running 9.2.0.4 on unix 5.1. "QuijadaReina, Julio C" wrote: Thanks for replying Leroy, I am running Oracle 9i

RE: Career Advice

2003-12-17 Thread Saira Somani-Mendelin
Dennis, As always, you offer excellent suggestions. You have all given me many things to consider. Thank you for taking the time to help me out! It is, indeed, a suberb mailing list. Saira -Original Message- DENNIS WILLIAMS Sent: December 17, 2003 3:40 PM To: Multiple recipients of

RE: standby database configuration in 9iR2 SE ?

2003-12-17 Thread Niall Litchfield
The docs on data guard also include the steps required for manual recovery - as a sort of afterthought admittedly but they are there. If I remember I'll dig up my docs from work on this - I keep meaning to write something on this exact subject. Drawbacks include the fact that you have to keep

Re: no longer listening

2003-12-17 Thread Mladen Gogala
So, how are your host names resolved? Any changes in DNS or WINS name servers? Did anybody reboot or alter PDC? On NT host names are resolved by asking PDC . If it cannot respond because of reboot, listener may shut down as well. You should try modifying yur local equivalent of nsswitch.conf.

Re: Career Advice

2003-12-17 Thread Stephane Faroult
Believe somebody who first learned SQL back in 83, it's too late for Java now. Run-of-the-mill skill. Any young grad will know it and will be less 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

RMAN Retention Policy

2003-12-17 Thread MacGregor, Ian A.
How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571:

Re[2]: Career Advice

2003-12-17 Thread Jonathan Gennick
Wednesday, December 17, 2003, 4:24:50 PM, Bobak, Mark ([EMAIL PROTECTED]) wrote: BM I'm work in Ann Arbor, the place I'm refering to is in Belleville, which is between Detroit BM and AA. Hey, I know Belleville, sort of. Back when I as a kid, my dad used to deliver potato chips to some Belleville

RE: DISASTER RECOVERY with Continous Access

2003-12-17 Thread Mandar A. Ghosalkar
When I got my XP48 I had the option to buy Continous Access, but found it too pricey for my requirements. Got oracle data guard with ssh compression for oracle disaster recovery. -Mandar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spears, Brian

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

Re: Career Advice

2003-12-17 Thread Jared . Still
Perl: Since you're working with Oracle, if you were to buy only one book, you might consider: http://www.oreilly.com/catalog/oracleperl If you but 20 of them I can take my wife out to lunch. Not a bad idea to have Learning Perl, Programming Perl, The Perl Cookbook and The Perl DBI. Very few

Re: no longer listening

2003-12-17 Thread Jared . Still
I've had similar problems, however, it isn't just limited to Oracle listeners. NT and Win2k are both problematic when it comes to reliably starting services at bootup. They both occasionally have a problem with a service dying for no apparent reason. I don't know why this is. To deal with it

RE: Career Advice

2003-12-17 Thread Grant Allen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 December 2003 11:34 To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice Perl: Since you're working with Oracle, if you were to buy only one book, you might consider:

Off-topic postings

2003-12-17 Thread Paul Baumgartel
I hope everyone will take Jared's admonition about off-topic postings to heart. I like to keep up with this list, and I get very frustrated at the waste of time involved in reading replies to a technical topic that contain no technical content. (And no, I'm not humorless, but work is work and

RE: Career Advice

2003-12-17 Thread DENNIS WILLIAMS
Viktor My suggestion is to go for Perl as the quick win and impress your new boss. Perl also tends to be more useful for DBAs. Learning Java can be a more long-term proposition. First, you need to have a strong understanding of object-oriented design. We have trained developers in Java,

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

nls_lang

2003-12-17 Thread bulbultyagi
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus

Any known problems using NOT IN ?

2003-12-17 Thread Siddharth Haldankar
Hi Gurus, I have a problem using NOT IN clause in Oracle. However using NOT EXISTS, gives me the right output. Are there any known limitations. This query selects from the master records wherein child records are not active. select * from ct_software_release csr where csr.class

RE: Any known problems using NOT IN ?

2003-12-17 Thread Charu Joshi
Siddharth, The NOT IN query fails to return rows, if the inner sub-query returns NULL values. It is always recommended to use the NOT EXISTS clause, unless you are sure that the inner query will not return any NULLs. Regards, Charu. -Original Message-From: [EMAIL PROTECTED]

RE: Any known problems using NOT IN ?

2003-12-17 Thread Naveen, Nahata (IE10)
Doess the column crs.os_id_fk1 contain nulls? Regards Naveen -Original Message-From: Siddharth Haldankar [mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: Any known problems using NOT IN ? Hi Gurus,

RE: Any known problems using NOT IN ?

2003-12-17 Thread Siddharth Haldankar
Charu, Thanks for your explanation. It is perfectly valid for me. Thanks Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From:

db block gets /consistent gets

2003-12-17 Thread Sultan Syed
Hi list, What is db block gets and consistent gets.? How can I reduce consistent gets ? Ask Tom says each consistent gets is latch, how it could be? Thanks in advance Syed