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 derfloh 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
  • Order by date
  1. Iby

    Select from two different database

    Thank you very mutch Robbie, your help was great!!! Ibi
  2. Iby

    Select from two different database

    Sorry Robbie, one more question: Why did I get this msg. when I would like to run a select but before the link creating was successful? "ORA-02019 connection description for remote database not found"
  3. Iby

    Select from two different database

    Thank you Robbie, now it's absolute clear!! Kind Rgds. Ibi
  4. Iby

    Select from two different database

    Robbie, Thank you for your help. One thing what I still don't understand that what does it mean that statement between '' and after the USING?
  5. 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
  6. 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!
  7. Iby

    = Sysdate

    Hello, Try this : date1 = to_date(sysdate,'dd-MM-yy)
  8. 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!
  9. 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
  10. Iby

    "NOT IN" clause Somebody kow why h

    Sem, how is this NVL function works?
  11. 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...
  12. Iby

    Please help me somebody, what is th

    And do you have suggest about it?
  13. Iby

    Please help me somebody, what is th

    what i forgot? SELECT * FROM OMS_POHEADM WHERE To_Date(DATE_ENTERED,'dd/MM/yy') = if (To_Date('01/05/02', 'dd/MM/yy') = To_date('01/01/70','dd/MM/yy')) then To_Date('01/05/02', 'dd/MM/yy') elsif (To_Date('01/05/03', 'dd/MM/yy') = To_date('01/01/70','dd/MM/yy'))...
  14. 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!
  15. 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!
  16. Iby

    I would like to make a SELECT and t

    Yes andypara, I would like to use PL/SQL code. Do you have any idea?
  17. Iby

    I would like to make a SELECT and t

    Thank you andypara, I know the 'decode' so well but I wouldn't like to use that because in my case it looks like too slow and that's why I would like to choose an another possibility if it's possible. Could you please to offer an another solution for that?
  18. 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