Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

Table Creation

Q: 1
Create a table Employee with fields
EmpNo         Number (6)          Primary key
Name          Character (25)
Designation   Character (20)
Department    Character (25)
BasicPay      Number (8, 2)
DA            Number (8, 2)
Total         Number (8, 2)


SQL> CREATE TABLE EMPLOYEE(
  2  EMPNO NUMBER(6) PRIMARY KEY,
  3  NAME CHARACTER(25),
  4  DESIGNATION CHARACTER(20),
  5  DEPARTMENT CHARACTER(25),
  6  BASICPAY NUMBER(8,2),
  7  DA NUMBER(8,2),
  8  TOTAL NUMBER(8,2));

Table created.