Quick Search:
 Oracle PL/SQL: Count Objects Jump to:  
Category: >> Oracle PL/SQL >> Count Objects  

<< lastnext >>

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

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org