Re: Re: How to Lock and unlock a table until SP completes
SP: Stored Procedure[EMAIL PROTECTED] wrote: what is an 'SP'? From: "Tanel Poder" <[EMAIL PROTECTED]> Date: 2003/08/04 Mon AM 08:54:31 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: How to Lock and unlock a table until SP completes Hi! You could also play with set transaction read only, set transaction isolation level serializable or opening all cursors in beginning of SP and only closing them when all work is done to achieve consistency you need. Tanel. - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Monday, August 04, 2003 9:09 AM Subject: How to Lock and unlock a table until SP completes Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec! , but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven -- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software Hi! You could also play with set transaction read only, set transaction isolation level serializable or opening all cursors in beginning of SP and only closing them when all work is done to achieve consistency you need. Tanel. - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Monday, August 04, 2003 9:09 AM Subject: How to Lock and unlock a table until SP completes Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwareRegards,[EMAIL PROTECTED] Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: How to Lock and unlock a table until SP completes
YesJoe Testa [EMAIL PROTECTED] wrote: sp = stored procedure?joe[EMAIL PROTECTED] wrote:what is an 'SP'? From: "Tanel Poder" <[EMAIL PROTECTED]>Date: 2003/08/04 Mon AM 08:54:31 EDTTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Subject: Re: How to Lock and unlock a table until SP completesHi!You could also play with set transaction read only, set transaction isolation level serializable or opening all cursors in beginning of SP and only closing them when all work is done to achieve consistency you need. Tanel. - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Monday, August 04, 2003 9:09 AM Subject: How to Lock and unlock a table u! ntil SP completes Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven-- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software Hi! You could also play with set transaction read only, set transaction ! ; isolation level serializable or opening all cursors in beginning of SP and only closing them when all work is done to achieve consistency you need. Tanel. - Original Message - *From:* WLSH <mailto:[EMAIL PROTECTED]> *To:* Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> *Sent:* Monday, August 04, 2003 9:09 AM *Subject:* How to Lock and unlock a table until SP completes Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one ! give me an example? Thanks Steven Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software-- Joseph S TestaChief Technology Officer Data Management Consultingp: 614-791-9000f: 614-791-9001-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Joe TestaINET: [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 'ListG! uru') 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).Regards,[EMAIL PROTECTED] Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
How to Lock and unlock a table until SP completes
Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Try Again: Outer Join with SUBSTR
Hello, List: I'm doing a outer join with SUBSTR, but can't get it to work. Is there a way to get correct or get around it? Thanks in advance SELECT rtrim(komp.inventar), rtrim(komp.typ), rtrim(komp.herst), rtrim(sysstand.so_nr), rtrim(person.vname), rtrim(person.nname), rtrim(lisa.assetnumber), rtrim(lisa.unittype), rtrim(lisa.macaddress), rtrim(lisa.ipaddress), rtrim(lisa.operatingsystem), rtrim(lisa.servername), rtrim(lisa.lastrundate), rtrim(lisa.serialnumber), rtrim(lisa.person), rtrim(lisa.location), rtrim(smarts.pcmacaddress), rtrim(smarts.pcip), rtrim(smarts.portname), rtrim(smarts.portdesc), rtrim(smarts.switchname), rtrim(smarts.switchipaddres! s), rtrim(smarts.switchlocation), rtrim(smarts.vendor), rtrim(smarts.site), rtrim(smarts.custname), rtrim(smarts.scandate), rtrim(smarts.giltbis)FROM kompneti, komp, sysstand, person, c_lisa_data lisa, kompsys, syspers, c_smarts_data smarts WHERE kompneti.mac_adr = lisa.macaddress and kompneti.giltbis = '2100-01-01-00.00.00.00' and kompneti.ident = komp.ident and komp.ident = kompsys.ident and kompsys.giltbis = '2100-01-01-00.00.00.00' and kompsys.system = sysstand.system and sysstand.giltbis = '2100-01-01-00.00.00.00' and kompsys.system = syspers.system(+) and syspers.giltbis = '2100-01-01-00.00.00.00' and syspers.pers_nr = person.pers_nr(+) and smarts.giltbis = '2100-01-01-00.00.00.00' and! lisa.macaddress = substr(pcmacaddress,10,2) || substr(smarts.pcmacaddress,13,2) || substr(smarts.pcmacaddress,16,2) || substr(smarts.pcmacaddress,19,2) || substr(smarts.pcmacaddress,22,2) || substr(smarts.pcmacaddress,25,2) (+) /Or Use:substr(pcmacaddress,10,2) || substr(smarts.pcmacaddress,13,2) || substr(smarts.pcmacaddress,16,2) || substr(smarts.pcmacaddress,19,2) || substr(smarts.pcmacaddress,22,2) || substr(smarts.pcmacaddress,25,2)(+)=lisa.macaddress/Or Use:(substr(pcmacaddress,10,2) || substr(smarts.pcmacaddress,13,2) || substr(smarts.pcmacaddress,16,2) || substr(smarts.pcmacaddress,19,2) || substr(smarts.pcmacaddress,22,2) || substr(smarts.pcmacaddress,25,2))(+)=lisa.macaddress! / Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Re: How to zip a file on From Unix shell script
Thanks, all: We have compress available currently, but not gzip or zip. We will try compress. Mark Richard [EMAIL PROTECTED] wrote: RWB is correct - and the good news is that WinZip (a likely program at thedestination of your email) handles tar-ed and compress-ed files fine. Ofcourse it may pay to add the .zip extension to the filename so that themail client knows what to do with it.Reginald.W.Bailey@jp morgan.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell script 17/10/02 09:38 Please respond to ORACLE-L You can use compress or gzip to compress a file. compress -v [filename]should compress the file and tell you the percentage as well. Gzip is a GNUutility that may be on your system. These utilities may not be in yourcurrent path.RWBWLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0! ! 5:43:33 PMPlease respond to [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc:Hello, list:We have a unix nightly job which will send an email to a user. However, thefile size is very large, so we need to zip the file before we send it out.Does anyone know the syntax or command of zipping a file from UNIX ?Regards,[EMAIL PROTECTED]Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com--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 mai! ! ling 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).Privileged/Confidential information may be contained in this message.If you are not the addressee indicated in this message(or responsible for delivery of the message to such person),you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the senderby reply e-mail or by tele! ! phone on (61 3) 9612-6999.Please advise immediately if you or your employer does not consent toInternet e-mail for messages of this kind.Opinions, conclusions and other information in this messagethat do not relate to the official business ofTransurban City Link Ltdshall be understood as neither given nor endorsed by it.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mark RichardINET: [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).Regards,[EMAIL PROTECTED]Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
How to zip a file on From Unix shell script
Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ? Regards,[EMAIL PROTECTED]Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
How to zip a file on From Unix shell script
Hello list: We had a Unix job ran nightly and will send email to a user. But the file size is very large. So we need to zip the file when we send email to user from UNIX. Does any one know the syntax or command of doing this(zip file) ? Regards,[EMAIL PROTECTED] Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
