OraFAQ Forum: SQL & PL/SQL » how to select rows using datatypes

Home » SQL & PL/SQL » SQL & PL/SQL » how to select rows using datatypes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to select rows using datatypes [message #233438]

Thu, 26 April 2007 02:44

s_karthik215
Messages: 4
Registered: April 2007
Location: Chennai

Junior Member

hi,

I am having an employee table and in that table employee_number column is there.and it is of varchar2 datatype.
but values in that columns r in numbers.but there r some column with varchar2 values.

and now i need to get only those columns which r in varchar2 datatype from employee_number column.

how can i do this.

rgds,
Karthik

Report message to a moderator

Re: how to select rows using datatypes [message #233440 is a reply to message #233438]

Thu, 26 April 2007 02:49

Frank
Messages: 7901
Registered: March 2000

Senior Member

Search this forum for is_numeric.

Report message to a moderator

Previous Topic:	Constraint Error
Next Topic:	Need help on view..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 14:50:31 CST 2024