Yes. Oracle Database XE is free for fall and supports a database of 12GB. Its is easy to install and hassle free experience.
Oracle Database XE can be download from: https://www.oracle.com/in/database/technologies/appdev/xe.html
During setup you are required to enter few admin passwords. Ensure you remember them. These are required to interact with the database at a later point of time.
Now once you have installed the Oracle XE database how to query data or load data?
For this you need a front end application. In this case you can use Oracle SQL developer which can be download from this link depending the you machine's architecture: https://www.oracle.com/tools/downloads/sqldev-downloads.html
Once you have installed SQL developer. Add a connection using the top left green plus button. Below screen will appear. Name the connection as you require. in the ROLE adjacent to username box choose SYSDBA.
Enter Username as "SYS" and the password you have configured during setup of XE. Hostname, port and SID should be entered as per below and you should be connected to your XE database
No comments:
Post a Comment