How to make the email Address Dummy in Oracle Database? Query to make the email Address as dummy, update <tablename> set <Columnname> = '@' || <Columnname> where <Columnname> is not null; Query to Remove the email Address as dummy, update <tablename> set <Columnname>= substr(<Columnname>,2,length(<Columnname>)) where <Columnname> is not null;
Ever wonder to find out the oracle query to find the oracle software version installed on a remote system, Here are the two queries will help you to find the oracle software versions, SELECT * FROM v$version; BANNER Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production "CORE 11.2.0.4.0 Production" TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCT VERSION STATUS NLSRTL 11.2.0.4.0 Production Oracle Database 11g Enterprise Edition 11.2.0.4.0 64bit Production PL/SQL 11.2.0.4.0 Production TN