Question about pl/sql
Hallo, I am trying to create this statement but dont get it work. I would like to check if a field information from table one exists in table 2, and if that exists in table 2, then procedure test_proc would run, Please help me with this. Thanks in advance Roland -- 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.com San Diego, California-- Mailing list and web hosting services - 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: Question about pl/sql code
Looks like the variable borttags_flagg, set in: OPEN c_t_PrisSubstitut FOR lvSQL; FETCH c_t_PrisSubstitut into tmpSubstitutPris,borttags_flagg,ButikPantBelopp; --tmpsubstitutean,tmpSubstitutVarutyp; CLOSE c_t_PrisSubstitut; is set to NULL? Cheers, John Thomas -Original Message- Sent: 05 April 2002 14:53 To: Multiple recipients of list ORACLE-L Hallo, I need some help on this. I woiuld like to include the field borttags_flagg in the table prisregister_kopia_wed but it fails and no records are inserted. In the eror table it says: Missing expression and the bad sql statement says INSERT INTO PBK.PRISREGISTER_kopia_wed(BUTIKID,EAN,PERIOD,LAGSTAPRIS,PRIS,UNDERLAGID,SUB STITUT,KOMMENTAR,BUTIKTYP,VARUTYP,REGICASTATUS,VARENR,LEVNR,VARE_SNR,BORTTAG S_FLAGG) VALUES (116,7312300342180,'200206', 0,9.95,616,NULL,'null', 0 , 0, 1, 290799, 13173, 10, ) The pl/sql code is this file. (See attached file: procinsert.txt) Here it is a missing value it should be a value after the last value 10. Why doesnt the value for borttags_flagg get included when inserted in that table. Would really appreciate help. Thanks in advance Roland ** Legal Disclaimer : This e-mail is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. The opinions expressed in this message are those of the sender and not those of TelesensKSCL. This footnote also confirms that this e-mail has been swept by MIMEsweeper for the presence of computer viruses. Please note that TelesensKSCL monitors both incoming and outgoing emails in accordance with our email policy. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, John 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).
Question about PL/SQL-Unix
How can I create a file, and the send it through mailsystem imediately to a mail recipient.We use Lotus Notes mailsystem. Any good example? Roland Skldblom -- 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).
Question about PL/SQL
Hallo, all you experts Does anyone have any good example of procedure, that does a select statement from the database and afterwards automatically save this resultat to an excel file.? Sincerely Roland Skldblom -- 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).
RE: Question about PL/SQL
Select col1||'|'|| col2||'|'|| col3 From table Where condition set heading off set pause off set pages 1000 spool result.lst Easiest way I know. Then when you bring it into Excel, it's a delimited file with the | as a delimiter. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:10 AM To: Multiple recipients of list ORACLE-L Hallo, all you experts Does anyone have any good example of procedure, that does a select statement from the database and afterwards automatically save this resultat to an excel file.? Sincerely Roland Skldblom -- 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). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan 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).