Load and extract XML File data in Oracle

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 ,

Oracle Installation Problem : X11 problem

Most probably you will see this line in your error " X11 window server using '192.168.1.2:0.0' as the value of the DISPLAY variable "


This clearly says that problem is related to X11 . . .




Steps :
---------
1) Try executing xeyes as root and check wheather it shows or not . . 
2) now login as your oracle account as ,

    su - oracle


3) Try executing xeyes again if error pops up something like this :


    Xlib: connection to ":0.0" refused by server
    Xlib: No protocol specified
    Error: Can't open display: :0.0

4) Go ahed by firing :  xterm and you will see TERMINAL OPENED 
5) thats it now you can fire xeyes from that terminal 
6) run your oracle installer as  ./runInstaller

Thats It !


can't drop table

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!