Create a new version of paste:

CEC@USER:~$ sudo su
[sudo] password FOR CEC: 
root@USER:/home/CEC# sqlplus sys AS sysdba
 
SQL*Plus: Release 11.2.0.2.0 Production ON Tue Nov 1 10:27:39 2022
 
Copyright (c) 1982, 2011, Oracle.  ALL rights reserved.
 
Enter password: 
 
Connected TO:
Oracle DATABASE 11g Express Edition Release 11.2.0.2.0 - 64bit Production
 
SQL> DESC exp5
 Name                      NULL?    TYPE
 ----------------------------------------- -------- ----------------------------
 EMPLOYEE_ID                        VARCHAR2(2)
 NAME                      NOT NULL VARCHAR2(10)
 AGE                            NUMBER(38)
 TITLE                          VARCHAR2(10)
 JOINING_DATE                       DATE
 DEPT                           VARCHAR2(20)
 
SQL> UPDATE exp5 SET department ='D1' WHERE employee_id IN('e3','e4','e5');
UPDATE exp5 SET department ='D1' WHERE employee_id IN('e3','e4','e5')
                *
ERROR at line 1:
ORA-00904: "DEPARTMENT": invalid identifier
 
 
SQL> UPDATE exp5 SET dept ='D1' WHERE employee_id IN('e3','e4','e5');
 
0 ROWS updated.
 
SQL> seelct * FROM exp5;
SP2-0734: UNKNOWN command beginning "seelct * f..." - rest OF line ignored.
SQL> SELECT * FROM exp5;
 
EM NAME          AGE TITLE      JOINING_ DEPT
-- ---------- ---------- ---------- -------- --------------------
E1 Mahesh         50 Manager    20-03-67
E2 Nimitha        35 Programmer 02-08-81
E3 Ashitha        28 Programmer 01-09-88
E4 Ajay           32 Technician 23-02-75
E5 Roy            24 Programmer 05-04-90
E6 Sindhu         33 Technician 09-04-84
 
6 ROWS selected.
 
SQL> UPDATE exp5 SET dept ='D1' WHERE employee_id IN('e3','e4','e5');
 
0 ROWS updated.
 
SQL> SELECT * FROM exp5;
 
EM NAME          AGE TITLE      JOINING_ DEPT
-- ---------- ---------- ---------- -------- --------------------
E1 Mahesh         50 Manager    20-03-67
E2 Nimitha        35 Programmer 02-08-81
E3 Ashitha        28 Programmer 01-09-88
E4 Ajay           32 Technician 23-02-75
E5 Roy            24 Programmer 05-04-90
E6 Sindhu         33 Technician 09-04-84
 
6 ROWS selected.
 
SQL> UPDATE exp5 SET dept ='D1' WHERE employee_id IN('E3','E4','E5');
 
3 ROWS updated.
 
SQL> SELECT * FROM exp5;
 
EM NAME          AGE TITLE      JOINING_ DEPT
-- ---------- ---------- ---------- -------- --------------------
E1 Mahesh         50 Manager    20-03-67
E2 Nimitha        35 Programmer 02-08-81
E3 Ashitha        28 Programmer 01-09-88 D1
E4 Ajay           32 Technician 23-02-75 D1
E5 Roy            24 Programmer 05-04-90 D1
E6 Sindhu         33 Technician 09-04-84
 
6 ROWS selected.
 
SQL> commit;
 
Commit complete.
 
SQL> CREATE TABLE emptitle AS SELECT empid, title FROM emp2;
CREATE TABLE emptitle AS SELECT empid, title FROM emp2
                                *
ERROR at line 1:
ORA-00904: "EMPID": invalid identifier
 
 
SQL> CREATE TABLE emptitle AS SELECT employee_id, title FROM emp2;
 
TABLE created.
 
SQL> DESC emptitle;
 Name                      NULL?    TYPE
 ----------------------------------------- -------- ----------------------------
 EMPLOYEE_ID                        VARCHAR2(2)
 TITLE                          VARCHAR2(10)
 
SQL> SELECT * FROM emptitle;
 
EM TITLE
-- ----------
E1 Manager
E2 Programmer
E3 Programmer
E4 Technician
E5 Programmer
E6 Technician
 
6 ROWS selected.
 
SQL> CREATE TABLE empsalary AS SELECT employee_id, salary FROM emp2;
 
TABLE created.
 
SQL> DESC emp2;
 Name                      NULL?    TYPE
 ----------------------------------------- -------- ----------------------------
 EMPLOYEE_ID                   NOT NULL VARCHAR2(2)
 NAME                      NOT NULL VARCHAR2(10)
 AGE                            NUMBER(38)
 SALARY                         FLOAT(126)
 TITLE                          VARCHAR2(10)
 JOINING_DATE                       DATE
 
