how to divide a column into two

[abhasinha]

hi
There is two columns in table name and emp...name column contains the names of some people and emp is a flag--'y' or'n'.we are suppossed to divide the name column into two columns emp_name and nomemp_name depending on the value of the flag 'y' and 'n' respectively..
can u plz tell me how it can be done??

[Reshmi Jacob]

Hello


Try this
SELECT DECODE(emp,'Y',Name,'') emp_name , DECODE(emp,'Y','',Name) nomemp_name FROM Table;

From your mail I understood that you need to make a query only(Not a table!!!)

If its a table , then CREATE TABLE Newtable AS (select ..)


Regards
Reshmi

[saravanankm]

Hi

Use Decode Function To divide A column into two column.

hi reshmi ur decode qry Option same Condition. It wil give same result of
two column.

pls Try this condition

SELECT DECODE(emp,'Y',Name) emp_name , DECODE(emp,'N',Name) nomemp_name FROM Table;


With regards,
Captain