How to remove extra space in between a string? oracle 10g

SQL> select replace('AAA BBB CCC', chr(32), '') from dual;

REPLACE('
---------
AAABBBCCC

source : https://community.oracle.com/thread/1071627

Oracle Form 6i dynamic query and execute in oracle

  dynamic query

 1.

set_block_property('DIVIEW_SALESES', default_where, 'query statement');

 example :

set_block_property('DIVIEW_SALESES', default_where, 'sls_status='||''''||'A'||''''||' and to_char(sls_date,'||''''||'mm/yyyy'||''''||')='||''''||:tool.REF_DATE||'''');

Done!

Uninstall or Completely remove mysql from ubuntu Bionic Mint 19

Completely remove mysql from ubuntu steb by step :
  

 sudo apt-get remove --purge mysql*
 sudo apt-get purge mysql*
 sudo apt-get autoremove
 sudo apt-get autoclean
 sudo apt-get remove dbconfig-mysql
 sudo apt-get dist-upgrade
 sudo apt-get install mysql-server

Internet explorer stopped working when opening oracle forms 10g windows7

Basically , When U run oracle forms 10g and it shows blank or Stop working on your browser, because Jinit on oracle 10g is not support on that browser. . .

I googled a little and found those problems. . .
Now i will share U how to work  your oracle form 10g on your PC
Basic OS
*Win7
*Oracle Developer 10g
*Java Runtime 6u27

The Idea is finding How to Run oracle form 10g in Mozilla or Any browser

1.

Install Java Environment 

2.

Change The Formsweb.cfg

3.

Add the plugin in browser

source : https://www.youtube.com/watch?v=lzyHQ2PcWHI

How to install oracle developer suite 10g on windows 7

How to install oracle developer suite 10g on windows 7

Actually, I have a little bit problem when i try to install oracle developer suite 10g.
I found error that my system does not support, but now i found the solutions.
It needs a little tricks that will decoy Oracle Standard system required.

Come Let 's Start

1.

Go to "oracle developer suite 10g  Installer Folder"\Install\oraparam.ini

 2.

Find :

[Certified Versions]
Windows=5.0,5.1,5.2
Solaris=5.8,5.9
Linux=redhat-2.1AS
HPUX=B.11.11

 Add this script :

[Certified Versions]
Windows=5.0,5.1,5.2,4.1
Solaris=5.8,5.9
Linux=redhat-2.1AS
HPUX=B.11.11

Find :

[Windows-5.1-required]
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
SWAP_SPACE=1535
TEMP_SPACE=150

Edit :

[Windows-6.1-required]
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
SWAP_SPACE=1535
TEMP_SPACE=150

 Save and exit file.

 3.

Add Virtual memory size
Go To Advanced system settings >>Tab " Advanced ">>Button Performance's "Setting">>Tab " Advanced ">>Button "Change"
Initial size = 4000
Max size = 4000

Ok and restart your PC.

 4.

 Go to "oracle developer suite 10g  Installer Folder
Set Property file Compatibility as "Windows XP Console Pack 2" 

 5.

 Run Setup

6.

Done!

#Source : https://www.youtube.com/watch?v=qYeic14YK-Y