Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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; /* */
|Oracle 12c Localhost trying to create a Migration Repo, need help with User creation.||13||26|
|DB migration from Mssql to 12c oracle , data not loading.||3||24|
|ORA-02288: invalid OPEN mode||2||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!