I am trying to create a stored Procedure in Oracle that has a cursor so I can loop through the records and update. I seem to be compiling with errors. Not sure if I am doing this correct. once the ...
http://www.experts-exchange.com/Database/Oracle/Q_23428034.html
I have written a stored procedure code is attached in the code snippet.
It is giving me error at the rename statement.
PLS-00103: Encountered the symbol "TBLNAME" when expecting one of the follow...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23584636.html
Zones:
Oracle 9.xDate Answered: 07/30/2008 Grade: B Views: 9
Scenario:
I have faced following problem while migrating from SQLServer2000 to Oracle Migration.
I had migrated one table example:tblAttendanceSummary.
when I fire a select statement for the abo...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23572528.html
Zones:
Oracle 9.xDate Answered: 09/25/2008 Grade: A Views: 0
I have to import some views,functions and stored procedure existing in SQL server 2000 to Oracle9.0.
Can i use import function to do it.If i can use it give me a example of code how i can do it w...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23584265.html
Zones:
Oracle 9.xDate Answered: 08/29/2008 Grade: A Views: 0
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...
