Karthik,
Try CHR(13).. I use it all the time to format text output...
Shailesh
-Original Message-
Sent: Friday, July 06, 2001 11:40 PM
To: Multiple recipients of list ORACLE-L
Not very sure about that but I think that you can try finding the ascii
value of the enter key (i.e. a
Not very sure about that but I think that you can try finding the ascii
value of the enter key (i.e. a newline character) and use this value to
identify the enter operation...but do we have an ascii value for a newline
character ...? any ideas, anyone ?
Regards,
Karthik Mohan
-Original
thanks a lot..
one more thing...how to get the value of return key using sql..
i mean using gui data is entered and the user used enter key for next line
so how to get that
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes.
hi all
i have one table in which the note column have following entries
ID NOTE
-
31177340 400A
31177374 FITZGERALD FENCE
31177394 FASHION BUG
31177454 PRECISION LITHOGRAVING
31177472 TOBIN BROS - VACANT
31177497
Try this
for leading spaces :
select name,length(name),rtrim(name)
fromora_test
where length(rtrim(ltrim(name))) != length(rtrim(name));
for lagging spaces :
select name,length(name),ltrim(name)
fromora_test
where length(ltrim(rtrim(name))) != length(ltrim(name));