Thursday, 27 November 2014

Script: db_properties.sql

 -- -----------------------------------------------------------------------------------
        -- Author       : Pavan Yennampelli
    -- Description  : Displays all database property values.
    -- Call Syntax  : @db_properties
    -- -----------------------------------------------------------------------------------
    COLUMN property_value FORMAT A50

    SELECT property_name,
           property_value
    FROM   database_properties
    ORDER BY property_name;
Powered by Blogger.