Q1) Alter your emp table to add a new column password with CHAR(7) datatype. The result should be like below:[image below src__q.png] Q2). Please write a DML statement to update password data in your emp table password column. The password data formular should be the first three characters of the ename concates deptno concates the first two digits of empno. The result should be like below: [image below src__q2.png][Before DML Statement] Martial needed to answer the questions above:https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharinghttps://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing [Check your Table Structure Before altering emp]SQL> DESC empNameNull?ТуреNOT NULL NUMBER ( 4)VARCHAR2 (10)VARCHAR2 (9)NUMBER ( 4)EMPNOENAMEJÓBMGRHIREDATEDATENUMBER ( 7,2)NUMBER ( 7,2)NOT NULL NUMBER (2)SALCOMMDEPTNOSQL> ALTER TABLE emp ADD(.....);[Check your Table Structure After altering emp]SQL> DESC empNameNull?ТуреEMPNONOT NULL NUMBER (4)ΕΝΜΕVARCHAR2 (10)JOBVARCHAR2 (9)MGRNUMBER (4)HIREDATEDATENUMBER ( 7,2)NUMBER (7,2)NOT NULL NUMBER (2)SALCOMMDEPTNOPASSWORDCHAR (7) SQL> SELECT * FROM emp;EMPNO ENAMEJOBMGR HIREDATESALCOMMDEPTNO PASSWOR7839 KINGPRESIDENT17-NOV-815000107698 BLAKEMANAGER7839 01-MAY-812850307782 CLARKMANAGER7839 09-JUN-812450107566 JONESMANAGER7839 02-APR-812975207654 MARTINSALESMAN7698 28-SEP-8112501400307499 ALLENSALESMAN7698 20-FEB-811600300307844 TURNERSALESMAN7698 08-SEP-811500307900 JAMESCLERK7698 03-DEC-81950307521 WARDSALESMAN7698 22-FEB-811250500307902 FORDANALYST7566 03-DEC-813000207369 SMITHCLERK7902 17-DEC-80800207788 SCOTTANALYST7566 09-DEC-823000207876 ADAMSCLERK7788 12-JAN-831100207934 MILLERCLERK7782 23-JAN-82130010SQL> UPDATE empSET password = ..;[After DML Statement]SQL> SELECT * FROM emp;ΕMPNO ΕΝΑΜΕJOBMGR HIREDATESALCOMMDEPTNO PASSWOR7839 KINGPRESIDENT17-NOV-81500010 KIN10787698 BLAKEMANAGER7839 01-MAY-81285030 BLA30767782 CLARKMANAGER7839 09-JUN-81245010 CLA10777566 JONESMANAGER7839 02-APR-81297520 JON20757654 MARTINSALESMAN7698 28-SEP-811250140030 MAR30767499 ALLENSALESMAN7698 20-FEB-81160030030 ALL30747844 TURNERSALESMAN7698 08-SEP-81150030 TUR30787900 JAMESCLERK7698 03-DEC-8195030 JAM30797521 WARDSALESMAN7698 22-FEB-81125050030 WAR30757902 FORDANALYST7566 03-DEC-81300020 FOR20797369 SMITHCLERK7902 17-DEC-8080020 SMI20737788 SCOTTANALYST7566 09-DEC-82300020 SC020777876 ADAMSCLERK7788 12-JAN-83110020 ADA20787934 MILLERCLERK7782 23-JAN-82130010 MIL1079

concat(concat(substr(ename,1,3),deptno),substr(empno,1,2) ) use concat function to concatenate…

Answered: Q1) Alter your emp table to add a new…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Q1) Alter your emp table to add a new column password with CHAR(7) datatype. The result should be like below:

[image below src__q.png]

Q2). Please write a DML statement to update password data in your emp table password column. The password data formular should be the first three characters of the ename concates deptno concates the first two digits of empno. The result should be like below:

[image below src__q2.png]

[Before DML Statement]

Martial needed to answer the questions above:

https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing
https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing

[Check your Table Structure Before altering emp]
SQL> DESC emp
Name
Null?
Туре
NOT NULL NUMBER ( 4)
VARCHAR2 (10)
VARCHAR2 (9)
NUMBER ( 4)
EMPNO
ENAME
JÓB
MGR
HIREDATE
DATE
NUMBER ( 7,2)
NUMBER ( 7,2)
NOT NULL NUMBER (2)
SAL
COMM
DEPTNO
SQL> ALTER TABLE emp ADD(.....);
[Check your Table Structure After altering emp]
SQL> DESC emp
Name
Null?
Туре
EMPNO
NOT NULL NUMBER (4)
ΕΝΜΕ
VARCHAR2 (10)
JOB
VARCHAR2 (9)
MGR
NUMBER (4)
HIREDATE
DATE
NUMBER ( 7,2)
NUMBER (7,2)
NOT NULL NUMBER (2)
SAL
COMM
DEPTNO
PASSWORD
CHAR (7)

SQL> SELECT * FROM emp;
EMPNO ENAME
JOB
MGR HIREDATE
SAL
COMM
DEPTNO PASSWOR
7839 KING
PRESIDENT
17-NOV-81
5000
10
7698 BLAKE
MANAGER
7839 01-MAY-81
2850
30
7782 CLARK
MANAGER
7839 09-JUN-81
2450
10
7566 JONES
MANAGER
7839 02-APR-81
2975
20
7654 MARTIN
SALESMAN
7698 28-SEP-81
1250
1400
30
7499 ALLEN
SALESMAN
7698 20-FEB-81
1600
300
30
7844 TURNER
SALESMAN
7698 08-SEP-81
1500
30
7900 JAMES
CLERK
7698 03-DEC-81
950
30
7521 WARD
SALESMAN
7698 22-FEB-81
1250
500
30
7902 FORD
ANALYST
7566 03-DEC-81
3000
20
7369 SMITH
CLERK
7902 17-DEC-80
800
20
7788 SCOTT
ANALYST
7566 09-DEC-82
3000
20
7876 ADAMS
CLERK
7788 12-JAN-83
1100
20
7934 MILLER
CLERK
7782 23-JAN-82
1300
10
SQL> UPDATE emp
SET password = ..;
[After DML Statement]
SQL> SELECT * FROM emp;
ΕMPNO ΕΝΑΜΕ
JOB
MGR HIREDATE
SAL
COMM
DEPTNO PASSWOR
7839 KING
PRESIDENT
17-NOV-81
5000
10 KIN1078
7698 BLAKE
MANAGER
7839 01-MAY-81
2850
30 BLA3076
7782 CLARK
MANAGER
7839 09-JUN-81
2450
10 CLA1077
7566 JONES
MANAGER
7839 02-APR-81
2975
20 JON2075
7654 MARTIN
SALESMAN
7698 28-SEP-81
1250
1400
30 MAR3076
7499 ALLEN
SALESMAN
7698 20-FEB-81
1600
300
30 ALL3074
7844 TURNER
SALESMAN
7698 08-SEP-81
1500
30 TUR3078
7900 JAMES
CLERK
7698 03-DEC-81
950
30 JAM3079
7521 WARD
SALESMAN
7698 22-FEB-81
1250
500
30 WAR3075
7902 FORD
ANALYST
7566 03-DEC-81
3000
20 FOR2079
7369 SMITH
CLERK
7902 17-DEC-80
800
20 SMI2073
7788 SCOTT
ANALYST
7566 09-DEC-82
3000
20 SC02077
7876 ADAMS
CLERK
7788 12-JAN-83
1100
20 ADA2078
7934 MILLER
CLERK
7782 23-JAN-82
1300
10 MIL1079

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions