Select count(*) if count > 1 delete else insert.

Procedure InsertDeleteOperators_Operations

I need to do a

select (*)

if count > 1
{
do a delete
}
else
{
do an insert
}

Merge the two below to form the above.
--------------------------------------------------------------

PROCEDURE InsertOperators_Operations
(
                 pcCompanyID   IN OPERATORS_OPERATIONS.COMPANY_ID%TYPE,
               pcPlantID         IN OPERATORS_OPERATIONS.PLANT_ID%TYPE,
              pcOperationID IN OPERATORS_OPERATIONS.OPERATION_ID%TYPE,
                 pcOperatorID  IN OPERATORS_OPERATIONS.OPERATOR_ID%TYPE,
             pcCreationUser IN OPERATORS_OPERATIONS.CREATION_USER%TYPE,
             pcCreationDate IN OPERATORS_OPERATIONS.CREATION_DATE%TYPE
)

IS

BEGIN

INSERT INTO Operators_Operations
(
           COMPANY_ID,
             PLANT_ID,
             OPERATION_ID,
             OPERATOR_ID,
             CREATION_USER,
             CREATION_DATE
)
VALUES
(
         pcCompanyID,
               pcPlantID,
              pcOperationID,
         pcOperatorID,
             pcCreationUser,
             pcCreationDate

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN
     ROLLBACK;
     DBMS_OUTPUT.PUT_LINE(SQLERRM);

END InsertOperators_Operations;
---------------------------------------------------------------
PROCEDURE DELETEOPERATOR_OPERATIONS
(
  pcCompanyID   IN OPERATORS_OPERATIONS.COMPANY_ID%TYPE,
  pcPlantID          IN OPERATORS_OPERATIONS.PLANT_ID%TYPE,
  pcOperationID IN OPERATORS_OPERATIONS.OPERATION_ID%TYPE,
  pcOperatorID  IN OPERATORS_OPERATIONS.OPERATOR_ID%TYPE
  )
IS
BEGIN
  DELETE OPERATORS_OPERATIONS
  WHERE COMPANY_ID = pcCompanyID  
    AND PLANT_ID = pcPlantID
    AND OPERATION_ID = pcOperationID
    AND OPERATOR_ID = pcOperatorID  
  ;
END DELETEOPERATOR_OPERATIONS;
--------------------------------------------------------------Start Free Trial