How to find a TAB Character in a Table.
568138Mar 21 2007 — edited Mar 21 2007Data Base : Oracle
I have a table name "EMPLOYEE" which has 2 columns
employee_Name and employee_number.
I have all the data available in Textpad. This textpad contains all the employee name and employee number information.
We are manually copying the data from the textpad and pasting into the table through TOAD.
since we are manually copying the data from the textpad and pasting into table, there are some TAB ('\t') characters that is present in the textpad that copied into the table employee.employee_name column.
I want to find out the list of records that has the TAB Characters in the employee.employee_name column.
please let me know, what SQL query i have use to find out the invalid records.