Move columns from different tables to one table

[ushalakshmi]

u can do this by using select into query.........

For Ex,

Select dno,sal into depsal from dept,emp where sal>1000
select * fom depsal


then we get the new table depsal with dno,sal whose sal >1000........

[krishnaindia2007]

u can do this by using select into query.........

For Ex,

Select dno,sal into depsal from dept,emp where sal>1000
select * fom depsal


then we get the new table depsal with dno,sal whose sal >1000........

Select into is used in PL/SQL to dump value of a column to a variable. It will not create a new table.

In a single statemt you can do it in the following way
CREATE TABLE deptwisesal AS
SELECT emp.sal, dept.deptno
FROM emp,dept
where emp.deptno = dept.deptno;

[debasisdas]

Select dno,sal into depsal from dept,emp where sal>1000
select * fom depsal

that will not create a table for you .