How to create table view table in Oracle?


Create table Employee (
Fname varchar(20),
Emp_ID number(10),
Dept_ID number(10),
Salary number(10),
Location_ID varchar2(10),
manager_ID number(8),
ph_no number(10),
City varchar(10),
Country varchar(10)
);

desc employee;

Insert into Employee values ('1', 'Anmol','123456','2','5000','Nepal','12','9847368065','Ktm', 'Nepal');

select * from Employee;

select fname, salary from Employee;


No comments:

Post a Comment