What Is The Order Of The Jemes On Poptriopica N

Scanner (Oracle sqlDeveloper) gwt

Hi

In this entry I would like to share the little that PL SQL, that from the hot day I learn, teach the use of Array or arrangements as temporary tables are created when executing the SQL PL.
------------------------------------


------------ DECLARE TYPE IS TABLE OF NUMBER array_enteros;
array_enteros Un_array := array_enteros (10102, 10127, 10122, 10104, 10105 ,10106, 10107 ,10108 , 10109 ,10114 ,10110, 10124 ,10125 ,10112 ,10113, 10116 , 10123 ,10115 , 10117 , 10118 ,10119 , 10121 ,10120 , 10128, 10129, 10130);

BEGIN

FOR i IN Un_array.FIRST..Un_array.LAST
LOOP
dbms_output.put_line('elemento '

To display the data in SQL Developer has to do the following: Select

PL SQL code in the editor.





to display data then do the following: In the tabs below are several options we're going out that says DBMS output, then activate the DBMS output as shown in the picture.





then run the SQL block and go back wing DBMS Output tab, and our data is already in the output.