The question is relevant to peoplesoft No Plagiarism In SQR

The question is relevant to peoplesoft:

No Plagiarism!!!!

(In SQR)

Assume a Select query is defined in a local procedure. Can we access all selected columns in other procedures?

Solution

No, when a query is defined in a local procedure, all selected column names are considered as local and can\'t be used in any other procedures.