Friday, May 14, 2021

DBMS_DESCRIBE in Oracle

DBMS_DESCRIBE: DBMS_DESCRIBE is the Oracle-supplied package to obtain information about a PL/SQL object. The package contains the DESCRIBE_PROCEDURE procedure, which provides a brief description of a PL/SQL stored procedure. It takes the name of a stored procedure and returns information about each parameter of that procedure.

1 comment:

  1. Optumflex Solutions for your ERP business needs. Visit Optumflex.com for more information.

    ReplyDelete

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...