Re: Help converting a SHA1 hash to Oracle

2023-01-19 Thread Benchao Li
Hi Jonathan, # For the first question: "how I get VARCHAR(200) in my cast function" You passed wrong operand now (new SqlIdentifier("VARCHAR(200)", SqlParserPos.ZERO);), it should be a SqlDataTypeSpec, not a SqlIdentifier for the cast's second operand. # For the second question: "everything

Help converting a SHA1 hash to Oracle

2023-01-18 Thread Jonathan Farina
Hi I am trying to write some code that will take a MySQL SQL statement that includes a SHA1 hash statement and have it translate successfully to Oracle and in doing so add a cast function. Eg: select sha1(address) from locations limit 10 Should translate to: SELECT