CREATE TABLE DD_Users(
 user_id         INTEGER PRIMARY KEY,
 user_login_name VARCHAR2(30),
 user_category   CHAR(15),
 user_registration_date DATE,
 user_email      VARCHAR2(80),
 user_country    VARCHAR2(80),
 user_language   VARCHAR2(80))
/

CREATE VIEW VW_Users AS
SELECT
user_login_name ,
user_category   ,
user_registration_date,
user_country    ,
user_language   ,
user_email
FROM  table_name -- eg dd_users
/


INSERT INTO dd_Users
(user_id,user_login_name,user_category,user_registration_date,user_email,user_country,user_language)
VALUES (1,'JoeB','BASIC','01-Jan-2003','joebloggs@ukmail.com','UK','English')
/

INSERT INTO dd_Users
(user_id,user_login_name,user_category,user_registration_date,user_email,user_country,user_language)
VALUES (2,'JohnD','Q-BASIC','03-Jan-2003','john.doe@usmail.com','USA','English')
/