Software overview:
Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint
database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy,
and distribute; fast to download; and simple to administer.
If you need a GUI for Oracle Database, you can download - NAVICAT (Oracle GUI). It supports
to import MS SQL, MySQL, MS Access, Excel, CSV, XML, or other formats to Oracle.
Oracle Database XE is a great starter database for: Developers working on PHP, Java, .NET, XML,
and Open Source applications; DBAs who need a free, starter database for training and deployment;
Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute
free of charge; Educational institutions and students who need a free database for their curriculum With
Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-
leading infrastructure, and then upgrade when necessary without costly and complex migrations.
Installing instructions:
1. Download and extract the given file.
Download oracle 10g express below:
2. Follow on screen instructions untill you get a window asking to enter and confirm password.
3. Choose a password and enter into it. Do not forget this password because this is useful in future.
4. Wait untill the installation finishes.
5. Then run "sql command line" in the start menu or search the string in search bar.
6. This is similar to command prompt but difference is instead of c:> it contains SQL>.
7. In the window type the following command.
connect system
That's all it connects to a local server and you can practice all sql commands.
For latest version goto here.
But i prefer this version for practice.
0 comments:
Post a Comment