2011-03-25から1日間の記事一覧
SELECT object_name, object_type FROM user_objects WHERE object_type = 'PROCEDURE' OR object_type = 'FUNCTION' OR object_type = 'PACKAGE' OR object_type = 'LIBRARY' ORDER BY object_type, object_name ;object_typeで指定するスキーマの種類とか…
SELECT object_name, object_type FROM user_objects WHERE object_type = 'PROCEDURE' OR object_type = 'FUNCTION' OR object_type = 'PACKAGE' OR object_type = 'LIBRARY' ORDER BY object_type, object_name ;object_typeで指定するスキーマの種類とか…