ユーザー定義型のオブジェクト検索

  • デル株式会社

    • SELECT OBJECT_NAME FROM user_objects WHERE UPPER(OBJECT_TYPE) = ‘TABLE’;

    SELECT OBJECT_NAME FROM user_objects WHERE UPPER(OBJECT_TYPE) = ‘PACKAGE’;

    SELECT OBJECT_NAME FROM user_objects WHERE UPPER(OBJECT_TYPE) = ‘PACKAGE BODY’;

    SELECT OBJECT_NAME FROM user_objects WHERE UPPER(OBJECT_TYPE) = ‘VIEW’;

    SELECT OBJECT_NAME FROM user_objects WHERE UPPER(OBJECT_TYPE) = ‘INDEX’;

    関連記事

    トップページに戻る

    ページ上部へ戻る