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