Search results for query: *

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

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"

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

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?

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

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!

Hello, Try this : date1 = to_date(sysdate,'dd-MM-yy)

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!

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!

Sem, how is this NVL function works?

"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...

And do you have suggest about it?

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'))...

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

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!

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

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?

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'...