Curs - Database Development - Scoala Informala de IT - alexandraioanapetre/Database-Development---SQL ...

#Create table 'emp' SQL> CREATE TABLE emp (empno NUMBER (4) PRIMARY KEY,ename VARCHAR2 (25),job VARCHAR2 (12),salary NUMBER (10,2),commission NUMBER (7,2),deptno NUMBER (2)); Table created.

Of course, if you already have a lot of indexes on the EMP table, you might want to examine the impact of creating yet another index on the table. With the caveat that appropriate index creation can ...