Hi friends ....
Again I am come back with some interesting tips and tricks
Now i am going to tell you that how to change the database without rewriting the queries or
recreating the table
Let's see
You know XML is the way to make this possible
"Suppose I have a table named as Login in oracle 10g express edition and i want to change it into the MS Access Database ".
Here is a steps
Firstly you have to log on yo the database and i assume that you already know so skip the step to log on to the oracle 10g XE
After you log on to oracle 10g XE
this screen is shown
now navigate to this path
Home>Utilities>Data Load/Unload>Unload>Unload to XML
and then this window will shown to you
this option is shown to you
Select your schema ->next
Select your table->next (Here i chose Login table)
and then Select Columns in this way
Press Unload Data and now save this XML file.
Now Open MS Access and create a blank database
After that goto External Data option and select XML File.
Now select the path of you XML File.
Now Press Ok
then press close and your table will be created with name ROW
and also your data will also be inserted into the database.
and if you want to rename the table ROW with whatever name you want
Again I am come back with some interesting tips and tricks
Now i am going to tell you that how to change the database without rewriting the queries or
recreating the table
Let's see
You know XML is the way to make this possible
"Suppose I have a table named as Login in oracle 10g express edition and i want to change it into the MS Access Database ".
Here is a steps
Firstly you have to log on yo the database and i assume that you already know so skip the step to log on to the oracle 10g XE
After you log on to oracle 10g XE
this screen is shown
now navigate to this path
Home>Utilities>Data Load/Unload>Unload>Unload to XML
and then this window will shown to you
this option is shown to you
Select your schema ->next
Select your table->next (Here i chose Login table)
and then Select Columns in this way
Press Unload Data and now save this XML file.
Now Open MS Access and create a blank database
After that goto External Data option and select XML File.
Now select the path of you XML File.
Now Press Ok
then press close and your table will be created with name ROW
and also your data will also be inserted into the database.
and if you want to rename the table ROW with whatever name you want
No comments:
Post a Comment