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: Iby
  • Content: Threads
  • Order by date
  1. Iby

    Select from two different database

    Hello, Somebody has idea, how can I make a select from two different database? Thank you in advance, Ibi
  2. Iby

    Actual month disp.

    Hello, How can I display only just the month of the systemdate? I think of like this: where (date_field, 'MM') = to_date(sysdate,'MM') Thank you in advance!
  3. Iby

    Hello, Could you please help to

    Hello, Could you please help to me because I would like to use this date format "dd/MM/yy" but I don't know how can I handle. The "@label" field contains the value. Thank you in advance!
  4. Iby

    Date format

    Hello, Could you please help to me because I would like to use this date format "dd/MM/yy" but I don't know how can I handle. The "@label" field contains the value. Thank you in advance!
    • Iby
    • Thread
    • Replies: 5
    • Forum: Java
  5. Iby

    "NOT IN" clause Somebody kow why h

    "NOT IN" clause using Somebody kow why happen if I have a statement which do this: SELECT * FROM OPDETM WHERE WAREHOUSE not in ('dd','di','dx') and then that statements which warehouse code is empty I don't get back from this select. My question is how can I use this "not...
  6. Iby

    "IF" statement use Could you pleas

    "IF" statement use Could you please tell me somebody how can I use the "IF" clause? Thank you!
  7. Iby

    Please help me somebody, what is th

    Please help me somebody, what is the syntactic the "if" statement but I wouldn't like to use decode instead the "if" clause. Thank you!
  8. Iby

    I would like to make a SELECT and t

    I would like to make a SELECT and to use with CASE cause or something else because I have to handle more ELSE. Something like this: SELECT STATUS FROM apple_tree WHERE STATUS = (CASE WHEN STATUS = '1' THEN '1' else (CASE WHEN STATUS = '2' THEN '2' end) else (CASE WHEN STATUS = '3' THEN '3'...

Part and Inventory Search

Back
Top