|
|
[ÀϹÝ] [sql]Æã¼ÇÀ̳ª ÇÁ·Î½ÃÁ® ÆÑÅ°Áö °°Àº ¸ñ·Ï º¸±â |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 220.¢½.198.135 |
ÀÐÀ½:4124 |
|
|
Æã¼ÇÀ̳ª ÇÁ·Î½ÃÁ® ÆÑÅ°Áö °°Àº ¸ñ·Ï º¸´Â Äõ¸®
-- Function
SELECT *
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'FUNCTION'
-- Procedure
SELECT *
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
-- Package
SELECT *
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE'
-- Package Body
SELECT *
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE BODY'
|
|
|
|