Delete Duplicate Rows Based on a Column

There are so many ways available, but I used oracle analytic .

Use analytic to delete duplicate rows
You can  detect and delete duplicate rows using Oracle analytic functions:

delete from
   <<xxx_accounts>>

where rowid in
 (select rowid from
   (select
     rowid,
     row_number()
    over
     (partition by account_name order by account_name) dup
    from <<xxx_accounts>>
    )
  where dup > 1 )

How to Sign Into Two or More Skype Accounts at Once in Windows

To launch a second Skype application on Windows, press Windows Key + R to open the Run dialog, copy-paste the below command into it, and press Enter.

On a 64-bit version of Windows

"C:\Program Files (x86)\Skype\Phone\Skype.exe" /secondary

On a 32-bit version of Windows

"C:\Program Files\Skype\Phone\Skype.exe" /secondary

You can create shortcut also, so you don't need to repeat the same command again and again

Secure Admin must be enabled to access the DAS remotely

I installed Glassfish on my development server and  access the administration module locally by using “localhost:4048”. But when I try to access it remotely, by using “http:/my_host:port”. It shows me an error as cannot login with the message as

Secure Admin must be enabled to access the DAS remotely

Solution:
Activate the secure admin by using the following command line 

asadmin --host localhost --port 4848 enable-secure-admin

The host is the host name or IP address for the Glassfish Server which we need to enable the secure admin.The port is the target Glassfish Server port which wee need to enable the secure admin.

Rollback

 disable the secure admin, it can be done easily as the following: –
asadmin --host [host] --port [port] disable-secure-admin 

Glassfish Change Admin Password

Use change-admin-password sub command to change the password of glassfish admin user. Default administrator username of glassfish is "admin". Default password of "admin"" user is blank on first installation.


Changing the Administrator Password 

Ensure that the server is running

asadmin --user admin
asadmin> change-admin-password
Please enter the old admin password>
Please enter the new admin password>
Please enter the new admin password again>
Command change-admin-password executed successfully

How to Delete XML Publisher Definition

In the XML publisher Responsibility,  data definition there is no option to delete unwanted or wrong definitions.

BEGIN

XDO_DS_DEFINITIONS_PKG.DELETE_ROW('<<APPLICATION SHORT NAME>>', '<<XML DEFITION CODE>>')

END;