| sm_ahmeds |
Posted: Aug 21, 2007 02:55:38 PM |
Total Post: 53
Joined: Apr, 2007
|
please tell me abt the following issues:
1) HOW TO MIGRATE AN MICROSOFT ACCESS DATABASE (.mdf file) TO AN ORACLE DATABASE.(PLEASE EXPLAIN STEP WISE)
2) HOW TO CONNECT A SMALL WINDOWS BASED APPLICATION WITH THE ORACLE 10G DATABASE(RUNNING ON WINDOWS). DO I NEED TO INSTALL ANY ORACLE SOFTWARE AT THE CLIENT SIDE ?
3) HOW TO MODIFY THE TABLES (ADD OR REMOVE A COLUMN AND ENTER VALUES DIRECTLY) IN ORACLE 10G LIKE WE DO IN MICROSFT ACCESS OR SQL SERVER.
PLEASE URGENT REPLY NEEDED
TAHNKS
|
|
|
 Mohammed Taj |
| Posted: Aug 22, 2007 12:34:36 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Nothing is urgent...
please go first oracle documentation ...
http://tahiti.oracle.com
Regards
Taj
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 22, 2007 01:04:33 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
There is no much change in insert statements. For adding a column use Alter table table_name add column column_name, for dropping column use Alter table table_name drop column Column_name
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 22, 2007 01:07:15 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
Database installation is required or not depends on what is your application. if it is stand alone application then you have to have database in that system, else u can have database in one server where database can be installed and all cleints can access data from there.
|
|
|
|
|
| sm_ahmeds |
| Posted: Aug 22, 2007 02:06:26 AM | |
|
Total Post: 53
Joined: Apr, 2007
|
THANKS FOR REPLY PLEASE TELL ME HOW TO CONNECT A STAND ALONE APPLICATION WITH AN ORACLE DATABASE STEP WISE THANKS
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
