PLSQL Collection

PLSQL COLLECTION PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or Varray TYPE …

PLSQL Collection

PLSQL COLLECTION PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or Varray TYPE …

Interactive GRID | Windows List View Style - Checkbox visible on hover

Interactive GRID Appearance CSS Classes - ig-windows-style Page Inline CSS .ig-windows-style .a-GV-table .a-GV-cell, .ig-windows-style .a-GV-table .a-GV-controlBreakHeader { border-color: transparent; } .ig-windows-style .a-GV-w-frozen .a-GV-table { border-right: none; } .ig-windows-style .a-GV-table tr.is-hover …

Display Image from Directory in ORACLE APEX

Display Image from Directory in ORACLE APEX. One of my colleague had asked to me, How can i display image in Interactive/Classic Report or Interactive Grid from Directory without storing image in table. I got a solution and going to share that how i can achieve in ORACE APEX. STEP 1 : CREATE TABLE USING BELOW QUERY. …