Пример 1.1.
INSERT INTO emp VALUES (101, 'Willson', 'Jack', null, null, null, null, null, null, null, null);
SELECT first_name, last_name FROM emp WHERE last_name LIKE 'Will%';
FIRST_NAME LAST_NAME
------------------------- -------------------------
Jack Willson
FIRST_NAME LAST_NAME
------------------------- -------------------------
Jack Willson