SQL First Query


Prev Tutorial Next Tutorial

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. Below are the link for download Oracle 10g it have only 150mb size.

Oracle 10g

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

Syntax

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

Example

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

Employee table

emp_idnamesalary
   

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements