We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SET SERVEROUTPUT ON;
BEGIN
FOR r in (SELECT name FROM CITY WHERE POPULATION>120000 AND COUNTRYCODE ='USA')
LOOP
DBMS_OUTPUT.PUT_LINE(r.name);
END LOOP;
END;
/
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Revising the Select Query II
You are viewing a single comment's thread. Return to all comments →
ORACLE PL/SQL:
SET SERVEROUTPUT ON; BEGIN FOR r in (SELECT name FROM CITY WHERE POPULATION>120000 AND COUNTRYCODE ='USA') LOOP DBMS_OUTPUT.PUT_LINE(r.name); END LOOP; END; /