Column segregation using datatype as parameter

Question

I want to know if there is a method in which we can select the columns of a table of a specific datatype in a table that has columns of various datatypes. Say a table has three columns - SSN, Name and phone number where SSN and Name are of Varchar2 and phone number is of number datatype, can I extract only the columns that has its datatype as varchar2(SSN and Name)?

What database engine is that? Oracle? – Luaan Mar 18 '15 at 17:01 — Luaan, Mar 18 '15 at 17:01

score 0 · Accepted Answer · answered Mar 18 '15 at 16:03

0

The following can be the solution :

select Column_Name from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'Tablename' and DATA_TYPE='Varchar'

answered Mar 18 '15 at 16:03

Ram Vanamali

26
2

Eoin2211 · Answer 2 · 2015-03-18T16:35:09.543

0

If I have understood your question correctly then this should work.

select * from TABLE_NAME
where DATA_TYPE = 'Varchar2';

edited Mar 18 '15 at 16:35

answered Mar 18 '15 at 16:10

Eoin2211

911
2
19
39

Im sorry E_McAndrew but the query did not worked. I have got the answer for it. And thank you so much for your help. Appreciate it :) – Vishnu Apr 05 '15 at 15:24

Column segregation using datatype as parameter

2 Answers2