Re: Senior DBA position - Dublin, Ireland

2002-05-30 Thread Brian_McQuillan
Rachel, if his Mother is Irish, all he needs to do is ask for the passport - once he has it - you can apply for one as long as you've been married for over three years i think , again try the government sit http://www.irlgov.ie -it'll give you all you need to know Brian. Brian Mc Quillan

Re: Senior DBA position - Dublin, Ireland

2002-05-29 Thread Brian_McQuillan
Rachel, The quarantine laws are the same as the UK - put your pet in quarantine for 6 months to see if it has rabies - a bit cruel these days when you figure that they can probably tell you within a week or so if your pet is ill. If you've never thought about Dublin - you should - I worked

Re: Senior DBA position - Dublin, Ireland

2002-05-29 Thread Brian_McQuillan
Tim, that's fairly accurate from what i'm told. But it only goes as far back as your grandparents - if you can provide a birth cert and other documentation to prove that it's your granny then yes you can get the passport. And it is also true that once you have that , you can work anywhere in

Re: Customize my SQLPlus login

2002-03-26 Thread Brian_McQuillan
in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off

RE: Production Oracle DBA Needed in Rochester, Minnesota

2002-03-22 Thread Brian_McQuillan
yeah, we use those jumbo hours here and have renamed saturday to be friday part 2 Schilling, Ben

Re: TOAD Software???

2002-01-15 Thread Brian_McQuillan
Bill wrote : oh I'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? I happen to have done some fairly extensive research on the Irish version of these tools :-), but the results are mixed. There isn't much in the way of

Re: Quick select question

2001-06-20 Thread Brian_McQuillan
Lee, try this script - it should do what you want Brian start script set pause off set pages 0 set feedback off set echo off set verify off accept TNAME prompt Enter the table name / string, hit ENTER for all tables : accept TOWNER prompt Enter the table owner to count, hit ENTER for

RE: OT - RE: Digestive

2001-06-13 Thread Brian_McQuillan
But Walt , it tastes like p***, that's why it's so cheap Brian. Weaver, Walt [EMAIL PROTECTED]@fatcity.com on 06/13/2001 05:17:24 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Stroh's Lite. 9 bucks

Re: SSN's

2001-06-12 Thread Brian_McQuillan
Careful about using 999 numbers , the IRS actually use these for non resident taxpayers. (Spouses of H1- B visa holders etc) For all you H1-B's out there, if your H4 other half can't get an SSN, then they must have a number from the INS called a TaxPayer ID number (TIN). Otherwise the banks

RE: Digestive

2001-06-12 Thread Brian_McQuillan
On the subject of Scotch ... As the only certified (that I know of) genuine born and bred Scotsman on the list these days (Originally from Glasgow Scotland, and now scraping a living as a Development DBA in Minneapolis MN) I have to say that they are all wonderful, you don't get a bad

Re: how to substr '%' from the data?

2001-06-11 Thread Brian_McQuillan
Helen, try this instead,, It should help select substr(mystring,1,(instr(mystring,'%') -1)) from mytable eg below DEVcreate mytable (mystring varchar2(10)); Table created DEVinsert into mytable values ('abcdefgh%jkl'); 1 row created DEVinsert into mytable values ('a%cdefghjkl'); 1 row created

Re: OT: My bad

2001-05-25 Thread Brian_McQuillan
excellent Speaks, Chuck W. [EMAIL PROTECTED]@fatcity.com on 05/25/2001 12:57:47 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I didn't mean to reply-all. That's my bad. Chuck Speaks, MCSE Database

RE: Binding a process to a CPU .

2001-05-22 Thread Brian_McQuillan
it means happy to help Christopher Brian. Christopher Spence [EMAIL PROTECTED]@fatcity.com on 05/22/2001 04:21:12 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: What does hth, Mean? -Original

Re: OT: LazyDBA List Owner?

2001-04-29 Thread Brian_McQuillan
Larry, it's Henry O'Keefe - the last email address I have on file for him is this [EMAIL PROTECTED] hope it helps Q [EMAIL PROTECTED]@fatcity.com on 04/29/2001 10:05:19 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

RE: PL/SQL-if-statement

2001-04-19 Thread Brian_McQuillan
Lisa Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess Love the new by line - it suits you well - but one question - is that Self Certified Self Important datavbase Deity or did you pass a special

RE: OT : Sinclair was RE: Metalink Again

2001-04-05 Thread Brian_McQuillan
Ben, I can vouch for that one - I gassed up there last Saturday while driving from New Jersey to Minneapolis ( a loong drive) stayed overnight in Madison , a very nice town. Went into a little brewpub near the capitol, E Wilson street ?? - i forget Brian "Schilling, Ben" [EMAIL

OT : Sinclair was RE: Metalink Again

2001-04-04 Thread Brian_McQuillan
Sinclair was a brand of personal computers that came out in the UK about 20 years ago, If memory serves , they started of with the ZX 81 which had a whole 1K of memory. Their next offering was the Spectrum 16K followed by the 48K. with rubber keys and programmable in basic. I remember back in

Re: MS KB Article

2001-02-23 Thread Brian_McQuillan
nice one ! i wonder how long it'll be till they notice Brian "Mohan, Ross" [EMAIL PROTECTED] on 02/23/2001 09:30:24 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Brian McQuillan/GELCO) Check this out quickly before

Re: Am I too hard on the developper ?

2001-02-16 Thread Brian_McQuillan
Stephane, stick to your guns - part of the dba's job (as I see it, and try to do ) is to help guide the developers in the best way to do things on the database if it's your choice that they should do an alter table, then that's what they should do. don't give in. Brian. paquette stephane

Re: Off Topic: Red Dwarf

2001-02-15 Thread Brian_McQuillan
I didn't know there were so many Douglas Adams fans out there on the list, I've been following the hitchhikers guide since it first appeared as a radio show back in the UK, the TV show never did justice to the books or the radio show but was till fantastic. I love all of Douglas Adams stuff.

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Brian_McQuillan
Rocky, She lost the bet and got a raise - go figure ! well done lisa , we still wish you were back in Eden Prairie ! Q Rocky Welch [EMAIL PROTECTED] on 02/05/2001 03:45:33 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: