MySQL Forums
Forum List  »  MySQL Query Browser

convert Oracle to mysql type
Posted by: pratik kanawade
Date: February 27, 2012 07:01AM

ORG_ID NUMBER default TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,1 ) , ' ',NULL,SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,10 ) ) ),



Can anybody plz convert this Oracle syntax to mysql?

I know that I need to cast like
eg-to_number(to_char(sysdate,'J'))

ans-:cast(SUBSTRING(yourVer,4) as UNSIGNED)

Can anybody write for my syntax

Thanks

Options: ReplyQuote


Subject
Written By
Posted
convert Oracle to mysql type
February 27, 2012 07:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.