Birlasoft Interview Question

How to write subqueries in PL/SQL

Interview Answer

Anonymous

Aug 6, 2011

Declare lv_columnA1 tableA.ColumnA1%TYPE; begin Select ColumnA1 Into lv_columnA1 from tablea Where ColumnA in (select columB from Table B); End; /