SQL script to convert from varchar to number without losing data

same time converting , in varchar to . for number column

alter table tablename add(dummycolumn number(20,2));

update tablename set dummycolumn = to_number(replace (actualcolumn,',','.'),'9999999999.99');

alter table tablename drop column actualcolumn cascade constraints;

alter table tablename rename column dummycolumn to actualcolumn;

foramtting number according to country currency in java

java.text.NumberFormat.getInstance(Locale.GERMAN)

How to prepare sql insert scripts from excel

=" insert into emp values("&A2&","&B2&","&C2&");"

Program to reverse a String

package com.test1;

import java.util.Scanner;

public class StringReverse {

public static void main(String[] args) {

String original, reverse = "";

     Scanner in = new Scanner(System.in);

 

     System.out.println("Enter a string to reverse");

     original = in.nextLine();

 

     int length = original.length();

 

     for ( int i = length - 1 ; i >= 0 ; i-- )

        reverse += original.charAt(i);

 

     System.out.println("Reverse of entered string is: "+reverse);

}

}