PL/SQL help - need some quick help
Hallo, I have some trouble to get this pl/sql code right. Anyone whpom could help me with this. It is important. Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement, whatis wrong with this? It get the erromressage: LS-00103: Encountered the symbol ||AvdNr|| when expecting one of the following: . ( * % = - + / at in mod not rem then an exponent (**) or != or ~= = = and or like betwe.. when I compile the whole procedure. Please help me with this. (If the borttags_flagg = 1 then it will continue the loop and check for next one. etc... If A'||AvdNr||'.ICA_ARTIKEL'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' || then (this lvsql is to be run only if field borttags_flagg = 0) lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.BORTTAGS_FLAGG,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPKORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL'||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMTO_DATE('''||inDatum||''',''-MM-DD'') ' || -- 'AND ICA_ARTIKEL.BORTTAGS_FLAGG = 0 ' || 'ORDER BY DATUM DESC'; The whole procedure you can see in the file: (See attached file: testplsql.SQL) Thanks in advance Would really appreciate this. Roland S (See attached file: testplsql.SQL) Thanks in advance. Roland testplsql.SQL Description: Binary data
Re: urgent help need please
Chark(sp?) - Is your listener running? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Sairlao, Chark SairlaoC@transfie To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ld.com.au cc: Sent by: Subject: urgent help need please [EMAIL PROTECTED] 08/12/2001 10:30 PM Please respond to ORACLE-L all, our company just installed the virtual private network equipment (Enterasyss Network), then suddenly peoplesoft application can not login to the oracle database any more, came back with ora 12203, then I tries tnsping nothing works either, however I can do sqlplus user/password@tns and it lets me in ok. any idea please? Thanks And Regards Chark Sairlao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark 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).
urgent help need please
all, our company just installed the virtual private network equipment (Enterasyss Network), then suddenly peoplesoft application can not login to the oracle database any more, came back with ora 12203, then I tries tnsping nothing works either, however I can do sqlplus user/password@tns and it lets me in ok. any idea please? Thanks And Regards Chark Sairlao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark 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: Help Need
Hi, This statement will get you the userid and the number of times it is duplicated. Then it's just a case of inserting the value at the desired location. Although this does mean that you are either going to have a column with lots of null values or lots of repeated values...Doesn't really make a lot of sense either way. select userid, count(userid)-1 from user group by user_id; Regards, Kev. -Original Message- Sent: 02 August 2001 12:40 To: Multiple recipients of list ORACLE-L Hi DBA Gurus, I have a table called user.. It has userid, firstname, lastname, city, address, telephone, email There are some userid which have been reentered .. I would like to insert a column called repeats and take the number of times the userid is repeated How to I go about it Create table usercheck as (userid, firstname, repeated,lastname, city, address, telephone, email) As Select userid, firstname, count(*) userid as repeated,,lastname, city, address, telephone, email) From user; Something like this.. For example the userid of Deewaker is 123123 and he as been inserted 5 times in the table USER the Repeated should give a count of 4. Please help me. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. *: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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).
Help Need
Title: Help Need Hi DBA Gurus, I have a table called user.. It has userid, firstname, lastname, city, address, telephone, email There are some userid which have been reentered .. I would like to insert a column called repeats and take the number of times the userid is repeated How to I go about it Create table usercheck as (userid, firstname, repeated,lastname, city, address, telephone, email) As Select userid, firstname, count(*) userid as repeated,,lastname, city, address, telephone, email) From user; Something like this.. For example the userid of Deewaker is 123123 and he as been inserted 5 times in the table USER the Repeated should give a count of 4. Please help me. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf Deewaker G.V..vcf
Help need
Title: Help need HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf Deewaker G.V..vcf
RE: Help need
Deewaker, information you find with this select-stmt, perhaps you need to format the output. Depending on what you're looking for you should select either from the view: user_indexes all_indexes dba_indexes select table_name, index_name, tablespace_name from user_indexes group by table_name, index_name, tablespace_name; TGIF Stephan -Original Message- Sent: Friday, July 27, 2001 10:50 AM To: Multiple recipients of list ORACLE-L HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?J=E4ck_Stephan?= 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: Help need
Title: Help need Hi deewakar, hope this will help.. SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/ Saurabh Sharma Oracle DBA [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Deewaker G.V. To: Multiple recipients of list ORACLE-L Sent: Friday, July 27, 2001 2:20 PM Subject: Help need HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf