Installing Oracle Database XE in Linux

To install Oracle Database XE: 1. Log on to your computer with root permissions. 2. Go to the following Web site: http://www.oracle.com/technetwork/database/express-edition/downloads/index.html 3. Accept License Agreement and download the Linux version of Oracle Database XE. 4. Run the Oracle Database XE executable oracle-xe-11.2.0-1.0.x86_64.rpm to install Oracle Database XE using the command – # rpm -ivh […]

Continue reading →

Using Database Link in Oracle

Suppose data from a table X in database D is to be copied into table Y in the same database, then the problem can be solved easily by executing the query – Assumption – X(C(1),C(2),C(3)….C(N)) == Y(C(1),C(2),C(3)….C(N)) where C(1),C(2),etc. denote the columns of the table. INSERT INTO Y SELECT * FROM X; COMMIT; Problem – […]

Continue reading →