Home » SQL & PL/SQL » SQL & PL/SQL » how to select rows using datatypes
how to select rows using datatypes [message #233438] Thu, 26 April 2007 02:44 Go to next message
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
Re: how to select rows using datatypes [message #233440 is a reply to message #233438] Thu, 26 April 2007 02:49 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Search this forum for is_numeric.
Previous Topic: Constraint Error
Next Topic: Need help on view..
Goto Forum:
  


Current Time: Sat Dec 03 06:13:41 CST 2016

Total time taken to generate the page: 0.11611 seconds