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…
Some important system tables in Oracle:
The program below reads xml files from specific directory, extracts a value out of each one of them using XPath expression, puts the value side by side with a substring…
Here is an example of how to automatically increase the log level of a Siebel Component (in this example where SRBroker is used, restart of the component is needed).Create the…