Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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; /* */
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.