Oracle PL/SQL: Count Objects - This script: Echoes how many objects will be dropped by type. Type "enter" to continue or "CTRL+C"

Quick Search:

Oracle PL/SQL: Count Objects

Jump to:

Category: >> Oracle PL/SQL >> Count Objects

<< last

next >>

Snippet Name: Count Objects

Description: This script: Echoes how many objects will be dropped by type. Type "enter" to continue or "CTRL+C" to abort the
script. This script produces a text file mydel.sql which is
deleted (OS dependent) at the end.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

SELECT object_type, COUNT(object_type) "Count" FROM obj
GROUP BY object_type