Wednesday 7 August 2013

How to start Oracle10g

How to start Oracle10g?
steps:

start->programs->Oracle Database 10g Express Edition -> Run SQL command


  • It opens a window at DOS prompt where SQL> prompt appears. 
  • type connect and, it asks to enter user-name and password.



What is Database?

What is Database?
A Database is a repository of data. We can store data permanently in a database and retrieve it later whenever needed by using query commands.

List of Databases:
  1. Oracle
  2. Sybase
  3. MySQL
  4. SQL Server, and so..on


  • Data is stored in the form of tables in the database.
  • to get the data from the tables and handover to the users, we have to write programs. This programs are known as 'database client' program.
Database servers