Page 1 of 1
Write the SQL code to produce a list of all the customer names in which the first letter of the first and last names is
Posted: Mon May 09, 2022 7:10 am
by answerhappygod
- Write The Sql Code To Produce A List Of All The Customer Names In Which The First Letter Of The First And Last Names Is 1 (22.3 KiB) Viewed 69 times
Write the SQL code to produce a list of all the customer names in which the first letter of the first and last names is in uppercase and the rest are in lower case. CREATE TABLE Customers (Customer NUMBER(4), LastName VARCHAR2(10) NOT NULL FirstName VARCHAR2(10) NOT NULL Address VARCHAR2/20). City VARCHAR2(12) State VARCHAR212) Zip VARCHAR2(5) Referred NUMBER(4). Region CHAR(2) Email VARCHAR2(30) CONSTRAINT customers customer_pk PRIMARY KEY(customert). CONSTRAINT customers region ck CHECK (region IN ('N: 'NW' 'NE'S SE SW: WE'))