For Loop sample

begin
FOR i IN 1..20 LOOP
insert into test values(i,'empresa'to_char(i));
END LOOP;
end;

commit;

Oracle and BI studies

Database:
-Oracle database
-Oracle OLAP option

ETL:
-Oracle Warehouse Builder
-Oracle Data Integrator

Reports:
Oracle Discoverer (Administrator, Desktop, Portlet Provider, Viewer, Plus and Plus Olap)
Oracle Reports (Builder and Services)
Oracle Spreadsheet Add-in
Oracle BI Beans


Oracle Data Miner
Macro Oracle Predictive Analytics


OracleBI
-Oracle HTTP Server
-Oracle Containers for J2EE
-Oracle Web Cache
-Oracle Report Services
-Oracle Discoverer

FRench:ENglish
jauges= gauges

*ver Excel data crosstab report.