DECLARE
v_column VARCHAR2 (20);
v_value VARCHAR2 (20);
CURSOR c_columns
IS
SELECT Column_Name_To_Count
FROM Table_Name
WHERE Condition
ORDER BY ROWNUM;
TYPE column_rec IS RECORD (column_name VARCHAR2 (30));
TYPE columns_table IS TABLE OF column_rec;
t_columns columns_table;
BEGIN
OPEN c_columns;
FETCH c_columns
BULK COLLECT INTO t_columns;
CLOSE c_columns;
HTP.p ('<br/>');
HTP.p ('<table><tbody>');
FOR i IN 1 .. t_columns.COUNT
LOOP
HTP.p ('<tr>');
HTP.p (
'<td><label for="P42_C'
|| LPAD (i, 3, 0)
|| '" id="P42_C'
|| LPAD (i, 3, 0)
|| '_LABEL">'
|| t_columns (i).column_name
|| ' :           '
|| '</label></td>');
HTP.p (
'<td>'
|| APEX_ITEM.TEXT (1, p_item_id => 'P42_C' || LPAD (i, 3, 0))
|| '</td>');
HTP.p ('</tr>');
END LOOP;
HTP.p ('</tbody></table>');
EXCEPTION
WHEN OTHERS
THEN
IF c_columns%ISOPEN
THEN
CLOSE c_columns;
END IF;
END;
Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Subscribe to:
Post Comments (Atom)
Search String Inside Oracle Database Objects SQL
SELECT owner, name, type, line, text FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;
-
1. Make a Region with PL/SQL Dynamic Content type . ========== 2. Assign ID to the region using HTP.p ( <span id="TEST_ID...
-
Create Excel File From Classic Report in Oracle Apex Using Java Script 1. Upload File Download File 2. Copy Pest the Code <!DO...
No comments:
Post a Comment