With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.
create or replace PROCEDURE ALL_TBLES_PRC /* NAME: TBLES DESCRIPTION: -- This is to select ALL data from Project tables. Parameters will be the TABLE NAME and PUB_ID */ ( PARAM_0 IN NUMBER, --USER PARAM_SYSFLAG IN NUMBER, --NUMBER PARAM_1 IN VARCHAR2, -- TABLE NAME PARAM_2 IN NUMBER, -- PUB ID P_RECORDSET OUT SYS_REFCURSOR ) AS BEGIN OPEN P_RECORDSET FOR SELECT * FROM 'AAD.'|| PARAM_1 WHERE ID = PARAM_2; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; END ALL_TBLES_PRC; /* */
Join the community of 500,000 technology professionals and ask your questions.