Unique key enforces only uniqueness (no duplicate) where as a Primary key enforces both uniqueness and not null (data must be entered into the field). Once a PK is created on a column oracle creates...

Try the following link (http://www.oracle.com/pls/db102/homepage) and select SQL Reference

You need to use the function RUN_REPORT_OBJECT


DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
repid := find_report_object('report4');
v_rep :=...

For that you need to use a staging table and update the master table based upon data in the look up table.

You need to handle the code in a PL/SQL block.

at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp

You need to use BETWEEN clause .

in sql *plus type HOST

in the command prompt type

exp username/password@databasename

then just follow the instructions as prompted

It is better to start a different thread for a new question.

anyways try to use this sample query


DELETE FROM emp e WHERE rowid>(SELECT MIN(ROWID) FROM emp WHERE e.empno=empno)

You can't convert directly. But you can upload data of access into oracle.
You can export the data of access into a .CSV file and from oralce use the SQL LOADER to load the same data to oracle...