SELECT *
FROM "Schema Name"."View Name"
( 'PLACEHOLDER' = ('$$InputParam1$$', '<Enter Value1>')
, 'PLACEHOLDER' = ('$$InputParam2$$', '<Enter Value2>')
, ...n
)
SELECT *
FROM "Schema Name"."View Name"
( 'PLACEHOLDER' = ('$$InputParam1$$', '<Enter Value1>')
, 'PLACEHOLDER' = ('$$InputParam2$$', '<Enter Value2>')
, ...n
)
"SYS"."PROCEDURE_PARAMETERS"
- data_type_id > 0
- PROCEDURE_NAME
1. View
- "SYS"."VIEWS" & "SYS"."VIEW_COLUMNS"
- SCHEMA_NAME
- VIEW_NAME
2. Table
- "SYS"."TABLES" & "SYS"."TABLE_COLUMNS"
- SCHEMA_NAME
- TABLE_NAME