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 hereDownload and playout with this data : downloadCorrect me...

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 - oracle3) Try executing xeyes again if error pops up something like this :    Xlib: connection to ":0.0" refused by server    Xlib:...

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 xyzto Add Rows in Dual table connect to sysdba1) conn / as sysdba2) 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 tableasdelete from dual where dummy='Z'Thats it! Now you can drop any table you want...