Friday, August 2, 2019

How to display the column count ?

SELECT
            TABLE_NAME, COUNT(*)
   FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'EMP'
GROUP BY TABLE_NAME
ORDER BY TABLE_NAME

No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...