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!

Servlet Simple Tutorial

Today 31st August , from many days i was not paying much attention towards Servlet technology as i used to hate it , coz of its compilation and execution but finally today me and my sir was just trying to solve some problems related to this servlet and finally decided to write simple tutorial about executing servlet application!

Creating and executing a servlet is not at all a difficult task once you understand it !

View My Tutorial here

I hope you will get to know about compilation and execution of servlet from this little handy tutorial!
Let me know if am wrong somewhere ,

Thank You ,
Have a pleasant stay!

List of Operating Systems

Here is the list of operating systems . . . check it out  . .

Click Here 

Thank  You,

10g say's Database not open . . .tackle ORA-01219

SQL> startup mount

ORACLE instance started.

Total System Global Area  126951228 bytes

Fixed Size                            454460 bytes

Variable Size                       109051904 bytes

Database Buffers               16777216 bytes

Redo Buffers                      667648 bytes

Database mounted.

SQL> select * from dba_users;

select * from dba_users

              *

ERROR at line 1:

ORA-01219: database not open: queries allowed on fixed tables/views only

Now what ? ? ? ? ? ? ?

To check the Database mode :

1) fire up : select open_mode from v$database

2) If its mounted then you need to fire up : alter database open

3) Thats it now you can fire any query you want . . . .

Enjoy 10g ,

Thank You

Reference

M.C.A (Pune University)

Dedicated to all M.C.A's of Pune University

1. M.C.A. Syllabus Download

Will soon upload M.C.A study guide here on site.

Keep visiting,

Thank You,

: Girish . . .