SPOOL create_ar.log;


BEGIN  
  EXECUTE IMMEDIATE 'DROP USER ar CASCADE';
EXCEPTION
  WHEN OTHERS THEN
    NULL;
END;

GRANT ALL PRIVILEGES TO ar;


CREATE TABLE customers
(
  customer_id             NUMBER          NOT NULL,
  customer_first_name     VARCHAR2(50)    NOT NULL,
  customer_last_name      VARCHAR2(50)    NOT NULL,
  CONSTRAINT customers_pk 
    PRIMARY KEY (customer_id)
);
INSERT INTO customers VALUES (1, 'Jack', 'Samson');
INSERT INTO customers VALUES (2, 'Joan', 'Redding');
INSERT INTO customers VALUES (3, 'Jim', 'Abbot');

SPOOL OFF;

PROMPT Check create_ar.log for details...
PROMPT 

EXIT;