Shulou(Shulou.com)06/01 Report--

Create table emp_dept_txt as select first_name,last_name,email,phone_number,department_name from employees, departments where employees.department_id=departments.department_id and 1: 0

SQL > select * from emp_dept_txt

No rows selected

SQL > desc emp_dept_txt

Name Null? Type

-

FIRST_NAME VARCHAR2 (20)

LAST_NAME NOT NULL VARCHAR2 (25)

EMAIL NOT NULL VARCHAR2 (25)

PHONE_NUMBER VARCHAR2 (20)

DEPARTMENT_NAME NOT NULL VARCHAR2 (30)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.