Hi guyz, can you please let me know the equilavent of “select chr(6) from dual” from oracle in vb.net?
Your question doesn’t make any sense. Your query doesn’t change if you are using the same database as you did previously…
CHR is an Oracle function, so it would remain “select chr(6) from dual”
I agree with @cpradio.
That’s SQL so you open the connection to the database, send the query, receive the result and fetch it.
Now, in this particular case, I would understand if you didn’t want to do this query. After all, char(6) is a constant, and you don’t need to query a constant.
What you would like is the function that, when you give it an ASCII number, it will tell you which the character itself…
In VB (.NET or no .NET), that function is… Chr(6)
Surprising 
thank u all.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.