Copy data from one column to another in oracle table

http://dbissues.blogspot.com/2016/03/copy-data-from-one-column-to-another-in.html

create table abc

(Num VARCHAR2 (10),

Address varchar2 (10));

select * from abc

for update

insert into abc

values (2,null);

update abc set ADDRESS = NUM;

How to Upgrade java plugin in EBS Enviroment

http://dbissues.blogspot.com/2016/03/how-to-upgrade-java-plugin-in-ebs.html

IF you want to upgrade java plugin in ebs environment for running ebs on windows browser.

1:) Downlaod jre plugins  from (Deploying JRE (Native Plug-in) for Windows Clients in Oracle 
      E-Business Suite Release 12 (Doc ID 393931.1)

2:) Download your choice jre plugins from the above document. In my case I have downloaded  
      this jre-->>>  p16534039_160450_WINNT.zip

3:) Run application enviroment and down apps from $ADMIN_SCRIPT_HOME 
      adstpall.sh  <--- run      this script to down apps.

4:) Unzip the jre patch which you have downloded from the above document in step 1. from
      the following command.
      ----   unzip -o p16534039_160450_WINNT.zip  

5:) After unzip you see that it provide both JRE and JDK. But you have to set jre.
      jdk-6u45-windows-i586.exe  
      jre-6u45-windows-i586.exe

6:) Then move the (jre-6u45-windows-i586.exe) from the patch to the following location
      -->>/u01/oracle/PROD/apps/fs1/EBSapps/comn/webapps/oacore/util/javaplugin/??

7:) Then rename jre-6u45-windows-i586.exe like this j2se16045.exe.

8:)  Run apps env  then execute $FND_TOP/bin/txkSetPlugin.sh script against the web node of
       the application tier.
       $ txkSetPlugin.sh jversion [clsid_param] <--- In this classid means 16045 which is the id of  
        jre-6u45-windows-i586.exe.
       LIKE this --->>>>   ./txkSetPlugin.sh 16045


9:) Run application from  $ADMIN_SCRIPT_HOME adstrtall <--