By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employees (
emp_id NUMBER(10,0),
emp_name VARCHAR2(200),
emp_status VARCHAR2(10)
)
INSERT INTO employees (emp_id, emp_name, emp_status)
SELECT 1, 'Alice', 'Yes' FROM DUAL UNION ALL
SELECT 2, 'Betty', 'Yes' FROM DUAL UNION ALL
SELECT 3, 'Carol', 'Yes' FROM DUAL UNION ALL
SELECT 4, 'Debra', 'Yes' FROM DUAL UNION ALL
SELECT 5, 'Emily', 'Yes' FROM DUAL UNION ALL
SELECT 6, 'Fiona', 'Yes' FROM DUAL UNION ALL
SELECT 7, 'Gerri', 'No' FROM DUAL UNION ALL
SELECT 8, 'Harry', 'Yes' FROM DUAL UNION ALL
SELECT 9, 'Izzie', 'Yes' FROM DUAL UNION ALL
SELECT 10, 'Jenny', 'Yes' FROM DUAL UNION ALL
SELECT 11, 'Kerry', 'No' FROM DUAL UNION ALL
SELECT 12, 'Laura', 'Yes' FROM DUAL UNION ALL
SELECT 13, 'Megan', 'Yes' FROM DUAL UNION ALL
SELECT 14, 'Naomi', 'Yes' FROM DUAL UNION ALL
SELECT 15, 'Olive', 'No' FROM DUAL UNION ALL
SELECT 16, 'Penny', 'Yes' FROM DUAL UNION ALL
SELECT NULL, NULL, NULL FROM DUAL CONNECT BY LEVEL <= 10
26 rows affected
CREATE TYPE key_value_pair IS OBJECT(
key VARCHAR2(4000),
value VARCHAR2(4000)
);
SELECT *
FROM employees
WHERE emp_id IS NULL
AND emp_name IS NULL
AND emp_status IS NULL
| EMP_ID | EMP_NAME | EMP_STATUS |
|---|---|---|
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
| null | null | null |
DELETE FROM employees
WHERE emp_id IS NULL
AND emp_name IS NULL
AND emp_status IS NULL
10 rows affected
ALTER TABLE employees MODIFY (
emp_id NUMBER(10,0) NOT NULL,
emp_name VARCHAR2(200) NOT NULL,
emp_status VARCHAR2(10) NOT NULL
)