Here is how to install APEX 4.2 on Oracle 11g:Download Apex 4.0.2:http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.htmlin C:\apps\ApexDownload Apex Listener:http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.htmlin C:\apps\Apex_ListenerMake a shortcut to SQL Plus 11:C:\Oracle\product\11.2.0\dbhome_1\BIN\sqlplus.exe /nolognamed: Apex SQL Plus 11 wirh working directory…
If you have the following message:ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'Then the undo tablespace is possibly corrupted.Try the following:create undo tablespace UNDOTBS2 datafile 'c:\app\vag\oradata\ora11g\UNDOTBS02.DBF' size 100000;alter…
Please see:Java-PL/SQL: Read from SYS_REFCURSOR
Here is a piece of java code, which fetches data from SYS_REFCURSOR, using the OracleTypes.CURSOR argument type:import java.sql.*;import java.util.Date;import oracle.jdbc.OracleTypes;public class ListCountries { static Driver driver; static Connection conn =…
With pipeline functions we can "select" from a function as if it was a table, by fetching results as soon as they are prepared by the function, without waiting all…
Some common errors, which can be corrected in php.ini:- Error:Notice: Undefined index: PHP_SELFSolution:register_globals = On- Error:Web page displays part of php codeSolution:short_open_tag = On- Error:Errors are displayed on production environmentSolution:display_errors…
Using XML transformation in a cursor in Oracle PL/SQL, we can fetch just one column of the recordset returned back by a SYS_REFCURSOR:declare the_sys_refcursor sys_Refcursor; P_Return_Set_O sys_Refcursor; p_column_name …
BI Publisher:http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bip/bip11g/gettingstarted11116/gs.htmeTRM:http://etrm.oracle.com
Hierarchical Queries:http://docs.oracle.com/cd/B12037_01/server.101/b10759/queries003.htmAltering Tablespaces:http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces007.htm
In the hierarchical queries, we can depict the parent-child relationship, which exists in a table.In the following example we have a table with hierarchy of regions.We will try to find…