Notes

Cmd-1
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:UsersLAB7>SQLPlus
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 172.18.2.2
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Login to user sysdba:
Enter user-name: cs171094
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Creating new user p1 with default and temporary tablespace:
SQL> create user p1 identified by p1 default tablespace user’stemporary tablespace temp quota unlimited on users;
User created.
Permission grant to user p1:
SQL> grant create session to p1;
Grant succeeded.

CMD-2
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:UsersTCSExam>sqlplus p1/p1
SQL*Plus: Release 11.2.0.2.0 Production on Tue Aug 27 06:10:32 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Create a table EMPLOYEE with Imp_id , Name, Branch, SALARY:
SQL> create table EMPLOYEE ( Imp_id number (5), Namevarchar (20), Branchchar (5), SALARY NUMBER(10));
Table created.
SQL> desc EMPLOYEE;
Name Null? Type
----------------------------------------- -------- ----------------------------
Imp_id NUMBER (5)
NAME VARCHAR2(20)
BRANCH CHAR2(5)
SALARY NUMBER(10)

Three types to Insert the data in the table:
Type-1: -
SQL> Insert into Employee values (1,'Nitish','CS', '100000');
1 row created.
Type-2: -
SQL> Insert into Employee (Imp_id, Name, Branch, SALARY ) values (2,'Nishant','EC', '100000');
1 row created.
Type-3: -
SQL> Insert into Employee values (&Imp_id, '&Name', '&Branch', '& SALARY');
Enter value for Imp_id: 3
Enter value for Name: Rohan
Enter value for Branch: ME
Enter value for SALARY: 100000
old 1: insert into employee’svalues (&Imp_id, '&NAME', '&BRANCH', '& SALARY')
new 1: insert into employee’s values(3,'Rohan','ME','20-jan-1996')
1 row created.
Insert NULL Value in any Attribute:
SQL> Insert into Employee values (4,'Ronak','EX', '100000 ');
1 row created.
To Print the data in the table:
SQL> select * from Employee;
Imp_id NAME BRANCH SALARY
---------- -------------------- ---------- ---------
1 Nitish CS 100000
2 Happy EC 100000
3 Rohan ME 100000
4 Ronak EX 100000
Update the value of DOB in where Imp_id is 4:
SQL> update Employee set DOB=25-dec-1998 where Roll_No. = 4;
1 row updated.
To Print the data in the table:
SQL> select * from Employeet;
Imp_id NAME BRANCH SALARY
---------- -------------------- ---------- ---------
1 Nitish CS 100000
2 Nishant EC 100000
3 Rohan ME 100000
4 Ronak EX 100000
Delete the rowfrom employeewhere Imp_id is 3:
SQL>delete from Employee where Roll_No. = 3;
1 row deleted.

To Print the data in the table:
SQL> select * from Employee;
Imp_id NAME BRANCH SALARY
---------- -------------------- ---------- ---------
1 Nitish CS 100000
2 Nishant EC 100000
4 Ronak EX 100000
Use Commit command to save data in Database:
SQL> commit;
Commit complete.
Insert the data in the table:
SQL> Insert into Employee values(5,'Ram','CE','100000');
1 row created.
To Print the data in the table:
SQL> select * from Employee;
Imp_id NAME BRANCH SALARY
---------- -------------------- ----- ---------
1 Nitish CS 100000
2 Nishant EC 100000
4 Ronak EX 100000
5 RamCE 18-SEP-98
Use Rollback command to delete data after using Commit command :
SQL> rollback;
Rollback complete.
To Print the data in the table:
SQL> select * from Employee;
Imp_id NAME BRANCH SALARY
---------- -------------------- ----- ---------
1 Nitish CS 100000
2 Nishant EC 100000
4 Ronak EX 100000