thanks thread dear thread, create table name as select replace(item,'-',' ' )item from rr
i forget i use search or find command then replace the value and it saves into the table like rr iam using...
Type: Posts; User: ROHIT_4444; Keyword(s):
thanks thread dear thread, create table name as select replace(item,'-',' ' )item from rr
i forget i use search or find command then replace the value and it saves into the table like rr iam using...
thanks but it's not working ---------select item, abs(to_number(item)) from rr1 ora-01722: invalid number ------- iam using function select replace(item,'-',' ' )item from rr ------------------- it's...
dear suji first of all i don't asked same question in my second question i describe my field is varchar-------------------------------------- 1- select abs(convert(item,packed)) item from rr...
suji all answers are wrong ok, abs function not work with varchar field 1- select abs(convert(item,packed)) item from rr ora-00904: invalid column name 2-select abs(convert(item,packed)) as...
it is answerd but wrong my field is varchar how abs() works i have a values like this colum name is item -12345,56789,34567,-23456 i want the output of colum item is like item 12345,56789,34567,23456...
[QUOTE=ROHIT_4444;9764]hye innila i have a varchar field abs() not works with varchar i want to remove the minus sign from a colum supose colum name is item
ITEM
-12345
-12345
-11111
...
hye innila i have a varchar field abs() not works with varchar i want to remove the minus sign from a colum supose colum name is item contaning value item -12345 12345 11111 11111
OUTPUT OF ITEM...
hye thread i have a column varchar contaning values like this -12345 12345 65478 99999 -65432 i want to remove - sign i want that in this colum no "-" sign using substr or any other way
-12345 I have a value like this in my colum some are 23678 i want to remove - sign value after removing - value should be like 12345