oracle discoverer reports

Oracle Reports ORA-01691 error, single data file size limit problem 1. Problem: an error occurs when the Oracle database synchronizes a large table from another database. ERROR at line 3: ORA-24801: illegal parameter value in OCI lob function ORA-02063: preceding line from PICLINK ORA-01691: unable to extend lob segment WEBAGENT_PIC.SYS_LOB0000087483C00004 $ by 8

Oracle EBS reports cannot be copied.A long time ago, my colleague mentioned that EBS reports cannot be copied ..You can set the font size in the upper-right corner ..We can solve the problem that cannot be copied. Click "tool" to copy the file.In the pop-up window, select Microsoft Excel and the browser to view the results.Microsoft ExcelYou will be prompted to d

Oracle Database reports a bug. the table or view does not exist. The table name contains spaces. 1. start: the fields in the SQL code exported through powderDesiger are in lower case, and then oracle.2.bug is imported directly: The table structure cannot be modified (in PL/SQL Developer) --- including adding deletion and modification... 3. [html] indicates that t

The DECODE function is Oracle PL/SQL is one of the most powerful functions, and only Oracle SQL provides this function, and the SQL implementations of other database vendors do not yet have this function. What is the use of decode? Let's first construct an example, assuming that we want to raise wages for the smart-star staff, the standard is: wages under 8000 yuan will be added 20%, wages in the 8000 yuan

AWR's data consists of two main components: 1 The system load and performance statistics stored in memory, mainly through the v$ view query; 2 The Mmon process periodically saves in-memory awr data to the Sysaux tablespace in a snapshot (snapshot) manner, mainly through the dba_* view. 1. Generation of AWR snapshots By default, a snapshot is automatically generated every hour, saving information for the last 7 days, and can be queried by the following statement: Sql>select snap_interval,ret

' | | : Inst_num|| ', database ID ' | | :D bid;Dbms_advisor.create_task (' ADDM ', id,name,descr,null);: task_name: = name;Dbms_advisor.set_task_parameter (name, ' Start_snapshot ',: Bid);Dbms_advisor.set_task_parameter (name, ' End_snapshot ',: Eid);Dbms_advisor.set_task_parameter (name, ' INSTANCE ',: inst_num);Dbms_advisor.set_task_parameter (name, ' db_id ',:d Bid);Dbms_advisor.execute_task (name);EndEnd/Spool report_name;Set long 1000000 pagesize 0 longchunksize 1000Column Get_clob format

Label:As far as I know, Apex 4.x does not provide an editable interactive reporting component. This requires our manual implementation. In fact, this is not very complicated, just a few simple steps.1. Create a interactive report according to the wizard. The query statement can be as follows. Select Apex_item.hidden (1,e.id) | | E.name as Staff, Apex_item.select_list_from_lov (p_idx=>2,p_value=>e.department_id,p_lov=> ' lov_department ') as department from employee E;