Database Connectivity with Oracle

Driver class: The driver class for the oracle database is oracle.jdbc.driver.OracleDriver. Connection URL: The connection URL for the oracle10G database is jdbc:oracle:thin:@localhost:1521:xe where jdbc is the API, oracle is the database, thin is the driver, localhost is the server name on which oracle is running, we may also use IP address, 1521 is the port number and XE is the Oracle service name. You may get all these information from the tnsnames.ora file. Username: The default username for the oracle database is system. Password: It is the password given by the user at the time of installing the oracle database.

create table emp(id number(10),name varchar2(40),age number(3));