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…
Some important system tables in Oracle: