SQL First Query

SQL First Query

Before you start your first sql query, need to install any database software, here i will use oracle 10g. If you have no any database just download and install.

Note: At the time of installation give user name system and password: system.

Steps to get start with SQL

• Run SQL
• First connect with database.
• For connect with database type: connect system and type password system
• Now you can create table.

Create table

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

CREATE TABLE Employee
(
emp_id number(5),
name varchar(20),
salary number(10)
);

Employee table