Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
create or replace PROCEDURE COUNTER AS TYPE v_array is varray(100000) of NUMBER(38,8); temp_array V_ARRAY; CURSOR nwr is SELECT x_coord from GRID_FLORIDA g,f_region r where r.region_id = 'R108' and sdo_relate(g.geom, r.geom,'mask=ANYINTERACT querytype=WINDOW') = 'TRUE'; begin open nwr; fetch nwr bulk collect into temp_array; Dbms_output.PUT_LINE(temp_array.count); close nwr; END COUNTER;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Select and Insert Query running slow||4||58|
|Assistance required for troubleshooting an issue - ORA-12154: TNS error - MS SQL Server 2008||3||57|
|Oracle database T-1 Setup||7||28|