INFO-TECH

This is really nice thing we can do it in oracle , recently i encountered a situation where data came from XML File and need to load it in Table in oracle 10g , This was a good opportunity to learn this stuff ,

Here i have written a simple tutorial for beginners , how to load XML file data in Oracle 10g , there are others ways to do these things but this is good method to understand it for beginners like us!

You can download Tutorial from here

Download and playout with this data : download

Correct me if am wrong somewhere ,
You can always post your views and suggestions here on this blog ,

Thank You,

Have a nice day ,

drop table xyz;

ORACLE SAYS : exact fetch returns more than requested number of rows ? ? ? how come . . .

yea, once i was playing with dual table and i inserted new row in a dual table which is why i can't drop this table xyz

to Add Rows in Dual table connect to sysdba

1) conn / as sysdba
2) insert into dual values('Z');


Now if you try to drop any table you will get above error to solve it just delete one row from dual table
as

delete from dual where dummy='Z'

Thats it! Now you can drop any table you want without any errors!
Thank You!