Amaan

PLSQL Hands on TCS Xplore Solution

Handson-1 Print Customer Details declare id Orders.C_ID%type; i Customers.ID%type; n Customers.Name%type; cn Customers.Contact_No%type; cursor o is select C_ID from Orders where QUANTITY >200; cursor c is select ID, Name, Contact_No from Customers; begin dbms_output.put_line(‘Customer_Id Customer_Name Customer_Phone’);open o; loop    fetch o into id;     exit when o%notfound;     open c;     loop        fetch c into i,n,cn;         exit …

PLSQL Hands on TCS Xplore Solution Read More »

Scroll to Top