Ord_ID VARCHAR2(10) CONSTRAINT ORDER_PHARMACY_Ord_ID_pk PRIMARY KEY, CONSTRAINT Ord_ID_nn NOT NULL,

Ord_ID VARCHAR2(10) CONSTRAINT ORDER_PHARMACY_Ord_ID_pk PRIMARY KEY CONSTRAINT Ord_ID_nn NOT NULL,

select min(dat)
from
   ( select min(<date_col_in_tbl_1>) dat from <tbl_1>
     union
     select min(<date_col_in_tbl_2>) dat from <tbl_2>
     union
     select min(<date_col_in_tbl_3>) dat from <tbl_3>
   )
;

startup nomount;
create pfile from spfile;

The database services are currently running

and the error is ...

set feedback off

select * 
from   (
         <your_select_statement>
         ORDER BY <your_criteria> DESC
       )
WHERE  rownum < <num_of_required_records> + 1;

select value from from v$nls_parameters where parameter='NLS_CHARACTERSET';

SELECT COUNT(*) 
FROM   AUTO_SH_LOAD 
WHERE  TRUNC(LOADDATE)  =  TRUNC(SYSDATE) - 1 
AND    FILEGROUP       IN  ( 'CHPYMT','CHP2P' ,'CHREFL','CHSTAT'
                            ,'CHADJ' ,'CHCLCR','CHSFEE')
;

select count(*)
from
  (

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by PLUS10, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion). importing PLUS10's objects into SYSTEM
Import terminated successfully without warnings.

set autotrace on
SELECT * 
  FROM DR_CONTRIBUTION_DN dn 
 WHERE NOT EXISTS ( 
          SELECT * 
            FROM DR_CONTRIBUTION_PS ps 
           WHERE (dn.ID = ps.ri_donor_id 
                  AND dn.idtype = ps.ri_donor_type 
                  AND dn.giftseqnum