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
Messages: 4
Registered: April 2007
Location: Chennai
Junior Member

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.

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
Messages: 7880
Registered: March 2000
Senior Member
Search this forum for is_numeric.
Previous Topic: How To Set Thursday and Friday as Weekends in the database
Next Topic: join query between two same table structure
Goto Forum:

Current Time: Wed Aug 23 10:24:11 CDT 2017

Total time taken to generate the page: 0.01737 seconds