CREATION OF TABLE AND VIEWS

CREATE TABLE

SQL> create table Shope(store_name varchar2(20),sales varchar2(10),Sale_Date date);

Table created.

INSERT

SQL> insert into Shope values('&store_name','&sales','&date');
Enter value for store_name: Chitra Textile
Enter value for sales: $500
Enter value for date: 23-dec-2009
old 1: insert into Shope values('&store_name','&sales','&date')
new 1: insert into Shope values('Chitra Textile','$500','23-dec-2009')

1 row created.

SQL> insert into Shope values('&store_name','&sales','&date');
Enter value for store_name: VVL Medical
Enter value for sales: $250
Enter value for date: 07-jan-1999
old 1: insert into Shope values('&store_name','&sales','&date')
new 1: insert into Shope values('VVL Medical','$250','07-jan-1999')

1 row created.

SQL> insert into Shope values('&store_name','&sales','&date');
Enter value for store_name: Chitra Textile
Enter value for sales: $300
Enter value for date: 08-jan-1999
old 1: insert into Shope values('&store_name','&sales','&date')
new 1: insert into Shope values('Chitra Textile','$300','08-jan-1999')

1 row created.

SQL> insert into Shope values('&store_name','&sales','&date');
Enter value for store_name: VP Store
Enter value for sales: &700
Enter value for date: 08-jan-1999
old 1: insert into Shope values('&store_name','&sales','&date')
new 1: insert into Shope values('VP Store ','&700','08-jan-1999')

1 row created.

SQL> select * from Shope;

STORE_NAME SALES SALE_DATE
-------------------- ---------- -----------------
Chitra Textile $500 23-DEC-09
VVL Medical $250 07-JAN-99
Chitra Textile $300 08-JAN-99
VP Store $700 08-JAN-99


VIEW

SQL> create view V_Shope as select store_name,sales from Shope;

View created.

SQL> select * from V_Shope;

STORE_NAME SALES
-------------------- ----------
Chitra Textile $1500
VVL Medical $250