SQL> DESC exp5;
 Name                      NULL?    TYPE
 ----------------------------------------- -------- ----------------------------
 EMPLOYEE_ID                        VARCHAR2(2)
 NAME                      NOT NULL VARCHAR2(10)
 AGE                            NUMBER(38)
 TITLE                          VARCHAR2(10)
 JOINING_DATE                       DATE
 DEPT                           VARCHAR2(20)
 
SQL> CREATE TABLE depttable AS SELECT dept AS dept_id FROM exp5;
 
TABLE created.
 
SQL> SELECT * FROM depttable;
 
DEPT_ID
--------------------
 
 
D1
D1
D1
 
 
6 ROWS selected.
 
SQL> DROP TABLE depttable;
 
TABLE dropped.
 
SQL> CREATE TABLE depttable AS SELECT DISTINCT dept AS dept_id FROM exp5;
 
TABLE created.
 
SQL> SELECT * FROM depttable;
 
DEPT_ID
--------------------
 
D1
 
SQL> DROP TABLE depttable;
 
TABLE dropped.
 
SQL> UPDATE exp5 SET dept ='D3' WHERE employee_id IN('E1');
 
1 ROW updated.
 
SQL> UPDATE exp5 SET dept ='D4' WHERE employee_id IN('E2');
 
1 ROW updated.
 
SQL> UPDATE exp5 SET dept ='D2' WHERE employee_id IN('E6');
 
1 ROW updated.
 
SQL> CREATE TABLE depttable AS SELECT DISTINCT dept AS dept_id FROM exp5;
 
TABLE created.
 
SQL> SELECT * FROM depttable;
 
DEPT_ID
--------------------
D1
D3
D2
D4
 
SQL> ALTER TABLE depttable ADD department;
ALTER TABLE depttable ADD department
                          *
ERROR at line 1:
ORA-02263: need TO specify the datatype FOR this COLUMN
 
 
SQL> ALTER TABLE depttable ADD department VARCHAR(20);
 
TABLE altered.
 
SQL> SELECT * FROM depttable orderby dept_id;
SELECT * FROM depttable orderby dept_id
                                *
ERROR at line 1:
ORA-00933: SQL command NOT properly ended
 
 
SQL> SELECT * FROM depttable ORDER BY dept_id;
 
DEPT_ID          DEPARTMENT
-------------------- --------------------
D1
D2
D3
D4
 
SQL> SELECT * FROM depttable;
 
DEPT_ID          DEPARTMENT
-------------------- --------------------
D1
D3
D2
D4
 
SQL> SELECT * FROM exp5;
 
EM NAME          AGE TITLE      JOINING_ DEPT
-- ---------- ---------- ---------- -------- --------------------
E1 Mahesh         50 Manager    20-03-67 D3
E2 Nimitha        35 Programmer 02-08-81 D4
E3 Ashitha        28 Programmer 01-09-88 D1
E4 Ajay           32 Technician 23-02-75 D1
E5 Roy            24 Programmer 05-04-90 D1
E6 Sindhu         33 Technician 09-04-84 D2
 
6 ROWS selected.
 
SQL> UPDATE exp5 SET dept='D4' WHERE empid='E1';
UPDATE exp5 SET dept='D4' WHERE empid='E1'
                                *
ERROR at line 1:
ORA-00904: "EMPID": invalid identifier
 
 
SQL> UPDATE exp5 SET dept='D4' WHERE employee_id='E1';
 
1 ROW updated.
 
SQL> UPDATE exp5 SET dept='D2' WHERE employee_id='E2';
 
1 ROW updated.
 
SQL> SELECT * FROM exp5;
 
EM NAME          AGE TITLE      JOINING_ DEPT
-- ---------- ---------- ---------- -------- --------------------
E1 Mahesh         50 Manager    20-03-67 D4
E2 Nimitha        35 Programmer 02-08-81 D2
E3 Ashitha        28 Programmer 01-09-88 D1
E4 Ajay           32 Technician 23-02-75 D1
E5 Roy            24 Programmer 05-04-90 D1
E6 Sindhu         33 Technician 09-04-84 D2
 
6 ROWS selected.
 
SQL> UPDATE depttable SET department ='Production' WHERE dept_id='D1';
 
1 ROW updated.
 
SQL> UPDATE depttable SET department ='R and D' WHERE dept_id='D2';
 
1 ROW updated.
 
SQL> UPDATE depttable SET department ='Purchasing' WHERE dept_id='D3';
 
1 ROW updated.
 
SQL> UPDATE depttable SET department ='Marketing' WHERE dept_id='D4';
 
1 ROW updated.
 
SQL> SELECT * FROM depttable;
 
DEPT_ID          DEPARTMENT
-------------------- --------------------
D1           Production
D3           Purchasing
D2           R AND D
D4           Marketing
 
 DATE
 DATE : 1/11/2022 , 10-12 dbms lab, Experiment 5 ;