Execute immediate statement to create table

 DECLARE
    vCNT   NUMBER;
BEGIN
    SELECT COUNT (*)
      INTO vCNT
      FROM USER_TABLES
     WHERE UPPER (TABLE_NAME) = UPPER ('table_01');

    IF vCNT > 0

    THEN

        EXECUTE IMMEDIATE 'DROP table table_01 CASCADE CONSTRAINT';
        EXECUTE IMMEDIATE 'create table table_01 as
                            SELECT *
                              FROM table_name
                             WHERE column= ' || :value;
    ELSE
        EXECUTE IMMEDIATE 'create table table_01 as
                           SELECT *
                              FROM table_name
                             WHERE column= ' || :value;
    END IF;
END;