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

  • マウスコンピューター/G-Tune
  • 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’;

  • 楽天トラベル
  • 関連記事

    ページ上部へ戻る