Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
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;
|Get the parent node - XMLTYPE||9||96|
|SYS password changed. Now can't log in as SYS||27||28|
|join a table with user_tab_columns in oracle||3||46|
|minium over 4 numeric columns for each row in oracle||2||27|