Lab Sql

I found a string tokenizer query on the net and packaged it into the below function, which return t… Read more How To Return A Dynamic Result Set In Oracle Function

I'm trying to create this trigger and getting the following compiler errors: create or replace … Read more Error(2,7): Pls-00428: An Into Clause Is Expected In This Select Statement

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: O… Read more Oracle Ora-00933: Sql Command Not Properly Ended?

I have a sample xml file created using Editplus( in windows). Solution 1: Considering your fir… Read more Xml To Oracle Db Table : Encountering Problems