CODEWITHSUNDEEP
sqloracle-database
user1010572
user1010572

Reputation: 479

Equivalent of fn Convert in oracle

What is the equievelent of this statement in oracle

SELECT {fn CONVERT(mycolumn, nvarchar) }
as MyConvertedColumn FROM MyTable;

according to link

it should be 

SELECT {fn CONVERT('Groß', 'US7ASCII') }
"Conversion" FROM DUAL;

but that is not working either

Upvotes: 0

Views: 125

Answers (1)

Florin Ghita
Florin Ghita

Reputation: 17643

It's a mistake there, should be written:

SELECT CONVERT('Groß', 'US7ASCII') "Conversion" FROM DUAL;

in 11g documentation is ok.

Upvotes: 2

Related Questions