Seeing the full column caption [message #340333] |
Tue, 12 August 2008 06:34 |
shachipathak
Messages: 16 Registered: December 2007 Location: Bangalore
|
Junior Member |
|
|
Dear Sir,
When i run the query
SELECT TRANSLATE(
'HELLO WORLD', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
'1234567890!@#$%^&*()-=_+;,.') ENCODED_MESSAGE
FROM DUAL
/
The Output is
ENCODED_MES
-----------
85@@% _%*@4
Why i am not able to see the full column name?
What is the solution?
Thanks
Shachi
|
|
|
|
|
|
Re: Seeing the full column caption [message #340416 is a reply to message #340333] |
Tue, 12 August 2008 12:40 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
In SQL, it is also possible to cast result to required length (however if used further, it will be trimmed when longer) SQL> select cast( 'sss45678901234567890' as varchar2(15) ) encoded_string from dual;
ENCODED_STRING
---------------
sss456789012345
|
|
|