TECHONESPOT

All Tech at one spot

How to Create table
and Insert data in Oracle 10g.

Step1 :- Press window and search for oracle folder

Step 2 :- Then Click on go to databse homepage

Step 3 :- Enter username and password.

Step-4 :- Then click on the SQL

Step-5 :- Then click on the SQL Commands.

Step 6 - Then type the DDL Statement like Create table.

Create table Query

create table employee
(
e_id int,
e_name varchar2(50),
e_add varchar2(100),
e_email varchar2(100),
e_con varchar2(10),
e_dob date,
e_sal number(7,2));

Step 7:- How to see the Structure of your Table

Desc employee 

Step 8:- Then type the DML Statement like Insert Statement

insert into employee values(1,’Mohan’,’Althan’,’mohan123@gamil.com’,’5566332211′,’10-jan-1995′,45000);

insert into employee (e_id,e_name,e_add,e_email,e_dob,e_sal)values(2,’Hardik’,’Vesu’,’hardik123@gmail.com’,’09-sep-1995′,50000);

Step 9:- How to display the full table.

Select * from employee;

Fun & Easy to follow
Works on all devices
Your own Pace
Super Affordable