Re: MSSQL / Oracle metaphor

<medrano_at_my-deja.com> wrote in message news:7u7jck$o2f$1_at_nnrp1.deja.com...
> I'm trying to figure out what is the equivalent of the MSSQL7.0 stored
> procedure, sp_configure and sp_help, is in Oracle. More specifically,
> I'm trying to user SQL+ in Oracle to obtain similar data returned by
> those MSSQL stored procedures.
>
> Please include any responses to medranom_at_hotmail.com

using sp_configure to see system parameter is like

    select * from v$parameter;

using sp_configure to change system parameter is like

    alter system

using sp_help is like

    describe (in SQL*Plus) or

    select * from all_tables;
    select * from all_tab_columns;
    select * from all_segments;
    select * from all_indexes;
    select * from all_constraints;