Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure that the column ‘NAME' should not permit NULL values.
Column name Data type Size
CLIENT_NO Varchar2 6
NAME Varchar2 20
ADDRESS1 Varchar2 30
ADDRESS2 Varchar2 30
CITY Varchar2 15
STATE Varchar2 15
PINCODE Number 6
BAL_DUE Number 10, 2
Ans:
CREATE TABLE CLIENT
( CLIENT_NO VARCHAR2(6) PRIMARY KEY CHECK (CLIENT_NO LIKE
‘C%'),
NAME VARCHAR2(20) NOT NULL,
ADDRESS1 VARCHAR2(30),
ADDRESS2 VARCHAR2(30),
CITY VARCHAR2(15),
STATE VARCHAR2(15),
PINCODE NUMBER(6),
BAL_DUE NUMBER(10,2))