Search found 1 match
- Sat May 15, 2021 1:31 pm
- Forum: Oracle Discussion
- Topic: Is it possible to add or copy one more column to the newly created table by using sub query?
- Replies: 0
- Views: 58209
Is it possible to add or copy one more column to the newly created table by using sub query?
Hi All, One doubt. I have created table by using below query👇, CREATE TABLE test_table AS ( SELECT employee_id,salary FROM employees WHERE employee_id IN (100,101,102,103,104,105)) well it is working👍 Now my question is? Is it possible to add or copy one more column to the newly created table by usi...