Hello,
I have a XML file inserted in a CLOB. When the XML content is too low, I have a <value error>. I can't perform a Select on the column...
On the application side, I can fetch this line ...
http://www.experts-exchange.com/Database/Oracle/Q_23049835.html
I have a stored procedure which inserts records into a table and then needs to insert and/or update records in the table. I am assuming that I need a if-then-else clause or a loop of some sort, bu...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23562861.html
Hi,
I have PL/SQL DEVELOPER version 7.1.5
but am looking at a tutorial for 2.0 I guess.
http://www.oracle.com/technology/products/database/sql_developer/index.html
Is there any tutorials for ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23886581.html
I'm trying to write an Oracle stored procedure to return multiple rows. The catch is the stored procedure needs to be exposed as a web service and match a pre-defined WSDL. I'm using Jdeveloper to ...
http://www.experts-exchange.com/Database/Oracle/Q_23122848.html
Hey Experts,
I need to code uses nested xmlagg functions to nest my xml output of an xmltype view query I wrote in PL/SQL. The XMLAGG function should start at the (XMLELEMENT("document",)) line ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/XML/Q_23449055.htm...
I have been using TextPad to put together SQL statements by using the cut, copy and pasting of BLOCKS of text.
Example:
I copy the describe of a table, replace varchar, number, date will 10 space...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23865784.html
