CREATE TABLE NewTab AS SELECT * FROM HR.EMPLOYEES;

SELECT * FROM NewTab WHERE EMPLOYEE_ID=130;

ALTER TABLE NewTab ADD CONSTRAINT PK_NEWTAB PRIMARY KEY (EMPLOYEE_ID);

SELECT * FROM NEWTAB WHERE EMPLOYEE_ID BETWEEN 100 AND 170;

SELECT COUNT(*) FROM NewTab;

CREATE INDEX emp_dept_idx ON NewTab(DEPARTMENT_ID);

SELECT * FROM NewTab WHERE DEPARTMENT_ID=110;

CREATE INDEX emp_lname_idx ON NewTab (LAST_NAME);

SELECT * FROM NewTab WHERE LAST_NAME = 'Urman';

SELECT * FROM NewTab WHERE LAST_NAME LIKE 'Ur%';

SELECT * FROM NewTab WHERE LAST_NAME LIKE '%man';

SELECT /*+ index(NewTab emp_lname_idx) */ * FROM NewTab WHERE last_name LIKE '%man';