Skip to main content

Posts

How to make the email Address Dummy in Oracle Database?

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;
Recent posts

Oracle Query to Find out the Oracle software Verstion

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

How to find duplicate records in a table?

How to find the duplicate records in a table? Query: Simple Table SELECT c1, c2, ... ,cn, count(*) FROM TableName GROUP BY c1, c2,..., cn HAVING count(*) > 1; Table with Joins: SELECT c1, c2, ... ,cn, count(*) FROM TableName1 INNER JOIN TableName2 on TableName1.ColName=TableName2.ColName GROUP BY c1, c2,..., cn HAVING count(*) > 1;

Oracle Database Administrator Roles and Responsibilities

As an Oracle DBA, you can expect to be involved in the following tasks: -          Installing Oracle software -          Creating Oracle databases -          Performing upgrades of the database and software to new release levels -          Starting up and shutting down the database -          Managing the database’s storage structures -          Managing users and security -          Managing schema objects, such as tables, indexes, and views -          Making database backups and performing recovery when necessary -          Proactively monitoring the database’s health and taking preventive or corrective action as required -          Monitoring and tuning performance In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.

How to create bootable USB drives ?

What You Need: A USB flash drive with good storage capacity; preferably 4GB or more. Access to a computer running Windows Vista or Windows 7. A CD or DVD containing software you want to download. Getting Started: Connect the USB flash drive to a computer running Windows Vista or 7 and follow the steps below: Click Start > All Programs > Accessories > Right click on Command Prompt > Run as Administrator Type ‘diskpart' and press Enter to start the built in Windows disk partitioning utility  Type 'list disk' and press Enter. Identify your USB Flash drive and make a note of the disk number.  Here in this example, My USB flash drive is Disk 1.  Type 'select disk 1' and press Enter.   Type ‘clean’ and press Enter. The clean command will remove partitions or volume formatting from the selected disk (disk 1) by zeroing sectors.  Now to create a partition, type 'create partition primary’ and press Enter.  Type 'select partition 1',

Red Hat Enterprise File System Hierarchy

Do you know the Red Hat File system directories and its usage ? Below are the list of the primary Red Hat Enterprise Linux system directories: /bin/ — Used to store user commands. The directory /usr/bin/ also stores user commands. /sbin/ — Location of many system commands, such as shutdown. The directory /usr/sbin/ also contains many system commands. /root/ — The home directory of root, the superuser. /misc/ — This directory is used for automatically mounting directories on removeable devices (such as Zip drives) and remote directories (such as NFS shares) usingautofs. Refer to the autofs manual page (type man autofs at a shell prompt) for more information. /mnt/ — This directory typically contains the mount points for file systems mounted after the system is booted. /media/ — This directory contains the mount points for removable media, such as diskettes, CD-ROMs, and USB flash drives. /boot/ — Contains the kernel and other files used during system startup. /lost+foun

How to Turn off (UAC) User Account Control in Windows 2008 (R2)

If you are new to Windows Server 2008, then you are probably wondering why you are getting “Permission Denied” errors when attempting to even open your C drive folder. To help prevent malicious software from silently installing and causing computer-wide infection, Microsoft developed a feature called User Account Control. To get around these errors, you can simply disable the “User Account Control: Run all administrators in Admin Approval Mode” security option. To disable this feature, follow these steps, or simply let us know and we will take care of it for you: Turning off UAC Use the following procedure to disable UAC entirely. To perform the following procedure, you must be able to log on with or provide the credentials of a member of the local Administrators group. Important: Turning off UAC reduces the security of your computer and may expose you to increased risk from malicious software. Microsoft does not recommend leaving UAC disabled. To turn off UAC Click Star