Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Zargo
  • Order by date
  1. Zargo

    Check if a value exists in the table

    Hi All, I have a table with the following content: TableB ColumnA 1034% 2900% 3444% 10% (the percent signs in the tables are wildcards) I have a value 103459 (its a variable) and i want to check if this exists in the table; this value exists in the table because we have a value in the table...
  2. Zargo

    Order by clause

    Hi, There is a misinterpretation. In my case T4= T3 Couldn't we use ORDER BY T1, decode(substr(t3,1,1), '0', 1, 2) Because T3 contains always 0001, 0002, 0003 ... till 0010 and GHAL. Will this issue solved with ORDER BY T1, decode(substr(t3,1,1), '0', 1, 2) TIA
  3. Zargo

    Order by clause

    Could you also please explain what this function exactly does(DECODE)? The t1 column can also contain characters like 'GE10023', does this function work ok?
  4. Zargo

    Order by clause

    Hi all, I have a table with the following content: TABLEA T1 | T2 | T3 123 1231243 GHAL 123 0003423 0001 123 3242342 0002 488 2342344 0001 456 3333444 0001 456 6526545 GHAL I want to to order this table by T1 and T3, but the order of the T3 must be: 0001...
  5. Zargo

    How to get the FI document number (FICO)

    Hi all, I have an application which communicates with MySAP 2005. I can query to get some information. Do you know where i can find the FI document number and the MM document number? I have the invoicenumber, suppliernumber, invoice date and company, can i find the FI document number and the MM...
  6. Zargo

    Stripping the streetname from the number

    Hi, I hope this will be the last quesion for today. I have a table with streetnames and housenumbers. I want to update this column with only the streetname and put the housenumber in another column. The table which i have is look like: TableA street | supplement My street 123 | StreetABC 56...
  7. Zargo

    Query question

    Sorry i had not test the solution yet. But it worksss thanks a lot both. A big star again..
  8. Zargo

    Query question

    Hi Dagon thanks for your reply. THe table is very huge. What if i have the following content: XX_TABLEB T1 USER_NAME 10% ZARGO 11% ZARGO 20% OTHER 53% ZARGO 8776% ZARGO I want to build the where clause more flexible then INSTR(x.t1,y.t1) = 1, how to...
  9. Zargo

    Query question

    SantaMufasa thanks for your reply. My table is very huge, and in this example i can use WHERE INSTR(x.t1,y.t1) = 1 but in the live situation i would like to use the data in the table with the wilcards. Do you know another way to get the right result. To make it more difficult in my application i...
  10. Zargo

    Query question

    Dagon and Mufasa, thanks so many for your reply. Dagon you understand me correctly, the table literally contains '10%' and i want to use the percent sign as a wildcard. When i use your statement i will get the following error message: ORA-01427: Single-row subquery returns more than one row...
  11. Zargo

    Query question

    Hi all, SELECT * FROM XX_TABLEA WHERE T1 LIKE (SELECT T1 FROM XX_TABLEB WHERE USER_NAME = 'ZARGO') The tables are look like: XX_TABLEA T1 1100023 1012132 2012121 And the other table: XX_TABLEB T1 USER_NAME 10% ZARGO 11% ZARGO 20% OTHER I want to get these...
  12. Zargo

    Update query

    Hi, I have a table like this: tableA ColumnA NK232341234B01 111234556 JHJLKJKJLB01 SDFKSDJFLKASB01 How can i update these records to change the substr(columnA,-3,1) from B to 8 if this position has a B? When the value is like NK232341234B01 it must be NK232341234801 Hope somebody can help...
  13. Zargo

    Splitting data, cursor set or stored procedure?

    Sorry i forget to add this. I have another table with the actual values: Table3 columnA A1 A7 A8 So i only will get these values in tableB: TableB ColumnA ColumnB 566677 A1 566677 A7 566677 A8 and so on...
  14. Zargo

    Splitting data, cursor set or stored procedure?

    Hi all, I have a table with 3 columns TableA ColumnA ColumnFrom ColumnTo 566677 A1 A6 341334 TEST TEST 234333 000023 000150 I must put this information into another table with all values between ColumnFrom and ColumnTo TableB ColumnA ColumnB 566677 A1 566677 A2 566677 A3...
  15. Zargo

    Query question

    Thanks guys. A star for the golden solution...
  16. Zargo

    Query question

    THere must something with a.docsid = b.docsid but how to add that in the queries?
  17. Zargo

    Query question

    Hi, Thanks AlexCuse, but it doesn't give the results. What i want to know is(it is an huge table) from that table all docsid's which has first a LINDEX 6007 and after this for the same docsid a LINDEX 1005. Docsid 112334 is an example. How can i find all the docsid's with the same criteria?
  18. Zargo

    Query question

    Hi all, Does anybody know how i must create a query to get the following result: TableA DOCSID DATE LINDEX 112334 14-12-2006 20:18:00 6007 112334 14-12-2006 20:23:00 1023 112334 14-12-2006 20:54:00 1005 112334 14-12-2006 20:56:00 1058...
  19. Zargo

    Writing the trigger smarter

    Still waiting for the golden solution...
  20. Zargo

    Writing the trigger smarter

    Hi SQLsister, Thanks a lot for your reply. How to do that?

Part and Inventory Search

Back
Top