- 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 70 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
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
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
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'))
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!